September 22, 2008 at 3:43 am
Hi
When we report on our cube and we come onto crosspoints where no data exists, the cube reports us the total amount.
As IT men we know this, but when standard users will not mention this and will use these totals within their figures.
How can we make that our cube presents zero values in stead of summarised data ?
kind regards
El Jefe
JV
September 25, 2008 at 9:43 am
It's hard to tell from your post, exactly what you're trying to accomplish. However, some general guidelines:
a) you need to carefully evaluate the data you're loading into the cube and how it will be treated when it's aggregated. In general, it's easier to use SUM (the default). Special considerations exist when using other aggregation methods. Consider each dimension by itself and in combination.
b) using the "Calculations script", you can override how facts aggregate and present themselves. There's many different senarios (too many to post here). However, invesitage how SCOPE works as in:
SCOPE [Measures].[my fact];
SCOPE [my dimension].[the hierachy].[All];
this = override calculation;
END SCOPE;
END SCOPE;
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply