Custom Sort within WEBI Business Objects 4.0

[Former Member]

I created a custom variable and I am unable to select/sort the values which populate from the variable. I can do this with a standard dimension which naturally comes from the universe. Any suggestions for a work-around?

Thanks!

[CdnConnection · Accepted solution]

Carter,

     Right-Click on any Column choose Sort - Manage. You should now get a pop-up, choose the Objects to SORT.  You will also see option to do Custom Sort on the same pop-up.

See screen-shot for more details

Regards,

Ajay

[Former Member · Accepted solution]

I attempted those steps yesterday and they didn't work but today for some reason they are working. I don't know if I didn't have the variable highlighted correctly to allow to see the custom values or if it was something else.

Thanks everyone!

[Former Member]

Hi Carter,

If you are trying to apply Custom sort on a Variable whose type is 'measure' object. It is not possible.

But try changing the object type to Dimension or Detail, then you can apply Custom Sort(Custom Values).

Please refer above screenshot by ajay. Click "Values" button. and then, move the values up or down using arrows.

Hope it helps!!!

-Parthiban

Transaltus

[manesh_ks]

Hi Carter,

Custom variable values are created during run time, so you wont be having the values when you click filter over the variable column.

try Ajays idea by manually adding values but the value format should be same as custom variable.

thanks

Manesh