Skip to Content
author's profile photo Former Member
Former Member

Previous month data using current month input selection

Hi,

I am looks for suggestion in fulfilling a report requirement. Our users want to see selected month and previous month data in 1 report table

Data is at a daily level and users doesn't want to give 4 date selections (2 for getting current month data query and 2 for previous month data query) to get the desired output

Is there a way to get current and previous month data by just current month start date and end date

Our Environment: BO 4.0 SP06, WebI report, Oracle 11g

Thanks,

Mitch

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 06, 2015 at 09:13 AM

    Hi,

    First you create two dimension objects in the universe, where you calculate current month, and previous month. Then you create a month dimension which takes the month from your date dimension.

    Then you create your first query and set your newly created month dimension to be equal to your current month, as a filter.

    Lastly you create the previous month query and filter in the same way, but with the previous month object.

    In your report, you then merge the common dimensions you want in your table, and then you are able to get the two measures next to each other.

    Hope this helps.

    /Kris

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.