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,
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.
(https://i.imgur.com/s6LrEay.png)
In this same model I have a single junk dimension with over 50 different hierarchies. The vast majority of them are yes/no flags.