Hi,

One thing I would say is that as part of your date dimension you should think about adding a 'Month Start Date' and 'Month End Date' to your records. That way OBIEE won't have to work it on the fly whenever you need something like this.

However, if you want it to work now:

In your analysis where you're wanting to display this header information:

Put a filter on the year and month as 'is prompted' then bring in your 'Full Date' column that is in the format you want i.e. '30/10/2015' and have the formula as 'max("Date"."Full Date")'

This will bring back the last full date in the selected month. If this column is the first column in your 'Criteria' tab then it will be @1, if it's the second it will be @2 etc..

Then reference this in your title. You should have use a narrative to be able to reference your new column. Tick the  'Contains HMTL markup' box and set the rows to bring back as '1'. Use this as the content:

'Status of Foreign Earnings Month @1' (or @2 etc. depending on its position)

Hope this helps

Hi,

I believe that what I said still stands. If you're putting "Month is prompted" as a filter then do a max on the full date in a column it will give you the last day of the selected month.

This won't affect the data that you're bringing back, it's just a column for display.

You should have your 'Previous Month' column worked out in the RPD using the AGO() function. Look at the oracle documentation about using Time Hierarchies.

If you're trying to show dynamic headers you should base them off of variables like you are. Edit your column and tick 'Custom Headings' and 'Contains HTML Markup' then put this as the header:

Current Month {pro_005}{10}

This will display as 'Current Month 10' and will update as your users change their selection.

My suggestion for your 'Previous Month 9' column heading is to to have a variable column prompt that you put hidden on your dashboard that looks at the month variable you're prompting and updates on the fly too, using SQL:

Variable name: @{previousmonth}

sql: select "Dates"."Period" from "Subject Area" where 1=1 and "Dates"."Period" = @{pro_005}{10} -1

So then go into your report and set the column heading just like you did for the current one so it'd be:

Previous Month @{previousmonth}{09}

This probably isn't the best/most elegant solution but it will do what you're asking.

Am also having same requirement ...let me know how you fixed this issue .