Skip to Content
0

[Webi 4.x] passing hierarchy node variable prompt between reports

Mar 26 at 03:58 AM

37

avatar image
Former Member

Hi All,


I am facing issue passing hierarchy node variable value from parent webi report to child webi report via user response function though document linking.

e.g. if I select a hierarchy node value as ABC/1234/XX in parent report, only XX is passed to child report instead of ABC/1234/XX

Both parent and child reports are on bex queries via BICS and using webi 4.1 version

Please help out in case there's a solution to this

Regards,
Blasco

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

1 Answer

Jyothirmayee A Mar 26 at 08:02 PM
0

Hi,

Have Hierarchy variable in both Parent and child report and pass variable value thru a document linking in parent to child report.

Thanks,

Jothi

Show 3 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Jothi,

I haven't used Hierarchy variable in Bex query. There's only one hierarchy and a constant value is selected as hierarchy. Is it necessary to create hierarchy variable for this to work?

Thanks,

Blasco

0

Hi,

Yes, if you want to show Hierarchy based data in Detail report.

Btw, you can create prompt within WebI report too.

Thanks,

Jothi

0
Former Member
Jyothirmayee A

Hi Jyothi,

Thanks for your reply.

I tried passing hierarchy variable to child report. When document link is clicked in parent report, below error message pops up. Infoobject having hierarchy is not authorization relevant and I am able to run both reports individually without error. I face this issue only when document linking is done with hierarchy variable.

Any idea how to overcome this?

btw, I am only using hierarchy node in prompt and note in report table.

Regards,

Blasco

image.jpg (14.3 kB)
0