Create previous month values based on input presentation variable

Question

hi,

i have presentation variable for current month. Based on the input month from prompt i need to genetrate prevous month.

i Also need to do some calculation based on the previous month.

ANy one tell me how can i get the previous month From input presentation variable?

for more info, we are using essbase as a data source for all reports.

SriniVEERAVALLI · Answer

assume you have date field in the report and selected current month from prompt

Date would show some date within current date based on your data, you may use min(date by PromptMonth)

this would give start date of selected month from prompt

use datediff function to get previous month.

Try to get an idea what I'm suggesting! rest you can do your own.

user12863665 · Answer

TThanks for the response Srini.

i am using essbase as a data source, can you tell me more elobarately on how can I get previous month name from current month presentation variable?

SriniVEERAVALLI · Answer

In the report take the date column with expression min or max(date by SelectedMonth)

you may get previous month using this date field for further calculations bla bla ...