12-18-2023 01:03 AM - last edited on 12-21-2023 09:58 PM by JackLacava
Hello Community
I have data sorted in descending order in Data Adapter. But when that data is imported to BI Viewer I am not getting in descending order or any other sorting order.
Solved! Go to Solution.
12-18-2023 02:54 AM
Hello @ResmiKR ,
The BI Viewer component will not sort your data as it is in the data adapter, but will get the "standard" sorting (that is, alphabetical sorting if I remember).
But you can actually sort your data in any way you want in Bi Viewer, can't you ?
Regards,
12-18-2023 02:54 AM
Hello @ResmiKR ,
The BI Viewer component will not sort your data as it is in the data adapter, but will get the "standard" sorting (that is, alphabetical sorting if I remember).
But you can actually sort your data in any way you want in Bi Viewer, can't you ?
Regards,
12-18-2023 05:04 AM
Thank You for the response. Actually, I have an Amount column which needs to be sorted in Descending order. The data which is passing to BI Viewer is in descending order only but when displayed in BI Viewer it is not in that descending order.
01-23-2024 05:45 PM
Hi
I am trying to do the same thing...did you ever get this to work? I am pulling a cube view in the BI viewer but its sorting by year. I need it to follow the cube view order. I have scenario and year but I want scenarios all together but the year sort is taking over. Hope that makes sense. Also is there a way in BI to pull the cube view descriptions and NOT just the member name?