T
Tomer
when using date then week hierarchy in an OLAP cube and
pulling it to pivot table, the week format is "general"
and that makes it impposible to sort it logically.
does anybody know a way to change the dimension format
to "number"? or any other walk-around to the sorting
problem?
example:
list of dates is converted to weeks: 20,22,2,12,15,1
when sortin decending the result is: 22,20,2,15,12,1
pulling it to pivot table, the week format is "general"
and that makes it impposible to sort it logically.
does anybody know a way to change the dimension format
to "number"? or any other walk-around to the sorting
problem?
example:
list of dates is converted to weeks: 20,22,2,12,15,1
when sortin decending the result is: 22,20,2,15,12,1