how to hide the prompts in obiee 11g analytics?

Question

Hi,

I have  created year, month, max(day_of_month) column prompts..

define prompts like this

year=@{year}

month=@{month}

max(day_of_month)=@{day}

I want to hide max(day_of_month) column prompt..

for selecting values from two prompts year & month.. display values from three prompts..

i want to use 2 prompts @{year},@{month} & hide the @{day} prompt..

display the values from three propmts..

For example, i have 30-oct-2015 data .

If select 2015 from @{year}, & oct from @{month}  then i want to display @{day}-@{month}-@{year} in title page

here i am not selecting  any value from @{day} prompt. its getting max date from particuler month(based on selected month).

is it possible?

Please help me.

Thanks in advance,

A.kavyab

3192737 · Answer

Hi,

Don't try to hide the prompt in a Dashboard.Just Create presentation variable on Month and pass the presentation variable in the Title view.And you can also calculate month first date or last date(From prompt selected month) using Time stamp functions.

Thomas Dodds · Answer

OR you could add the last day of the month column to your time dimension table ... so when you select year + month you can get the column for last day ...

Thomas Dodds · Answer

You could hide an analysis on your dashboard page that accepts the two visible prompts, calculates the last day of the month and then that is used as the filter criteria for your report's similar column - then you can use that column value in some of the views to achieve what you want.