Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

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

Action Links in Union Reports Not Working OBIEE 11g

Received Response
32
Views
7
Comments
901674
901674 Rank 2 - Community Beginner
edited Aug 13, 2024 6:10PM in Oracle Analytics Cloud and Server

Hi- I have a report in Obiee 11g which has two queries in union.

Query 1: Region, Month, Amount

Query 2: Region,'ytd'(Hard coded in edit formula section of the column),Amount---this is done to get total amount for the year

the results from these two queries are pivoted. So my report layout is like below

Region,Jan,Feb,Mar,Apr,May,Jun,July,Aug,Sep,Oct,Nov,Dec,YTD

Region in rows, Month is in Columns and Amount is in measures.

Now, I have an action link for the amount. So when user clink on the amount it takes them to detail report which gives information about all the accounts for region by month. My drill down report is working fine for all the months except for YTD. Since month and region is prompted it is looking for Month='YTD' in drilldown report soo it is not giving me any results. YTD is an hardcoded value in my union report. This values is not present in the table.

Can someone help me with this.

Thanks

Answers

  • Joel
    Joel Rank 8 - Analytics Strategist

    Have you tried adding a condition to your Action Link?

    Screen Shot 2016-11-13 at 07.51.44.png

  • 901674
    901674 Rank 2 - Community Beginner

    Hi Joel- Thanks for your reply. Below is my report layout and my results

    pastedImage_0.png

    Formula for 2016 YTD is below

    pastedImage_1.png

    When I click on the action link for 2016 YTD I am getting no results

    pastedImage_2.png

    I would like to know how to pass this value to the detail report.

    Thanks

  • Joel
    Joel Rank 8 - Analytics Strategist

    Hi @901674

    if I understand correctly, you don't want the Action Link active when "Month" = VALUEOF("CY")||'YTD' Do you want to exclude the Action Link when  "Month" = VALUEOF("CY")||'YTD'?

    is that correct?  If so, you could as mentioned earlier, use a condition on the Action Link where  "Month" <> VALUEOF("CY")||'YTD'.

  • 901674
    901674 Rank 2 - Community Beginner

    Hi Joel- Sorry for confusion. I want action link on "Month" = VALUEOF("CY")||'YTD' column. Right now I have it but this values is not getting passed to detail report.

    Thanks

  • Joel
    Joel Rank 8 - Analytics Strategist

    OK. In that instance, you can use the action link conditions to call 2 reports:

    1 for the months (as you have already) which just passes the month to the detail report and the action link condition will be Month <> VALUEOF("CY")||'YTD'.

    A new detail report for the YTD where you'll have a year filter on the detail report Year = VALUEOF("CY") and the action link condition will be Month = VALUEOF("CY")||'YTD'

    it won't work with a single report because if you think about it, you're trying to drill down to different levels of grai on the time dimension.

  • 901674
    901674 Rank 2 - Community Beginner

    Thanks so much Joel. It worked.

  • Joel
    Joel Rank 8 - Analytics Strategist

    That's great. Mark as correct to help others who might have a similar issue in future.