Posts

MAP REPORTING APPLICATION IN HYPERION PLANNING

Image
What is Mapping Applications for Reporting in planning? Hyperion Planning allows for a web-based solution to facilitate the mapping and loading of  data from a Hyperion Planning application into a target reporting application.   Source Application     :   Hyperion Planning.  Target Application      :   Essbase Block Storage Option (BSO) or                                           Essbase Aggregate Storage Option (ASO). The primary use cases are : We will push data from Hyperion planning to one or more reporting applications.           Y ou can do report on Planning Smart Lists, by converting them into regular dimensions.       Now, let us consider the creation of reporting application:     1. Create target reporting application which can be...

Differences between Ignore (~) vs Never(^) consolidation properties

Image
Let us discuss about what are the differences  between ignore and never consolidation .       Ignore consolidation :              When you set any member in the Database outline as Ign ore(~), that means Essbase does not consider that member value into its parent level in aggregation/rollup.        Let us discuss with an example:          From the above figures, we came to notice that, under Account dimension, I had given "No account"  as child with a consolidation property as  "ignore".  Now you can see the difference in aggregation. From the aggregated result you can see that, value of "No account" is aggregated to "Period" dimension but not to "Account" dimension (i.e.., No Account -> period =100+200=300 and No Account -> Account =300 only). Because we set "No Account" is considered as ignore.So that we can say that, if a member is...