Cube with unwanted data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Cube with unwanted data

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.
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

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.