Skip to Content
0
Former Member
Nov 25, 2009 at 10:15 AM

BEx Query

14 Views

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.