on 11-25-2009 10:15 AM
I have a multiprovider with 2 cubes:
0pa_c01 and 0py_c02.
In 0pa_c01,I have "No. of employees" keyfigure and "Personnel Area"
In 0py-c02,I have "Personnel Area", "Wage Type" and "Amount" key figure.
Now,In the rows,I have Personnel Area and Wage Type and in columns,I need to calculate "Total no. of employees" key figure in a particular personnel area irrespective of the wage type.
Plz help me find the solution asap.
Create a local selection for No. of employees, restrict with Wage type #, right click on wage type and click on "Constant selection". This gives you the no. of employees corresponding to each personnel area irrespective of wage type. Ex: Cube: Personnel Area Wage type No. of employess P1 # 100 P2 # 250 Report will look like this. Personnel Area Wage type No. of employess P1 W1 100 P1 W2 100 P2 W1 250
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.