If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

add new dimension to Contributor built mdl

Started by i-guy, 28 Jul 2005 04:43:03 PM

Previous topic - Next topic

i-guy

hey.
we use Contributor to create the mdl that reflects the Contributor model/data, off of published data.

contrib model only has 4 dimensions.
we now want to add another dimension in Transformer only, to show an alternate rollup.
eg. model rolls up by Business, new dimension would rollup by Region.

anyone done this before?
the iqd's and mdl that are built from Contrib are pretty complex.
anyone know of somewhere I can see an example? thx a million.

Darek

You could use Transofrmer's MDL langugae to open the generated model and add what you need. Or do it using GUI, but than, everytime the Contributor model changes, you will have to repeat what you've done.

i-guy

Hey.
I see this has been viewed a few times, so I'll post what I ended up doing.

The issue totally revolved around the mdl being built from Contrib extension using external rollups.
ie. the numbers in the cube do not really roll up via calculation, but are provided by the Publish.
Because of ext rollups, I could not easily add the dimension.

But, because we were publishing lots of data at the detail level, I was able to find a solution.
I reconfgured all the original dimensions to NOT be external rollups, and also added my own dimension at that point, and manually created a cal hier for it to reference, and added that to the datasource.

huge pain in the ass, but all the numbers tied out at the end of the day.

morla of the story is that is is very difficult to manipulate contrib generated mdls becaus of hte external rollup feature. If I had any complex calcs involved in my rollups, I would not have been able to do this.

cheers.