Skip to Content
avatar image
Former Member

BW hierarchy keeps on breaking in Web Intelligence

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 20, 2016 at 11:18 AM

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

    See if that works

    Add comment
    10|10000 characters needed characters exceeded

  • 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?.

    Thanks,

    Jothi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    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 .

    Add comment
    10|10000 characters needed characters exceeded