Hi,
I hope someone can help me out in my problem.I am using Analysis services 2000 and have prepared the cube with sql server 2000 database. I am using XLCube as reporting tool. When I drag and drop a measure which has null values, it will be displayed as '0' on xlcubed reports. But I want it to be blank coz even '0' is considered as value.Tried setting XLCube options which didn't work, Any Solutions?
i think in MSAS2000 the NULL values are stored as 0 by default
No comments:
Post a Comment