Re: Constraints on measures

#1

Borr,

I'd recommend that you create the forecast data as a separate cube and
disable the day level of the time dimension in it. You can then combine
that with the sales cube into a virtual cube. That should work for you.

Sean

--
Sean Boon
SQL Server BI Product Unit

Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.

"borr" <bdorr39 (AT) hotmail (DOT) com> wrote

Quote:

Hi,

I have a sales cube that has forecast quantity as a
measure (along with many other measures). The Period
dimension allows you to drill to the year,quater,month and
day. The problem is, we only forecast by the month, so
when the user drills down past the month, they will get
incorrect numbers for forecast quantity.
Is there any way to give the uers a default value of "NA"
for forecast quantity when they drill down to the day
level?

Thanks,

Borr

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

Re: Constraints on measures

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

Re: Constraints on measures - 07-15-2003 , 12:04 PM