09 October, 2020
When you create a multi-currency planning application, it generates an “l” standard dimension, and you can add “13” more dimensions.
When we add the members under the account dimension, we have to select the appropriate account type for the measures.
Ex: No of units sold, unit price, account
The type of variance reporting decides how the variance formula is going to calculated for the measures. If the variance reporting type is an expense, then it uses the formula Budget – Actual. If the variance reporting is non-expense then it will use formula Actual – Budget.
Time Balance property decides how to calculate the values of the measure across the time period. All the Revenue and Expense Account types will use the as a time balance as this measure will be summarized across the Time Period.
Assets and Liability account types come under the category of Balance as a time balance property as these measures will not be summarized across the time period.
When you open a currency dimension, you will see one currency is added by default and that is reporting currency or Base currency according to the selection we have made at the time of application creation.
It is used to represent company business location by region wise.
Inclined to build a profession as Hyperion Planning? Then here is the blog post on, explore Hyperion Planning
It is used to group all the related data, and it can have actual, Budget, and Forecast members.
By default, we all get a scenario called current is created, and we can use this member or Delete this member.
It is used to maintain different versions of data for the same scenario members.
This dimension is used to maintain different budget data by expecting different market conditions.
There are two types of versions
Once we built the metadata then we have to push this metadata, into the Essbase server by using the following steps.
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .