DIM_TEMPO - Filter with two date fields

• tiagoof

  Grasshopper

  Points: 24

  More actions

  October 24, 2013 at 10:34 am

  #281700

  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

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  October 25, 2013 at 1:48 am

  #1661540

  You can design Role Playing Dimensions. Read here:

  http://technet.microsoft.com/en-us/library/ms174487(v=sql.90).aspx

  Raunak J

• tiagoof

  Grasshopper

  Points: 24

  More actions

  October 25, 2013 at 11:52 am

  #1661708

  Raunak Jhawar, thank you for the tip, duplicated the time dimension and thus arrived at the result.

  Tks

• Raunak Jhawar

  SSCoach

  Points: 15701

  More actions

  October 28, 2013 at 1:57 am

  #1661863

  Its a useful feature. Happy learning!

  Raunak J