Skip to Content

How to Order Variale Sequence in WAD

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2011 at 11:14 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 30, 2011 at 01:53 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 18, 2011 at 10:25 AM

    Got the answer

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.