Categories
- All Categories
- 4 Oracle Analytics Sharing Center
- 12 Oracle Analytics Lounge
- 189 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Presentation variable in union report

Hi,
I am having a report with 4 criteria's (union report) of same subject area.
I am trying to use year presentation variable (year_pv) in one of the column formula like this @{year_pv}.
Similarly for other 3 criteria's also.
If i select year as 2016 in db prompt ... report column is not displaying anything, what could be the problem?
Regards,
Ram.
Answers
-
Debug yourself by taking the sql generated and run on a database client tool to find the root cause. Another way to debug on OBIEE side is by taking a copy of the union report and take the individual criterias as separate reports and check if the year is passed or not.
0 -
Check by keeping 2016 instead of pv in criteria and check if you have results for the year 2016. Also in advanced tab in Prefix keep SET VARIABLE LOGLEVEL=2,DISABLE_CACHE_HIT=1; and get the query from administration ->Manage Sessions and validate the query.
0 -
Hi,
For single criteria, i am able to get the PV value as 2016. But for union report .. there is no result.
Regards,
Ram.
0 -
Can you please share the output of the report, or the column formula you are using.
Try assigning default value to the column formula and check it displays those values or not.
Regards,
Akansh Agarwal
0 -
Must be an error in how the unions are set up. Like some expecting a string vs a number or sth like that.
0