SQL Server Performance

Cube with unwanted data

Discussion in 'Analysis Services/Data Warehousing' started by ranjitjain, Oct 26, 2005.

  1. ranjitjain New Member

    Hi,
    I have a cube which takes data from SQL table where column can store NULL.
    The cube processes and fills data as 0 which i dont want.
    I need cube to have empty cell when it is NULL.
    The datatype in CUBE is double.
    How can i set this.
  2. Raulie New Member

    You can use something like the IIF function in MDX to perform conditional testing, but why do you want the the cube to store empty cells?

    Raulie


  3. ranjitjain New Member

    Hi Raulie,
    I am not firing MDX to process the cube. I'm running it through DTS using AS object so how can i add conditional testing.

    I need empty cells in Cubes as the data stored in SQL table can be NULL or any value.
    So if its NULL then its nothing and not zero.
    The MDX which i fire on the cube after processing checks for iif(isempty) condition.

Share This Page