Home Forums Data Warehousing Analysis Services Small numbers in the cube shown as zero in excel - rounding error? RE: Small numbers in the cube shown as zero in excel - rounding error?

  • Negmat 18367 - Monday, April 23, 2018 12:06 PM

    Hi all,

    I've created a Tabular SSAS Cube recently.  Certain numbers within the cube are very small (e.g. 0.0000612762).

    When I connect to the cube from excel to look at the data, these small numbers are shown as zero.

    Has anyone encountered it before?

    Is data being truncated in the cube if it is very small?

    Please advise.

    Thank you!

    Have you changed the format to increase the decimals shown?

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2