Is there a MDX function for this?...

#1

Thanks for your reply JeJe.
I am using AS2000.

With regards to your question, it will never happen.
I only ever return 1 day of distinct results in the result set.

Quote:

what's appends in this case?

Date Measure
1/1/06 0
2/1/06 200
3/1/06 0
4/1/06 100
5/1/6 0

what is your value for the day with 0?
do you use AS2000 or 2005?

"Immy" <therealasianbabe (AT) hotmail (DOT) com> wrote

Quote:

Hi all,

I want to simply take a value that is returned in my fact table for a
measure and copy is across all cells for that measure.

Current result

Date Measure
1/1/06 0
2/1/06 0
3/1/06 100 -- there will only ever be 1 value for any day
4/1/06 0

Desired result

Date Measure
1/1/06 100
2/1/06 100
3/1/06 100 -- just copy this value to all cells and allow it to
roll up to 400 when drilled up.
4/1/06 100

Regards
Immy

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

Is there a MDX function for this?...

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

Is there a MDX function for this?... - 08-22-2006 , 08:56 AM