help with External Rollups

[rraju73]

HI,
i am having a problem with display of measures which have external rollup.
i see all 0's for that measure in the cube.i see that there is data in the iqd which i am using as data source.
please guide me where and what i should check for that to make changes and display measure values in powerplay report.
hope my question is clear.
thank you
raju

 

[andymac2004]

Raju,

Once you have set the proerties of your IQD and measures as External rollup, you then need to tell transformer which column in your IQD to use to retrieve the category Ids per dimension.

Eg. I have an exsternally rolled up data source with 3 columns TimeCat, ProdCat, Value

The Column TimeCat contains all the values for my time dimenson, ProdCat contins all the values for my Product dimension and then value is my Measure.

I then go into the properties of the time dimension and set my External Rollup Column to TimeCat and the My Porudct dimension to ProdCat.

Hope this Helps

Andy

Sample Table;

TimeCat ProdCat Value
Y2003 Tent 100
Y2004 Stove 50
Y2003Q1 Tent 25
Y2003Q2 Stove 3