Re: selective summation

#1

I assume your time dim derived from the fact table? This is not good. You
should have a dimension table for time, ala foodmart, in which case you can
report on any date regardless if facts exist.

tom @ the domain below
www.tomchester.net

"confused_guy" <member42310 (AT) dbforums (DOT) com> wrote

Quote:

I've got a cube storing sales data. (Oh, I'm using SQL Server Analysis
Services to create this cube, btw.) There are other dimensions in that
cube, but the one of concern is TIME. This TIME dimension is
structured as -

TIME

------

Year

WeekStart

Date

Using this time dimension the appropriate weekly and yearly sales totals
can be found, by drill-up/drill-down.

Consider a scenario where the sales record for a certain date in the
fact table is NULL, ie no sales were recorded for that date. Normally,
in analysis services, when the weekly sales total is shown the NULL
sales data is ignored and a sum of sales from other dates is shown. But
is there any way of showing a ZERO sales total for that week.

What I mean is, whenever sales data for a day is missing the sales total
for that week should be zero. Is this sort of a thing possible in
analysis services?

--
Posted via http://dbforums.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: selective summation

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: selective summation - 10-14-2003 , 08:07 PM