I have the following scenerio.
- My PowerPlay v7.3 cube is a financial statement.
- It has 2 dimensions; Business Unit (BU) and Statement Line.
- Each BU has a "Growth Target %" for the fiscal year.
- I want to display the "Growth Target %" along side the "Actual Growth %".
- The "Growth Target %" is assiged by BU and Statement Line.
- For example, Bags, Sales, 10%
- The BU dimension has this hierarchy: Division, Major Business, BU.
- The Statment Line dimension has just 1 level.
I am unable to get the External Rollup to work with a single datasource defined as Year, BU, Statement Line, Growth Target % and the BU dimension referencing the BU category and the Statement Line dimension referencing the Statement Line category and the All Dates dimension referencing the Year category. The Growth Target % is set as the measure with External rollup.
Is it possible to set up an external rollup measure in this fashion... 1 measure across 2 dimensions?
Thx,
Larry
Disclaimer: I have avoided external rollups like the plague so have no direct experience here, but...
From what I read in the Transformer help (Step-by-Step Transformer) there are no limits on number of dimensions or anything like that with external rollups. Nothing you've described seems to conflict with their methodology. What is the problem you're experiencing?
FWIW, if you're doing this just to flip signs I suggest moving that logic upstream and letting Transformer handle the rollups.
If you're doing this because of Finance's insistence that they are the only ones capable of adding up numbers hierarchically (or because they can't), I feel your pain...
Thx... I decided to avoid External Rollup's as well.