Skip to Content

BEx Analyzer: Result Rows Suppressed when condition is on

Hi All,

I have a BEx Query with below details:

Drill down characteristics - A, B, C, D, E, F, G, H, I (total 9)

Result Row set to Display for - A & F characteristics

Key Figures - P, Q, R, S

Condition is Active on column - S: less than 100 (Show all the values less than 100 for column S)- This is a percentage calculated key figure.

Characteristic Assignment in the condition - Individual Chars. and Char.Combinations, selected all characteristics that are in the drill down (A to I).

Issue: When I run the report, everything works fine except the result rows, For both column A & F result rows are not displayed. It is getting suppressed somehow.

I tried by selecting the first option in the Character Assignment (All characteristics in the drilldown independently). This works & I get the result rows as required, but now it doesnt show all the values that supposed to be on report.

This is causing inconsistent data to the Business, even though cube values are correct.

We are on SAP BI 7.0 with SAPKW70019 support package.

I did research OSS notes, but unfortunately couldnt find any.

Please help with your ideas & let me know if you need further inputs.

Thanks in Advance.

Umesh.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Nov 09, 2011 at 04:51 AM

    Hi

    I will provide easy steps

    1. Just go for query change mode and select your keyfigures under properties go for calculations and keep calculate result as "Total".

    Your issue get resolved.

    Regards

    Jagadeesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Hardik,

      Can you check the Characteristic Assignment -> Determine Characteristic assignment. By default it is selected first radio button for All Chars drill down independently. Try changing it to second option and validate. Else other option is to use the 4th and select all characteristics that are displayed in query.

      This works only if you have a predefined format. It may not work when user wants to drill down.

      In our client it works because they dont change format of the query once it is displayed.

      Hope this helps.

      Regards,

      Umesh.

  • Posted on Dec 02, 2011 at 11:15 AM

    Hi

    Try with ABS in formula i.e you insert your keyfigure in formula and use ABS option to diaplay the same.

    Regards

    Jagadeesh

    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.