Fill empty values of virtual cube

#1

Hi,

I have 2 cubes which are connected in a virtual cube. One cube is only
using one dimension, the second cube has several dimensions. When I
browse the cube, only the All-Level of all dimensions not existent in
the first cube are filled. What I want to have is that the value of
the All-Level is copied into all levels and cells of that dimensions.

How can I do that?

Thanks,

Thomas

#2

The ValidMeasure() MDX function is what you need. It's documented in Books
On Line.

Sean

--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Thomas Pagel" <tpagel (AT) masp (DOT) de> wrote

Quote:

Hi,

I have 2 cubes which are connected in a virtual cube. One cube is only
using one dimension, the second cube has several dimensions. When I
browse the cube, only the All-Level of all dimensions not existent in
the first cube are filled. What I want to have is that the value of
the All-Level is copied into all levels and cells of that dimensions.

How can I do that?

Thanks,

Thomas

#3

Sean,

thanks, this works perfectly...

Thomas

"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> schrieb im Newsbeitrag
news:%23TTIFPNxDHA.2456 (AT) TK2MSFTNGP12 (DOT) phx.gbl...

Quote:

The ValidMeasure() MDX function is what you need. It's documented in
Books
On Line.

Sean

--
Sean

--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no
rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"Thomas Pagel" <tpagel (AT) masp (DOT) de> wrote in message
news:9c5ef727.0312170958.2b31892e (AT) posting (DOT) google.com...
Hi,

I have 2 cubes which are connected in a virtual cube. One cube is only
using one dimension, the second cube has several dimensions. When I
browse the cube, only the All-Level of all dimensions not existent in
the first cube are filled. What I want to have is that the value of
the All-Level is copied into all levels and cells of that dimensions.

How can I do that?

Thanks,

Thomas

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

Fill empty values of virtual cube

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

Fill empty values of virtual cube - 12-17-2003 , 11:58 AM

Re: Fill empty values of virtual cube - 12-17-2003 , 01:27 PM

Re: Fill empty values of virtual cube - 12-22-2003 , 03:38 PM