Skip to main content

Oracle Hyperion Reporting Basic Tutorial

HFS of Hyperion
#HFS of Hyperion
Interactive Reporting is an extremely robust and powerful business intelligence tool providing ad-hoc querying, data analysis, dashboards, and other reporting capabilities.

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 of the EPM Workspace.

What is EPM workspace?

The EPM Workspace is similar to a portal, where all Oracle Hyperion applications, reports, and other files can be accessed and integrated using a shared security model. The Workspace is accessible through the web browser and contains a filesystem and other gadgets including personal pages and content subscription. Interactive Reporting is one of the many products that integrate with the Workspace, providing users a central location to save, share, and publish content.

Web client interface topics?

Understanding the Web Client interface is crucial to being proficient in the product. The different sections of the software contain a variety of different options, but the location of where to find and utilize these options is the same across the tool. Knowledge of the interface and how to leverage the features of each section is key to unlock the full potential of the product.
The sections of an Interactive Reporting document are the different objects in the software used to aid in querying, analyzing, or displaying information. There are seven types of unique sections. The specifics of each section will be addressed in the following chapters:
  • The Query section is the main section used to setup and execute a query from a relational or multi-dimensional database.
  • Each Query section is accompanied by a Results section where the data returned from the Query is displayed and can be manipulated.
  • The Table section is similar to the Results section and is used to manipulate and split a dataset into different subsets for analysis.
  • The Pivot section is specific to a Results or Table section, and is used to graphically display data in pivot table format—similar to Microsoft Excel Pivots.
  • The Chart section is also specific to a Results or Table section and is used to display data in a chart.
  • The Report section provides the ability to present pivots, charts, and tables of data in a well formatted document.
  • Dashboards are used to create custom interfaces or interactive displays of key metrics.

Comments

Popular posts

Blue Prism complete tutorials download now

RPA blue prsim tutorial popular resources I have given in this post. You can download quickly.Learning Blue Prism is really good option if you are learner of Robotic process automation. The RPA is also called "Robotic Process Automation"- Real advantages are you can automate any business process and you can complete the customer requests in less time.

The Books Available on Blue Prism 
Blue Prism resourcesDavid chappal PDF bookBlue Prism BlogsVideo Training
RPA training The other Skills you need
Basic business skills and Domain skills are more than enough to be successful in this automation careerScripting languages like Perl/JSON/JavaScript/VBScript.  The interesting point is learning any RPA tool is not a problem. You can learn tool quickly. The real point is how quickly you apply your knowledge to implement automated tasks is important.


Also read
Robotic RPA Software developer skills you needBlue Prism tutorials download to learn quicklyPopular RPA tools functionality differen…

Three popular RPA tools functional differences

Robotic process automation is growing area and many IT developers across the board started up-skill in this popular area. I have written this post for the benefit of Software developers who are interested in RPA also called Robotic Process Automation.

In my previous post, I have described that total 12 tools are available in the market. Out of those 3 tools are most popular. Those are Automation anywhere, BluePrism and Uipath. Many programmers asked what are the differences between these tools. I have given differences of all these three RPA tools.

BluePrismBlue Prism has taken a simple concept, replicating user activity on the desktop, and made it enterprise strength. The technology is scalable, secure, resilient, and flexible and is supported by a comprehensive methodology, operational framework and provided as packaged software.The technology is developed and deployed within a “corridor of IT governance” and has sophisticated error handling and process modelling capabilities to ensu…

HBASE hadoop database really new features to handle growing data volumes

Hbase is Java implementation of Google's Big table. The data stored in HABSE is as shown below. Which is actually two parts.
Row Key : 00001 Column  : (Column Qualifier:Version:Value)Features or key points of HBASE...
HBase data stores consist of one or more tables, which are indexed by row keys.Data is stored in rows with columns, and rows can have multiple versions.By default, data versioning for rows is implemented with time stamps.Columns are grouped into column families, which must be defined up front during table creation. Column families are stored together on disk, which is why HBase is referred to as a column-oriented data storeIn addition...
HBASE is distributed data store,which leverages a network attached cluster of low-cost commodity servers to store and persist data.HBASE architecture is littel trick to know.

Region Servers...
RegionServers are the software processes (often called daemons) you activate to store and retrieve data in HBase.

The big difference...
Main poin…