BW hierarchy keeps on breaking in Web Intelligence

[sourav_roy83]

Hello Experts,

Patch Level- 4.1 SP7 Patch 1

Problem Area- Web Intelligence & WebI Rich Client

We have couple of WebI reports where a Profit Centre hierarchy is supposed to be shown in LOV .

While the same Profit Centre hierarchy from the same underlying BW cube appears consistently in different reports ; there are two reports in particular where the hierarchy ends up being broken .

The behaviour is odd because it may not happen for all at the same time .

For example - if USER A and USER B is opening the same report it might happen the hierarchy will appear broken for USER B but will appear fine for USER A

Broken Hierarchy -

not broken -

Patch Level- 4.1 SP7 Patch 1

when the Hierarchy appears broken we subsequently fail to run the report with this error

we also tried opening the report in WebI Rich Client and the Query Editor fails to open with this error

the issue does not happen all the time for all users .It's very intermittent in nature .

Kindly help me out in investigating the root cause of this weird error .

There is little to no documentation on these errors for WebI .

Regards,

Sourav Roy

[sourav_roy83]

Hi Jyothirmayee,

Yes the three reports are pointing to same underlying cube . However the BEx query is different . More over we have observed the following error mentioned in the original message is appearing for reports without having the Hierarchy in LOV as well .

Basically it appears to be a problem in HTML mode when we are trying to pull large amount of data .

[jyothirmayee_s]

Yes Sourav,

@Kuldeep is pointing to BEx query designer.

Also, is the WebI reports based on same BEx query?.

Thanks,

Jothi

[former_member198519]

Try with Query Designer Properties... to "Suppress Zero option" for row/cols

See if that works

[sourav_roy83]

Many thanks Kuldeep for responding . I almost lost hope on this ! BTW can you please confirm if I am looking at the right place? Are you pointing towards BEx query designer?

[former_member198519]

That's correct Sourav. This problem of yours sounds interesting. Ideally it should not happen.