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

Time dimension...4 hour partition attributes...how to? Expand / Collapse
Author
Message
Posted Thursday, May 9, 2013 7:37 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:34 AM
Points: 1,322, Visits: 1,730
I have a dimension with attributes timestamp and status. My measuregroup also has a measure timestamp along with a bunch of other measures too. Now I need to create some additional named calculations in the dimension where I should be able to view data every 4 hours meaning the attributes should be 0-4 hours, 4-8hours, 8-12hours,12-16hours,16-20hours and 20-24hours. And when I process the cube and drag the measures I want to see some measures during the 4 hour time interval of the day.

Is this possible?

Thanks for your help.


“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Post #1451109
Posted Thursday, May 9, 2013 2:10 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 25, 2014 7:34 AM
Points: 1,322, Visits: 1,730
Experts I need your inputs.

“If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams
Post #1451314
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse