Data Model issue!!!

[ganeshreddy]

Hi All,

Here we got two pivot tables with different drill down groups, first table drill down is from profit center table and second one is from equipment table. The issue i am facing here is, the last metric(Total equipment) is showing wrong values for the field values but total value is correct. I tried to move profit center table, and connected to equipment table, in this case i am only getting last metric values right not the reaming metrics. I am suspecting that some ware in the fact table(WOsummary) i am doing my calculations wrong , means not aggregating values with profit center drill down group. Can anyone provide me solution for my problem. Please find the attached QVW.

Best Regards,

Ganesh.

[kavita25]

Yeah...Even in the modified qvw I have used the same field...

Previously i had Used Group Name...

Its good you got ur solution

[ganeshreddy]

Hi,

I found one more issue here Kavita, drill down in first table is not working for Total Equipment metric, can you suggest me form which fields i should aggregate again.

Thanks,

Ganesh.