Sorting on Nexel column

Pascal Wehner
Customer



I just tried to sort the content of a dataview by using a column that is based on a pretty simple Nexel calculation (single rule), but apparently sorting does not work on Nexel columns. Data type is numeric.
If I click on the header of the column, sorting is working fine, but I would like to have it automatically, on open, using the sort function in the data layout.
Any ideas / workarounds?
Thanks and regards, Pascal
P.S. Version is 10.3
------------------------------
Pascal Wehner
Specialist BI-Tools & Controlling
NEC Display Solutions Europe GmbH
Germany
------------------------------
If I click on the header of the column, sorting is working fine, but I would like to have it automatically, on open, using the sort function in the data layout.
Any ideas / workarounds?
Thanks and regards, Pascal
P.S. Version is 10.3
------------------------------
Pascal Wehner
Specialist BI-Tools & Controlling
NEC Display Solutions Europe GmbH
Germany
------------------------------
0
Answers
-
Hi,
please note that Nexel is applied after the data-view layout (see also Board manual).
That means sorting based on a block with Nexel is not possible.
Maybe you can persist the result in a cube using Nexel writeback and then use the cube for sorting?
Kind regards
Bettina
------------------------------
Bettina Clausen
Consultant
Board
Germany
------------------------------
-------------------------------------------1 -
OK, understand. Thanks for the explanation.
Best regards, Pascal
------------------------------
Pascal Wehner
Specialist BI-Tools & Controlling
Sharp NEC Display Solutions Europe GmbH
Germany
------------------------------
-------------------------------------------0