Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 11g cross-subject area reporting using action-links

Received Response
2
Views
2
Comments
Debraj Roy
Debraj Roy Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi All,

I have got two different subject areas - Project Cost Subject Area and Financials AP Transactions Subject Area.

My requirement is to navigate from Project Cost to Financials AP Transactions subject area on the basis of action link through Invoice ID.

The physical column source of Invoice ID in Project Cost Subject Area is - W_PROJ_COST_LINE_F.DOCUMENT_HEADER_ID

and the physical column source of Invoice ID in Financials AP Transactions Subject Area is different.

Now,if I want to do the navigation based on the invoice id from project cost to ap transactions,how will I proceed ?

Thanks for your help in advance.

Answers

  • SriniVEERAVALLI
    SriniVEERAVALLI Rank 6 - Analytics Lead

    Explore options with Action links or Master detail report

  • Carina Mendes
    Carina Mendes Rank 3 - Community Apprentice

    Hi @Debraj,

    One of the features of the "Link action" lets you navigate to another report when you click the value or header (label) of a column. It is possible to do this regardless of the subject area.

    First larval you need to have two reports with the information "project cost" and another with the information of "transaction".

    Then, edit the report "project cost" go on the property of the column you want to apply the action link, for example: "Project ID" navigate to the tab "Interaction" and choose "Dynamic Link Action" and set the link to open the report containing the information of "transaction".

    For more details, read the following documentation:
    Creating and Using Action Links and Actions

    I hope this helps you.

    Regards,
    Carina Mendes.