DMR Models with Attribute

[cognos05]

Hi ,

We have used only Transformer cubes and we have the ability to set only up to 3 attributes per level in transformer. We are trying to build a sample DMR Model .

While working on it and looks like for each attribute we created an equivalent dimension.

I was not sure if it was correct , say if I have 100 attributes will I create 100 dimensions.

Can anyone shed some inputs on how attributes are defined and linked in DMR.

Thanks,

[CognosPaul]

Shouldn't have to do that.

Let's take a time dimension.

Your underlying table might look like:

year
quarterseq
quarter_caption
quarter_caption_long
quarter_num
monthseq
month_caption
month_num
month_abr
weekseq
week_attributes
dateseq (pk)
date
datecaption
<200 date properties>


In that example you could make a standard time hierarchy with years, quarters, months, and dates. Top level would just have year. Next level down you'd have quarterseq as the key and quarter_caption as the member caption. Drag the other two properties in without giving them a role.  Repeat all the way down.


In this same model I have a single junk dimension with over 50 different hierarchies. The vast majority of them are yes/no flags.