Previous quarter

[ky101]

I have an object/db object "Status Percent". Now i need to display in my report 2 other objects "Current Status Percent" and "Previous Status Percent"
where....
Current Status Percent = Status of the year_month that was selected on the prompt page for current Quarter(Status of 201406 )

Previous Status Percent = Status of the year_month that was selected -3 months

SQL , year_month user prompt/input

Current status: select status_percent where year_month = @userresponse(201406)

Previous status : select status_percent where year_month = @userresponse(201406) - 3 months
how should i be accomplishing this?

any inputs highly appreciated.

Thanks

 

[hilfy]

This will probably have to be done in the universe and you'll probably have to use two "merged" queries to get this information. Here's what I would do:

1. In the universe, create a filter using @Prompt() that will get the date like your current report filter.
2. Also in the universe, create another filter using @Prompt() and the exact same prompt text as your first filter. This filter will use your database's syntax to subtract 3 months from the date.
3. In your report, replace your current date filter with the one created in step 1.
4. Duplicate the query that already exists in your report and change the date filter to the one created in step 2.
5. Merge the dimensions between the two queries.
6. For the dimensions on the report, use the merged values. For the measures, use the unmerged values as necessary.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

http://www.decisionfirst.com