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.

[ganeshreddy]

FYI, the last metric in first pivot table is showing total correct but not east and west values. This is what my actual problem. sunindia please spend some time in this.

Thanks,

Ganesh.

[ganeshreddy]

Can any one help me on this!!!!

[PrashantSangle]

Hi,

Try AGRR() in your expression

modify your expression like

sum(aggr(YourExpression,Dimension))

Regards

[kavita25]

what is the expected Output...

For East & West Region??

[ganeshreddy]

Hi kavita,

Expected output(total) is 206 only it is matching with below table, but values for east and west are wrong i am not sure about the values because it is a limited load.

Regards,

Ganesh

[ganeshreddy]

Hi Max dreamer,

i tried this but here it is count and i am not sure about dimention because it is with drill down dimention.

Regards,

Ganesh.

[ganeshreddy]

FYI...East and west field sum is not matching with Total in first table.

[kavita25 · Accepted solution]

Yess...

check the qvw..

I am not sure about the values whether it'showing correct or not..but the values are matching now....

[ganeshreddy]

Thanks a lot Kavita, a slight change i took following exp

sum(aggr(Count({<EquipmentGroupName=,EquipmentClassName=,EquipmentCategoryName=,EquipmentModelName=>}distinct EquipmentId),EquipmentModelName))    

i have changed dimension for aggregation.

Best Regards,

Ganesh.