?
Solved

Action link in Union Reports Not Working in OBIEE 11g

Posted on 2016-11-12
1
Medium Priority
?
447 Views
Last Modified: 2016-11-22
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
0
Comment
Question by:shragi
1 Comment
 
LVL 22

Accepted Solution

by:
Helena Marková earned 2000 total points
ID: 41887475
Maybe you can try some workaround e.g. create a view for months and hardcoded value 'ytd'.
0

Featured Post

Take Control of Web Hosting For Your Clients

As a web developer or IT admin, successfully managing multiple client accounts can be challenging. In this webinar we will look at the tools provided by Media Temple and Plesk to make managing your clients’ hosting easier.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
By, Vadim Tkachenko. In this article we’ll look at ClickHouse on its one year anniversary.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

599 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question