Bit of a weird issue here. Created some cube calculations.
CREATE MEMBER CURRENTCUBE.[Measures].[SLl]
CASE WHEN [Measures].[R]= 0 THEN 0
ELSE ([Measures].[I]/[Measures].[R] )
FORMAT_STRING = "00.00%",
VISIBLE = 01 , ASSOCIATED_MEASURE_GROUP = 'LS' ;
for some reason when I have the dimension Product on rows then the Measures I and R may be null (no fact records) , but there is a row for the Product dimension member.
I have tried this In cube browser and Excel 2007. I feel like I am missing something here. When I have done this previously (too many years working in SSIS and not enough SSAS) this work perfectly.
What am I missing.