Sort Holiday in date Dimension
3 posters
Page 1 of 1
Sort Holiday in date Dimension
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
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
Re: Sort Holiday in date Dimension
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.
Re: Sort Holiday in date Dimension
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.
None of those will do it I think.
avasile- Posts : 10
Join date : 2012-06-28
Re: Sort Holiday in date Dimension
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).
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
Re: Sort Holiday in date Dimension
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.
Re: Sort Holiday in date Dimension
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
Re: Sort Holiday in date Dimension
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.
None of those will do it I think.
blackrose- Posts : 1
Join date : 2013-10-09
![-](https://2img.net/i/empty.gif)
» Best way to handle business day / holiday info - Date dimension??
» Date Dimension: Representing partial dates/Imputing date values
» Always link date fields to Date Dimension?
» Eliminate Date Dimension Surrogate Key
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
» Date Dimension: Representing partial dates/Imputing date values
» Always link date fields to Date Dimension?
» Eliminate Date Dimension Surrogate Key
» Using the Date Dimension for Summary Fact Tables or new specialized Month Dimension?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|