Transformer is retaining value if there is no data

[bobg4u]

I developed a Transformer Model with 3 different measures(M1,M2,M3),coming from 3 different data sources.
Data is present only for the current month.But when I build the cube, the current month's data is also shown for all the other months. The first Measure M1(coming from the first data source) is fine, but for the other 2 measures, the data is being repeated for all rows,even though there is none.
What could the reson be?

Thanks
Bob

 

[Shek]

Your measure M1 looks like it is associated wiht the dimensions, hence, you get the data viewed correctly.
eg select A, B, C, sum(M1) FROM.....
and you view against dimensions A and B on X and Y resp in Powerplay you will see correct data for measure M1

but for M2. if your select is something like this
eg select A, C, sum(M2) FROM.....
and you view against dimensions A and B on X and Y resp in Powerplay, you will see data repeated as measure M2 is not associated with B.

You can exclude M2 from B.
Go to particular dimension (B) properties--> Allocation and
select the particular measure(M2) and select DO NOT ALLOCATE.

Abhi