Skip to Content

BW hierarchy keeps on breaking in Web Intelligence

Dec 16, 2016 at 03:03 PM


avatar image

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 .


Sourav Roy

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Kuldeep Ghosh Dec 20, 2016 at 11:18 AM

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

See if that works

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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?


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

setting.png (14.6 kB)
Jyothirmayee A Dec 20, 2016 at 07:24 PM

Yes Sourav,

@Kuldeep is pointing to BEx query designer.

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



10 |10000 characters needed characters left characters exceeded
sourav roy Dec 22, 2016 at 06:09 PM

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 .

k6zol.png (57.9 kB)
10 |10000 characters needed characters left characters exceeded