0CAL MONTH or 0FIS YEAR

Hi friends,

i want to generate a report that was displayed as month wise salary of employee..

for this what can i do....

1. i designed my cube with EMPLOYNO is the Charecterstic and SALARY is the keyfigure..

for getting month wise salary.. what can i do... how can i design my cube..

ex...

EMPNO SAL

1001 JAN 5000

FEB 6000

MAR 5000

1002 JAN 9000

FEB 6000

MAR 8000.....

in this manner i want my report.... . could you plz give me the solution..

thanks

@jay