I'm trying to create a Custom rollup aggregation, so I didn't know how to perform this in BIDS. This what I did
I have a DimTime dimension table which has Time Hierarchy as follow Year>Semester>Quarter>Month. Years are 2006,2007,2008,2009,2010 just for test.
I went to the SSMS and created a new column in the DimTime dimension table. I added a formula for each row in that column to illustrate the LastChild instead of the default Sum aggregation for that I designed the fomula to be [DimTime].[Time Hierarchy].[Year].LastChild
I turned back to the BIDS where I pointed the CustomRollupColumn property of the Year attribute in the DimTime dimension to use the new created column.
The dimension and cube process are done without problems. But when I tried(brose the cube) to add a measure into the details zone, then the result was not data, empty as if there were no data in the data base. I tried to drag the hierarchy at the
rows level then years simply disapair, I tried to reconnect but same result. So I failed to apply customrollup using BIDS to illusrate the lastchild instead of the sum. Is that any missing or wrong steps those lead me to this failure
The complexity resides in the simplicity
View Complete Post