April 28, 2010 at 12:20 pm
I have a dimension table with 2 columns - ID (the PK, an INT) and Description (Char()). I want to display it in order of key not description. I tried changing the KeyColumns property from the description to the ID , but that also changed what was displayed.
I've got it to work for a time dimension to order e.g. the months correctly, but for this simple dimension - with no hiererachy and only 2 columns - I can't get it working. I tried playing with NameColumn & ValueColumn but that didn't work either. I'm sure it's something pretty simple.
April 29, 2010 at 1:45 am
Hi Paul,
Indeed, unless I misunderstand you, it is something pretty simple.
You can set the way your dimension attributes (like month in a time dimension) are ordered by uisng the attributes "OrderBy"-property. Select 'Key' or Name' ', whatever fits best.
Hope that helps,
Kind Regards,
Cees
May 13, 2010 at 4:09 pm
I don't know why, but not only did I have to change the Order By Key, but also had to set the NameColumn and the ValueColumn in order to retain the correct display values. But this allowed me to display the description to the user, while using the PK to order results by
May 24, 2010 at 12:37 am
May be below link can help you:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply