The sort by Attribute or key works in XMLA Cube datasource?

Carlos Ceja shared this question 7 years ago
Answered

Our Cube have a Date_Dim, Sorting by weeks using a key and other by attribute, But in Yellowfin the sort is by name and I can't change the format to number in the view... is possible do this to use the order by the cube?

Best Answer
photo

Carlos, good news. In the last product update we made a change to the OLAP filter list functionality. Check it out and see if this might help with the issue above. Best.


Change log details...

Replies (2)

photo
1

Hi Carlos,

Unfortunately at this point in time Yellowfin cannot actually read the sort index from the cube, it will simply return all the values (ignoring any sort attribute) and then sort alphanumeric.

We do however have an enhancement raised for this which I have linked to this post '231437'.

The task itself is yet to be planned so I'm unable to provide an ETA at this point in time.

You can chase this up at any point in time, though I can assure you if we have any movement on the task we will notify you via this thread.

There is a workaround which may be viable, and that would be to use org ref codes:

http://wiki.yellowfin.com.au/display/USER72/Org+Reference+Codes

It can be a bit of work to setup at the view level, but you do it the once and then all reports use it.

Sorry for the inconvenience this has caused.

Please let us know if you have any questions or concerns on this.

Thanks,

Davi

photo
1

Carlos, good news. In the last product update we made a change to the OLAP filter list functionality. Check it out and see if this might help with the issue above. Best.


Change log details...

Leave a Comment
 
Attach a file