Add data into a cube

#1

Hi,

I would like to know how do we go about adding data into a
multidimensional cube.

Thanks in advance
Deepa

#2

Right-click cube from Analysis Mgr console, choose Process, then choose the
Incremental option.

tom @ the domain below
www.tomchester.net

"Deepa Pai" <dpai (AT) worldbank (DOT) org> wrote

Quote:

Hi,

I would like to know how do we go about adding data into a
multidimensional cube.

Thanks in advance
Deepa

#3

Thanks Tom,
I am sorry I meant is it possible to dynamically add a
record into the fact table or into a cube through a MDX
query etc.

Deepa

Quote:

-----Original Message-----
Right-click cube from Analysis Mgr console, choose
Process, then choose the
Incremental option.

tom @ the domain below
www.tomchester.net

"Deepa Pai" <dpai (AT) worldbank (DOT) org> wrote in message
news:0b0901c38d51$46822eb0$a101280a (AT) phx (DOT) gbl...
Hi,

I would like to know how do we go about adding data
into a
multidimensional cube.

Thanks in advance
Deepa

.

#4

Quote:

I am sorry I meant is it possible to dynamically add a
record into the fact table or into a cube through a MDX
query etc.

If you need to modify cells in the cube through MDX statements - take a look
at UPDATE CUBE statement.

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

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

Add data into a cube

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

Add data into a cube - 10-07-2003 , 11:04 PM

Re: Add data into a cube - 10-08-2003 , 01:36 AM

Re: Add data into a cube - 10-08-2003 , 02:03 AM

Re: Add data into a cube - 10-08-2003 , 03:23 PM