This content has been marked as final. Show 6 replies
My apology, I didn't explain my issue clearly. What I am trying to do is basically create a report where when the end user opens a dashboard for lets say yr 2012, then data for 2011 will also come up for comparison purpose. Or if you select 2013, then 2012 comes up with its data along with the differences btn 13 year to the 12 yr... How do I go about, this? I created one report filtering a specific year; now I need re-create another one but I am thinking may be I can create a dashboard prompt to enable this. what do u think?
Any suggestion is highly appreciated...
You might be using Prompt to select year, try to set presentation variable
In the report filter by Year and use the presentation varible
for another report substract -1 from presentation variable
Try to convert the filter to SQL from column->Filter->Advanced button
You might get datatype issues for previous year when substracting -1 try to use cast.
If helps mark
Edited by: Srini VEERAVALLI on Apr 11, 2013 2:24 PM
Thanks for the prompt response, I am not quite sure If I understood. I can easily create a presentation prompt, however will this prompt bring let's say 2012, 2011 and the comparison/difference at the same time?
If my Time Dim table is "time" "fiscal year date"; can you give me the sample SQL statement? Cause I tried writing the SQL statement it didn't work
Sorry, I am still new in OBIEE