Show Blank Data in dataview

Previous Member
Previous Member
5 Up Votes First Comment 5 Likes First Anniversary
edited April 2020 in Platform

Hi All,

 

I have a problem with the data view.
I have a cube that has its data contents. and in my dataview settings it's 'Hide Zerro' and Uncheck 'Show All'. so dataview should only show the existing data only (not Zero). But when the result dataview display is blank, after I try extract cube, the cube have data. does anyone know what cause?

image

image

Answers

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    Community Captain First Answer First Anniversary 5 Up Votes

    Hi,

     

    it seems you have a very small value. Just set Dec Digits to 10 or 20 any you should see very small numbers like 0,00000124331

     

    This sometimes can occur due to some calculation. Maybe following Discussion is helpful: https://community.board.com/message/1776-re-dataflow-resulting-in-small-digit-differences?commentID=1776#comment-1776 

     

     

    Regards

    Björn

  • Previous Member
    Previous Member
    5 Up Votes First Comment 5 Likes First Anniversary
    edited March 2020

    Hi,

     

    Thats correct, where i show with decimal = 20 it very small number.

    But i still confuse why cube data have small number. because when i reader to board, the data is big number.

    and when i extract cube,the number is -2.86102294921875E-06.

    image

    are -2.86102294921875E-06 is not equal with -286102294,921875?

     

    because board shown image

  • Björn Reuber
    Björn Reuber Employee, Community Captain
    Community Captain First Answer First Anniversary 5 Up Votes

    Hi,

     

    the extracted value -2.86102294921875E-06  is equal -2.86102294921875*10^^-6 , so its -0,00000286 and this seems to be correct.

     

    regards

    Björn

Categories