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

BEx Query


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.