How to Order Variale Sequence in WAD

[former_member210674]

Hi BW Gurus,

I have a problem in Variable sequencing in WAD.

In a WAD report I have 12 BEx queries. All the queries having same Variable sequence like ABCD.

But when executing the WAD report, the Variable is showing in the Order CDAB. I haven't made any changes to default settings of Web template. Please suggest to fix this issue.

Generally how the Variables are sequenced apart from Query settings ?

Thanks in advance

Gopi R

[Former Member · Accepted solution]

Hi Gopi,

There is no setting in WAD where you can set the sequence of variables. Sequence can only be set in query designer.

We face this kind of problem when there are common varibles across the queries used in the web template. It will display the common variables first and then rest of the variables.

If you want to display the variables in a particular order, try to make it consistent across all the queries used in the web template.

Thanks,

Sachin