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

[former_member210674]

Got the answer

[Former Member]

Hi Gopi,

Yes the arrangement of variable values is not possible in WAD.

It has to be done in the query designer.

We faced this scenario during our implementations. All the variable filters (especially the common variables) need to be arranged in the same way in all queries.

If Calmonth and material are common, in all queries they can be put in the first and second places - this way when the web template is executed, it will show these common varaibles in the first and second places.

In the uncommon variables case, the arrangement will alphabetical. Or sometimes you will have to do permutations in the queries to get the right sequence for uncommon variables.