October 24, 2013 at 10:34 am
Hello,
As star schema attached, I am developing a BI project where the table actually have two dates that need to be used as a filter and connected the dimension of time, they are DT_BAIXA / DT_MOVIMENTO. The problem is that I can have different parameters to search between dates. For example, if I want to bring all the data where conditions are DT_BAIXA is the month 09/2013 and DT_MOVIMENTO is the month 10/2013, as I can build the cube so that the user can do this type of query?
Tks
October 25, 2013 at 1:48 am
You can design Role Playing Dimensions. Read here:
http://technet.microsoft.com/en-us/library/ms174487(v=sql.90).aspx
Raunak J
October 25, 2013 at 11:52 am
Raunak Jhawar, thank you for the tip, duplicated the time dimension and thus arrived at the result.
Tks
October 28, 2013 at 1:57 am
Its a useful feature. Happy learning!
Raunak J
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply