I'm new in OLAP, I try to browse Cube in Excel. In normal situation, EMPTY cells won't appear, but if I add a Calculated Members, all EMPTY cells appear, fill my page with blank and zero values.
How can I make a Calculated Member that depends on EMPTY / NON EMPTY status of a measure. I want my Calculated Members treated as EMPTY if the values it's calculted also EMPTY.
I found that the NON EMPTY BEHAVIOUR in the Calculated Members Properies in the Cube Editor promise to be able to solve this, but it just don't work.
For the "value expression" in the "Calculated Member Builder" can I say something like :
iif(isEmpty([Measures].[Target Ton]), <<empty expression>>, [Measures].[Sales Ton]/[Measures].[Target Ton])
How can I say this <<empty expression>> ?
How can I make a Calculated Member that depends on EMPTY / NON EMPTY status of a measure. I want my Calculated Members treated as EMPTY if the values it's calculted also EMPTY.
I found that the NON EMPTY BEHAVIOUR in the Calculated Members Properies in the Cube Editor promise to be able to solve this, but it just don't work.
For the "value expression" in the "Calculated Member Builder" can I say something like :
iif(isEmpty([Measures].[Target Ton]), <<empty expression>>, [Measures].[Sales Ton]/[Measures].[Target Ton])
How can I say this <<empty expression>> ?