Query is not working after BW upgrade to BW7.3 version

[antony_xavier3]

Hi Guys,

The query is not working after upgrade to BW 7.3 version, Bex is still in 3.5 version. I am not able to backtrack the issue and its rootcause, solutions. Pls assist if anyone might have faced similar issue.

While opening the query in Bex analyzer, it is throwing below error

[antony_xavier3 · Accepted solution]

There is a Calculated KeyFigure present in the Query, if I remove that Calculated Keyfigure Query is working fine,

[former_member183012 · Accepted solution]

Hi Antony,

Can you please check what is aggregation at your CKF..if its after aggregation change it to before aggreagation..please try this I think problem will resolved.

Regards,

Ganesh Bothe

[antony_xavier3 · Accepted solution]

Ganesh....Thanks for your response...Yes currently it is after aggregation, as per your suggestionn if I change it to Before Aggregation..I believe it could affect query performance as calculations would be done before aggreagtion with too many records...

Do you have any idea regarding the rootcause of this issue

[MGrob · Accepted solution]

Hi

Have a look at Note 922727

The setting "Calculate before aggregation" is no longer necessary for calculated key figures. You can either replace the calculated key figure with a basic key figure with the relevant transformation (if the aggregation behavior is independent of the characteristic drill-down) or replace it with the new options for creating exception aggregations in the BI BEx Query Designer NW2004s (if the aggregation behavior depends on the characteristic drill-down).

The "After Aggregation" query behaves the exact same as what it used to do in BEx 3.5 with option "before Aggregation".

hope that clarifies

Martin

[former_member183012 · Accepted solution]

Please read this note 1151957.

Regards,

Ganesh Bothe

[antony_xavier3 · Accepted solution]

@ Martin...

The setting "Calculate before aggregation" is no longer necessary for calculated key figures.

Then if I change my current CKF from "Calculate After Aggregation" to "Calculate Before Aggregation" the query should work....I have only this option left for now

But note says we should not use "Calculate before aggregation"....So I am not much clear

[former_member183012 · Accepted solution]

Hi Antony,

Is your  hierarchy info object is in the rows?If yes thats why you are getting prob.