Hierarcy
Hierarcy
(OP)
Hi All,
I have dimension table as you see in the picture.
District_Key is the key joining the fact table. But I like to create a hierarchy with New_DVP column and summarize the measure based on the New_DVP.
Can anyone help me for this?
Thanks
I have dimension table as you see in the picture.
District_Key is the key joining the fact table. But I like to create a hierarchy with New_DVP column and summarize the measure based on the New_DVP.
Can anyone help me for this?
Thanks
RE: Hierarcy
An alternative is to create a new dimension that includes the rollup and add that dimension to the fact table. Then eventually, retire the other dimension.
==================================
advanced cognitive capabilities and other marketing buzzwords explained with sarcastic simplicity