Issue with query on Multiprovider which includes InfoCube & Master data.

12 Views

We have an infocube MAC in which 'Client' is a charateristic, which has a NAV attribute - 'Leader' (which is a reference characteristic to 'Employee')

InfoCube - MAC

- Characteristic - CLIENT

-- NAV Attribute - LEADER (ref. char to EMPLOYEE)

InfoObject EMPLOYEE

- NAV Attribute - REGION

The requirement is to get a report on the transaction data (say Revenue) of the cube MAC by the REGION of the LEADER.

What we tried ..

Created a multiprovider MULTIPROV to include InfoCube MAC and Infoobject EMPLOYEE.

Added a dimension in MULTIPROV and put EMPLOYEE in that new dimension. For the assignments of EMPLOYEE in the multiprovider, we mapped from EMPLOYEE InfoObject and from LEADER in MAC cube.

When we looked at the report 'by region', the REGION shows up as 'Unassigned'. If we made the REGION not NAV (DIS), it shows up fine.

Please let us know if there is a way around to make this work. thankyou !