When building an Essbase dimension build file, 99% of the time, I will build it using a Parent / Child relationship. I feel its the easiest to maintain and shared members are added automatically. Here's a simple example for the Scenario dimension:
Scenario|Actual|+|
Scenario|Budget|~|
Scenario|Forecast|~|
Scenario|Revised Forecast|~|
In case you were wondering what the + and ~ mean or need more properties, here's a good list for you:
Essbase Member Properties for Aggregate Storage Database
% Set consolidation to express as a percentage of current total.
* Set consolidation to multiply by the current total
+ Set consolidation to add to the current total
Showing posts with label Outline. Show all posts
Showing posts with label Outline. Show all posts
Wednesday, December 9, 2015
Monday, November 2, 2015
Essbase EAS Error 1250053
I was recently working with a client that wanted me to take a look at their outline, specifically to optimize MDX member formulas. They sent over the .otl file and when I opened it up, I received the following error message:
I did some searches and was coming up empty.
I did some searches and was coming up empty.
Subscribe to:
Posts (Atom)
