Posts

Showing posts with the label Hyperion

Featured Post

SQL Query: 3 Methods for Calculating Cumulative SUM

Image
SQL provides various constructs for calculating cumulative sums, offering flexibility and efficiency in data analysis. In this article, we explore three distinct SQL queries that facilitate the computation of cumulative sums. Each query leverages different SQL constructs to achieve the desired outcome, catering to diverse analytical needs and preferences. Using Window Functions (e.g., PostgreSQL, SQL Server, Oracle) SELECT id, value, SUM(value) OVER (ORDER BY id) AS cumulative_sum  FROM your_table; This query uses the SUM() window function with the OVER clause to calculate the cumulative sum of the value column ordered by the id column. Using Subqueries (e.g., MySQL, SQLite): SELECT t1.id, t1.value, SUM(t2.value) AS cumulative_sum FROM your_table t1 JOIN your_table t2 ON t1.id >= t2.id GROUP BY t1.id, t1.value ORDER BY t1.id; This query uses a self-join to calculate the cumulative sum. It joins the table with itself, matching rows where the id in the first table is greater than or

Hyperion: How to Learn as Alternative for Mainframe

Image
Oracle Hyperion is a reporting tool. Its applications are Capital management, Asset planning, Workforce planning and more. Photo Credit: Srini Books to Read on Hyperion The Oracle Hyperion Financial Reporting 11 covers all basics to learn financial reporting using Hyperion tool. The popular contents are Explore Grids and the Point of View Create Functions and Formulas Master Conditional Formatting and Conditional Suppression Create Dynamic Books and Batches Import Reporting Content into MS Office with Oracle Smart View

Oracle Hyperion Reporting Basic Tutorial

Image
Interactive Reporting is an extremely robust and powerful business intelligence tool providing ad-hoc querying, data analysis, dashboards, and other reporting capabilities. Oracle Hyperion Financial Management Business analysts access the software through the EPM Workspace, a central location for viewing and managing content across all of the Hyperion products. The product is extremely flexible and provides analysts with the ability to quickly analyze data and produce deliverables. The software provides a consistent platform for managing content, where documents can be customized, saved, and shared across an organization. What is BQY When working with Interactive Reporting, it is hard to escape the term BQY. BQY or BrioQuery, is the extension given to all Interactive Reporting document files. Developers create BQY files using the Workspace, Interactive Reporting Web Client, or Interactive Reporting Studio—a developer tool used to create and manage BQY documents outside