I build one cube, in that I have 8 dimensions like “periods”,’plants’,’commodit

[ramakrishnamanne]

HI All,
I have one query ,

Problem:-
I build one cube, in that I have 8 dimensions like  ââ,¬Å"periodsââ,¬Â,ââ,¬â,,¢plantsââ,¬â,,¢,ââ,¬â,,¢commoditiesââ,¬â,,¢,ââ,¬â,,¢startcodeââ,¬â,,¢,ââ,¬â,,¢marketsââ,¬â,,¢,ââ,¬Â¦.suppliers,buyers. And  4 measures like  Invoice,invoice quantity,pri yr min purchase,supplier count.I have created PPR reports from that cube .In this my problem is when I open the report and  select the categories (filtered) in ââ,¬Å"markets dimension  ââ,¬Å" all measures values are changing it ok but  when I select the categories ( filtered) in ââ,¬Å"supplier dimensionââ,¬Â ,I donââ,¬â,,¢t want to change ââ,¬Ëœpri yr min purchaseââ,¬â,,¢ measure values, it should be  constant.

Which properties I will set in transformer?
Thanks & Regards
Rk

[mhamilto]

I think you'll have to make sure that Supplier and pri yr min purchase are not in the same query.