Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

DIM_TEMPO - Filter with two date fields Expand / Collapse
Author
Message
Posted Thursday, October 24, 2013 10:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 11:50 AM
Points: 2, Visits: 7
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


  Post Attachments 
BI Lindencorp.pdf (12 views, 20.59 KB)
Post #1508158
Posted Friday, October 25, 2013 1:48 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:09 AM
Points: 1,046, Visits: 1,846
You can design Role Playing Dimensions. Read here:

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


Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1508358
Posted Friday, October 25, 2013 11:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, October 25, 2013 11:50 AM
Points: 2, Visits: 7
Raunak Jhawar, thank you for the tip, duplicated the time dimension and thus arrived at the result.

Tks
Post #1508555
Posted Monday, October 28, 2013 1:57 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, December 15, 2014 3:09 AM
Points: 1,046, Visits: 1,846
Its a useful feature. Happy learning!

Regards/Raunak
Now a member of Linkedin

Please visit the all new Performance Point Forum
Please visit the all new Data Mining and Business Analytics Forum
Post #1508765
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse