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