Month range selection in a cube report

[terry_stjean]

I am building a report based on a cube. The date dimension consists of Year/Quarter/Month.
I have to allow the user to select a From and To Month for the report.
Suggestions on what type of prompt for the Prompt screen and syntax in the query would be great.

[terry_stjean]

Never mind. I found an example.

[cognostechie]

Can you post the solution here?

[terry_stjean]

intersect(lastPeriods(-9999, [Compensation Cube].[Date].[Date].[Month]->?pFrMonth?),
lastPeriods(9999,  [Compensation Cube].[Date].[Date].[Month]->?pToMonth?))

There are 2 Value prompts and they display the Month level from [Compensation Cube].[Date].[Date].[Month].

[cognostechie]

Thanks. I found the same from IBM KB.

I also added a column to sum up the data for all the Months selected from the Prompt

total(currentMeasure within set[Range of Months])

In this case 'Range of Months' is the name of the data item containing your calculation.