May 26, 2014 at 8:06 am
Hi all,
I have a Person Dimension, and one of its attributes is called First Registration Date. I also have a Sales cube linked to the Person Dimension and Date Dimension.
Can anyone please tell me how to create cube calculated member that counts the no of First Registration Dates when I query with the Date hierarchy (Date.Date.FullDate) ?
I think the way to achieve this is to link First Registration Date Attribute to Date Dimension in some way?
My objective is something like:
2014
Jan 135
Feb 643
Mar 742
etc.
Thanks in advance!
May 26, 2014 at 10:48 am
You would need to create a factless fact table on top of the dimension. This fact table will be linked to the data dimension and the original person dimension.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 26, 2014 at 1:21 pm
You would then create a new fact table and a new measure group, linked via datekey and personkey, which would also show in Dimension Usage of the cube?
Thanks for your input. By chance is there a method to achieve same thing via calculated measures?
Cheers!
May 26, 2014 at 2:33 pm
Jonathan Mallia (5/26/2014)
You would then create a new fact table and a new measure group, linked via datekey and personkey, which would also show in Dimension Usage of the cube?
Yes, that's the idea.
Jonathan Mallia (5/26/2014)
Thanks for your input. By chance is there a method to achieve same thing via calculated measures?
Perhaps, my MDX skills aren't sharp enough to give any advice on that.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
May 27, 2014 at 1:14 am
Good.. very much appreciated 🙂
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply