Way to get Previous month booking

Question

Hi,

I'm very new to OAC and I'm finding trouble with the following case.

I have a situation: when the user selects the month in the prompt, he could able to see Selected month bookings, as well as previous month bookings (in two separate charts) in the dashboard.

How can I get previous month bookings dynamically? I searched for a function, but I didn't find any direct function or formula to create a measure.

Ex: If I have the following data, and if a user selects Mar in the 'Month' prompt, I could able to show Feb sales as well (in a separate performance tile chart).

Month  SalesJan$1000Feb$2000Mar$3000

Thank You,

Krishna Kalyan

Jerry Casey · Answer

If you can prompt using a numeric month, name a presentation variable in the prompt, such as varMonth.

Filter your query on "YourTable"."Month" =@{varMonth}{3} OR YourTable"."Month" =(@{varMonth}{3}-1)

Gianni Ceresa · Answer

If you are using OBIEE you must have a proper time dimension, right?

In this case use the AGO function. (AGO only works with a dimension having the needed levels and configured properly as time dimension)

User_ON8FM · Answer

I'm using OBIEE. Using the above formula, I can get previous month timestamp.

Actually, I need to display Previous month Value.

Any help on this?

I'm creating analysis and adding it to the dashboard which has Month and Year prompts. The measure should display the earlier month bookings data as per the prompt selection.

I tried, using the workaround shared by Gianni. It's showing value in analysis, but in the dashboard, same chart shows '0.00' as value.