Skip to Content

Document Linking on BEx Structure to view detailed report

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 09 at 10:12 AM

    Hi,

    create prompt for GL account and address them from your webi

    Add comment
    10|10000 characters needed 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