July 9, 2008 at 12:51 am
Dear friends I have two small questions to SSAS. I live in Denmark, and when we write figures we do it with . instead of , as 1000-separator, eg. the number 1234 is not written as 1,234 but 1.234.
How do I control that in my cube.
Another question: How do i change null to 0 in the cube.
Søren,
MCITP SQL 2008 (administration / programming), MCITP SQL 2005 (BI), MCT
July 9, 2008 at 5:40 am
Measures have a format property that you can set to use a period rather than a comma for numbers.
As far as the NULL question, it depends on what you are actually trying to do. NULL is very different than Zero. Typically, I am very careful to not allow NULL values anywhere in my cubes, but if they end up in measures you should typically handle NULL with the client accessing the cube. You could create a calculated measure to convert NULL to 0, but the way the conditional statements are processed by Analysis Services, you will ruin your cube performance (block aggregations in AS 2008 will help fix this).
Usually handling NULL values should be handled as a display issue. If you are using Excel for your cube access, there is a property of the pivot table that tells it what to display in empty cells. Most good cube browser applications have something similar.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply