Author Topic: add new dimension to Contributor built mdl  (Read 2141 times)

Offline i-guy

  • Associate
  • **
  • Join Date: Jul 2005
  • Posts: 4
  • Forum Citizenship: +0/-0
add new dimension to Contributor built mdl
« on: 28 Jul 2005 04:43:03 pm »
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

  • Guest
Re: add new dimension to Contributor built mdl
« Reply #1 on: 04 Aug 2005 11:10:29 am »
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.

Offline i-guy

  • Associate
  • **
  • Join Date: Jul 2005
  • Posts: 4
  • Forum Citizenship: +0/-0
Re: add new dimension to Contributor built mdl
« Reply #2 on: 11 Oct 2005 02:35:28 pm »
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.

 


       
Twittear