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

Question

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.

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD · Answer

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

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..

thank you....

Thanks & Regards,

A.kavya

[Deleted User] · Answer

+1 - Presentation variables are the way to go!

Pedro F · Answer

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.