Question Re: Webi report using hierarchy in Technology Q&A

Webi report using hierarchy

abdussamad_peera — Wed, 12 Apr 2017 14:09:48 GMT

HI all

I have bex query with an hierarchical dimension and I can view the query in RSRT successfully. However, when select this dimension in Web (BOBJ 4.1 SP3), I get a nasty error (see attached message).

Any advise?

Re: Webi report using hierarchy

jyothirmayee_s — Wed, 12 Apr 2017 17:39:09 GMT

Hi,

Do you have Company Code/ Industry Code hier as part of the query. Drag that attribute to into Free Chars.

Thanks,

Jothi

Re: Webi report using hierarchy

abdussamad_peera — Thu, 13 Apr 2017 13:23:16 GMT

I tired that and the problem persists unfortunately.

Re: Webi report using hierarchy

jyothirmayee_s — Thu, 13 Apr 2017 14:06:47 GMT

Hi,

Click on the Industry coe drop down in Query Panel and try selecting the nodes or levels you want to populate.

Thanks,

Jothi

Re: Webi report using hierarchy

abdussamad_peera — Thu, 13 Apr 2017 17:46:19 GMT

I did do that in Webi. Are you talking about webi?

Re: Webi report using hierarchy

jyothirmayee_s — Thu, 13 Apr 2017 18:45:48 GMT

Yes.

In WebI>> Query Panel>>Hier dimension object

Thanks,

Jothi

Re: Webi report using hierarchy

abdussamad_peera — Tue, 18 Apr 2017 15:32:45 GMT

Yes, I did it in Webi but not success.

Re: Webi report using hierarchy

jyothirmayee_s — Tue, 18 Apr 2017 16:09:55 GMT

Hi,

Does your BEx query has Company Code/Industry Code hier as display or free chars?.

Thanks,

Jothi