KB43660: How to filter data for current month in cube report with view filter in MicroStrategy 9.x-11.x

In some business scenarios, it is required to filter data for current month in cube report with view filter in Strategy 9.x-11.x
 
The following steps demonstrate how to do this in Strategy Tutorial project:
M1=CurrentDate()

1. Create an Intelligent cube with Month and Revenue. The month ID for 2004 Jan is like 200401.
2. Create a cube report based on the cube.
3. Create two derived metric M1 and M2 in the cube report as shown below:

M2=Year(M1)*100+Month(M1)
 
 

• M2 will get value 201001 if current day is 31/01/2010. Create a view filter "Month where ID exactly M2". Run the view report, it only returns the current month data as shown below:

 
 
KB43660