Dimension versus Measure

[Former Member]

Hi,

My universe is based on OLAP cubes(Multiprovider). When i drag [Revenue] key figure/measure , [products] dimension in query and run it am able to see data in report.

however, if i select [Country] dimension into query and run it, I can't see data for [Revenue]. If i remove [Country] then am able to.

Can you please let me know what may be the cause...

Thank You!

[Former Member]

Hi,

There can be 2 possiblities:-

1> You may not have value corresponding for Revenue based on Country at the DB

2> Are you using Merge Dimensions.

Thanks,

Madhu.

[Former Member]

Thanks for reply.

1) We have data for same in SAP BW .

2) No merge dimensions i have.

Any other assumptions.. Please

Thank You!