Virtual Fields

 

image\cubevirtualfield.gif This icon enables you to create virtual fields.

 

The language used in the calculation fields is the Microsoft MDX language.

 

Please find below several function examples which make reference to other periods.

 

In the following examples you must have at least one Time dimension with several levels in the cube (a Date field or a TimeStamp field for example).

 

Functions:

 

currentmember.prevmember

 

lastperiods

 

periodstodate

 

IIF