column headings dynamically change selection based on date filter? in obiee 11g analytics — Oracle Analytics

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

column headings dynamically change selection based on date filter? in obiee 11g analytics

Received Response
83
Views
3
Comments
ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD
ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD Rank 5 - Community Champion
edited Aug 13, 2024 7:06PM in Oracle Analytics Cloud and Server

Hi,

I am working an obiee 11g analytics.

i my report five coulmns.. those are branch, district, lcy, current year, previous year..

based on section on dtae filter , column headings will change dynamically.

column headings are current year, previous yea r;

current month , previous month ;  

current week, previous week.

for example, if i select year 2016,

column headings are branch, district, lcy, 2016, 2015 will change dynamically in the analytics report...

Please help me,

I have tried, but i didnt get..

Please help me,

A.kavya.

Answers

  • Pedro F
    Pedro F Rank 6 - Analytics Lead

    I'm not really sure about what you have but assuming you have a dashboard prompt with the column year, set a presentation variable for that column (pv_year) and then in the report, for the columns you want, set the column heading as @{pv_year} and @{pv_year-1}.

    It should pick up the values from the prompt and set them dynamically in the column headings.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    +1 - Presentation variables are the way to go!

  • ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD
    ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD Rank 5 - Community Champion

    Hi,

    As you said, i have tried.. its working fine...

    using presentation variable & column prompt varaible i have taken...

    by using this i am getting dynamically column changes based on prompt selection .. and also column data also geting dynamically based on prompt selection...

    for dynamically changing the column headings i have done like this

    4.jpg

    plese see this screen shot..

    radio buttons MONTH/ WEEK: P_col2(Presentation varaible)

    choice list YEAR:PRO_005_YEAR(column propmt variable)

    choice list WEEK:PRO_005_WEEK(column prompt variable)

    choice list MONTH:PRO_005_WEEK(column propmt variable)..

    current month/week: @{PRO_005_WEEK}

    previous month/week:@{PRO_005_WEEK-1}

    for changing the data dynamically, i used case condion in column fields..if we select week, we wil get week data.& column heading changes .based on prompt selection..

    if we select month , we will get data, column heading dynamically change as per prompt selection..

    please see the below sreen shot..

    1.jpg

    2.jpg

    3.jpg

    thank you....

    Thanks & Regards,

    A.kavya