7 Replies Latest reply: Jul 25, 2013 3:12 AM by Christian Berg RSS

    OBIEE requirement

    957471

      Hi everyone,

       

      I have a requirement where i need to show the tile in subreport dynamically like Employee Headcount By accounting/Accountant/Manager..

      Example:

      I have report A (Parent Report).I have used column selector to show Trend.Let say Department wise,job wise and Position wise

      This report A navigates to the Report B(sub report) wherein Details of the employee is shown.

       

      My requirement is

      Report B does have Title.As Per the click on the Parent Report column the Title need to be change in Report B.

      Workaround I did to achieve this:

      1)Created the Same Presentation Variable for  all the column(Departement:@{DEPT},Position:@{DEPT}},Job:@{DEPT})

      2)Prompted in Report A using the PV

      3)And added this Variable in Title View.

       

      But this will work if we have Dashboard Prompt for all this columns.

       

      Another Method:

      1)Created Dummy column in Report B where Condition write is

      CASE WHEN 1=0 THEN Department_desc ELSE job_desc.....

      END

      What it do is always get Fail and show Job Desc even for department

      2)Narrative this column in Narrative View.

       

      Hope i'm clear.Kindly suggest me on this..

      Thanks in advance,