Navigational Attribute is not displayed in the report.

Hi Experts,

I am working on a Actual vs Target report. I want to see the Actual Quantity sold Vs Target Qty base on Region ( N / E / W / S ) , State and Dealer.

The report should look like below mentioned.

REGION ( N /E/W/S ) STATE DEALER ACTUAL QTY TARGET QTY N J & K 1000450 100 200 E ODISHA 1000152 280 350 S KARNATAKA 1000415 450 540

But the same is appearing like below mentioned.

REGION (N/E/W/S) STATE DEALER ACTUAL QTY TARGET QTY N J & K 1000450 100 E ODISHA 1000152 280 S KARNATAKE 1000415 450 Unassigned 1000450 200 1000152 350 1000415 540

This is working fine in quality system. But not appearing properly in Production system.

The actual data comes from one Info-cube . The Plan data, we load through Excel to a second cube. And finally merging the data by a multi-provider.

I am not able to find any clue , what for this is happening.

Kindly suggest.

Thanks,

Sanjana.