Handling Department by Zero problems inside MDX Data YTD – “Automagically, a year top is questioned. No for example top is actually found in the cube” Mistake in MDX Handling Split of the Zero errors are essential into the MDX. This means that we are able to call-it due to the fact Split up from the NULL errors in the MDX. The brand new mistake that show once you you will need to separate by Zero/Null was “step one.#INF”. Allows discover a tiny analogy. Today We have composed a calculation to check on (Transformation Matter)/(Discount Matter) for everybody products and the brand new query turns out – with member [Measures].[Sales to Discount] as [Measures].[Sales Amount]/[Measures].[Discount Amount] SELECT < [Measures].[Sales> on COLUMNS , [Dim Product].[English Product Name].[English Product Name] on ROWS from [Adventure Works DW] (more…)