Addressing Department from the Zero errors into the MDX Computations
YTD – “Automatically, a year peak is requested. No eg top is found in the cube” Mistake inside MDX
Addressing Divided of the No problems are very important from inside the MDX. To put it differently we could refer to it as just like the Separated because of the NULL problems in MDX. The brand new error that show after you just be sure to split by Zero/Null is actually “1.#INF”. Allows find a little example.
Now I have created a computation to evaluate (Conversion process Count)/(Dismiss Count) for everybody services the newest inquire 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]
