Oracle Analytics Cloud and Server

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

Presentation variable in union report

Received Response
31
Views
5
Comments
Rank 6 - Analytics Lead

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.

Welcome!

It looks like you're new here. Sign in or register to get started.

Answers

  • Rank 1 - Community Starter

    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.

  • Rank 6 - Analytics Lead

    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.

  • Rank 6 - Analytics Lead

    Hi,

    For single criteria, i am able to get the PV value as 2016. But for union report .. there is no result.

    Regards,

    Ram.

  • Rank 4 - Community Specialist

    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

  • Rank 2 - Community Beginner

    Must be an error in how the unions are set up. Like some expecting a string vs a number or sth like that.

Welcome!

It looks like you're new here. Sign in or register to get started.