When a key collection is set for the Keycolumns property, the DataItem Collection Editor has up and down buttons to order the individual keys. For example, for month in a date hierarchy I have a key collection of MonthNumber then Year. Changing it to Year then Month number doesn't seem to affect anything other than the way the hiearchy is referenced in MDX.
Does the order of the keys in the collection matter to AS?
What would you expect the order keys in the DataItem to affect? Order of the members in the attribute?
For time dimension you can try and use the OrderBy or OrderByAttribute to order memebers.
See how Date dimension in AdventureWorks sample database is built.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
That's just it...I don't expect that it would change anything. The key collection, naming property, order, and value are all set appropriately. Everthing seems to be working fine. Moving one before the other seems to have no effect.
However, I've learned just enough about AS to know that not everything is documented nor are the effects of seemingly trivial settings like this. I just don't want this to come back and bite me later.
Thanks for your reply Edward.
No comments:
Post a Comment