Addressing Section of the Zero mistakes in the MDX Computations
YTD – “Automatically, annually peak is actually expected. No including level are based in the cube” Mistake within the MDX
Addressing Separated by No errors are essential during the MDX. Put simply we are able to call-it while the Divided because of the NULL errors during the MDX. The fresh error that show once you make an effort to split from the Zero/Null try “step 1.#INF”. Lets get a hold of a tiny example.
Now I have authored a computation to check on (Conversion process Number)/(Disregard Number) for all services the new query works 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]
For people who work on the above ask you can find many beliefs coming because “1.#INF” while the Dismiss Matter is actually possibly NULL otherwise 0 for almost all things and you will PFB Screenshot of the same.
Lets observe will we incorporate IIF standing to help you stop such problems. This new IIF Updates sentence structure within the MDX is really as listed below.
IIF(position,true,false) – When your standing holds true after that earliest part would be carried out more next given about iff condition. (suite…)