Skip to Content
author's profile photo Former Member
Former Member

How to rank multipl data columns in Query Designer?

hi All,

We've got a business requirements of having 24 different rate columns in BEx which the customer requires to rank all these 24 data columns. We first added 24 conditions for these 24 data columns respectively, but find no any data coming out when running the query. Then we delete 23 conditions and leave only 1 condition and the query runs with results, but you know this only makes 1 data column ranked other than other 23 data columns. We heard there could be some ways of using some logic, e.g., OR or AND to link these conditions together to fulfill the requirements to rank all the 24 data columns, but have no idea how to do it. Anyone could give us a step by step procedure?

We will give you rewards points for valuable answers.

Thanks!

Kevin

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 02, 2013 at 06:36 AM

    hi Suman,

    We have used the formula "column A data" %a "Column B data" to get the percentage number already. As we said, we can only use 1 condition for one formula column, if apply 24 conditions for all these 24 formula columns which shows percentage numbers, then no data comes out when running query. Not sure you say 'apply conditions on all KFs < the maximum value', what does it mean? Could you elaborate it?

    Thanks!

    Kevin

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 02, 2013 at 04:21 AM

    Hi,

    If you are referring to OR and AND condition then if you make different conditions inside a single condition then it may work on OR logic.

    In case you make separate list of conditions then it may work with AND logic.

    Hope this is what you are looking for,if not then please explain with some example.

    Regards,

    AL

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 02, 2013 at 04:45 AM

    Try with "Calculate Single Value as" Rank Number for all 24 KFs in the query designer. This setting will be in "Calculations" tab in Bex.

    If you apply condition on your Kfs, all your data will come in descending order which will not suffice your requirement.

    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.