Skip to Content
0

Document Linking on BEx Structure to view detailed report

Mar 07 at 06:52 PM

54

avatar image

Hi,

I have 2 WebI reports on BEx query with a structure to show Summary and Detail.

Summary report has Structure and Key Figures.

Detail Report has GL Accounts and Key Figures.

Fiscal Year/Period and version are prompts from BEx and I have created Cost Center as optional prompt in both Summary and Detail reports.

Below code from Summary Report:

="<a href=\"http://XXX:8080/BOE/OpenDocument/opendoc/openDocument.jsp?iDocID=11011712&sType=.wid&sRefresh=Y&sWindow=Same\" title=\"\" target=\"_blank\" nav=\"web\">"+[Struct]+"</a>"

This shows only Cost Centers those are passed in a prompt.

Can we get similar hyperlink or Document linking on BEX structure to display related GL accounts?,

I'm on SAP BO 4.1 SP6

Any thoughts are appreciated.

Thanks,

Jothi

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

1 Answer

Koen Hesters Mar 09 at 10:12 AM
0

Hi,

create prompt for GL account and address them from your webi

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

Thanks Koen,

GL Account prompt is not an option unfortunately. BEX structure is based on GL accounts and when the users selects a line item from structure, Detail report should show related GL accounts.

I will try as an optional prompt but still looking for alternative.

Thanks,

Jothi

0