BEx Analyzer: Result Rows Suppressed when condition is on

[former_member1347973]

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.

[jagadeesh_mandepudi2 · Accepted solution]

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

[former_member1347973 · Accepted solution]

Hi Jagadeesh,

Thanks for providing the steps.

I had already tried this but the issue is, in our query, condition is on the Percentage column. If i do result as 'Total', i will get the overall Result as aggregated sum of all values in that column. This will be incorrect number from reporting stand point.

Please let me know if you have any workaround.

Thanks,

Umesh.

[former_member1347973 · Accepted solution]

Hi BEx Gurus,

Any one has answer or workaround to my issue?

Thanks in advance for looking in to this.

Please let me know if you require additional info.

Regards,

Umesh.

[Former Member · Accepted solution]

Hi everyone,

i have a problem like that. In my query i have a condition and it's result sends us top 10 custemers. Its working fine except my one column which try to get total sum of previous columns' report result. This column doesn't work as my condition, its getting total customers' results instead of top 10 customers.

Is there anyone who can suggest me a solution way?

I hope my explanation is understandable for you.

Thanks all in advance.

[former_member546157 · Accepted solution]

Hi everyone,

I am facing this issues please help me out with solid solutions if possible. Thanks a lot in advance.

The user is running a query that contains a condition defined in the query (Condition is show the Condition Value less than 0).  When the user runs the query with the condition turned on, it fails to pickup one of his records that contains a value of -1.00.  When the condition is inactive, the record with -1.00 shows up. 

Hardik

[former_member1347973 · Accepted solution]

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.

[jagadeesh_mandepudi2]

Hi

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

Regards

Jagadeesh

[Former Member]

Hi Jagan,

In fact i've no problem with positive or negative values. Let me tell,

in my query, my one column ( X) shows top 10 customers' debt values. Another column i am trying to get X's total amount. But when my formula is "SUMRT X", im getting my total 200 customers' total debit. So this new column doesn't use my first query condition.

How can i do my condition effective for this column too?

Clear? maybe my English is not so enogh to tell the problem. Sorry about that.

Thanks.

Htc

[Former Member]

Hi Hatice,

Did the SUMRT works for the query with condition. Please let me know if it works.