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
I think you'll have to make sure that Supplier and pri yr min purchase are not in the same query.