Skip to Content
0
Former Member
May 12, 2010 at 12:03 PM

Building an hierarchy in Universe

842 Views

Hi,

Please help us how to build a Hierarchy based on particular values. i.e we need to create an hierarchy in universe level(for ex: Derived Table) and database is SQL Server.

hierarchy : Year->Quarter->month-> date

For date object the query is current date value. (this we can get)

Month -> It should be last day on of the day value in that particular month(i.e if jan is the month then we should get 31st value as month value)

Quarter -> It should be last day value of the quarter (i.e if quarter =2 then we should get quarter 2 value as june 30th value)

Year-> last day of the year as year value.

Thanks In Advance