Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Sort Holiday in date Dimension

3 posters

Go down

Sort Holiday in date Dimension Empty Sort Holiday in date Dimension

Post  avasile Mon Jul 23, 2012 3:37 pm

I have a Date Dimension that lists US Holidays - how will I go about sorting the Holidays when users displays the data in the Cube?
Our US Holiday is string field and listed as an attribute not in a hierarchy.
Basically I would like to be able to see sales by year and holidays - when I do it it will display by either a key or name.
Thank you.
Adrian

avasile

Posts : 10
Join date : 2012-06-28

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  ngalemmo Mon Jul 23, 2012 4:17 pm

I you just want chronology, sort by the date first (or earliest date if it is a period). Otherwise you would need to add some sort of sequence attribute to the dimension.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  avasile Tue Jul 24, 2012 7:09 am

It is just chronology - but how will I sort by the date though? When I look at the attribute I can only sort by Key, Name etc
None of those will do it I think.

avasile

Posts : 10
Join date : 2012-06-28

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  ngalemmo Tue Jul 24, 2012 8:10 am

Your date dimension doesn't have a date?
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  avasile Tue Jul 24, 2012 8:14 am

Thank you again for your help. It does have a date but I cannot figure out how to do that within the cube.
Usually most of the hierarchy and attributes I can sort them by key and that will do it - this particular attribute does not have a key ( I think).

avasile

Posts : 10
Join date : 2012-06-28

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  ngalemmo Tue Jul 24, 2012 3:39 pm

I'm not a 'cube' guy, but can't you include the date in the cube and include the holiday description as part of the same dimension? There may also be a way to hide the date. The tools I have used are all ROLAP based and doing stuff like that is fairly simple. Some allow you to specify a sort order by providing a list of values in the desired sequence... your cube may have similar capabilities... just give it the list of holiday names in the order you would like to see them presented.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  avasile Tue Jul 24, 2012 3:48 pm

That is how I have it setup but for some reason it errors out when attributes are defined. Key column for the Holiday Attribute is the column in the table called Holiday; if I try to select the Key Column as the Date and then the Named Column as the Us Holiday, it will list all the days in the Year.

avasile

Posts : 10
Join date : 2012-06-28

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  blackrose Wed Oct 09, 2013 12:30 am

But how will I sort by the date though? When I look at the attribute I can only sort by Key, Name etc
None of those will do it I think.

blackrose

Posts : 1
Join date : 2013-10-09

Back to top Go down

Sort Holiday in date Dimension Empty Re: Sort Holiday in date Dimension

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum