Hi,

I need to copy all data from one member to another member from the same
dimension.

To be more specific, I have a scenario dimension with these members:

->scenario01
->scenario02

And I want to start my scenario02 with the scenario01 data, copy all
the data from scenario01 to scenario02.

Is there a easy way to do that? Any tip will be great.

Thanks,
Handerson

Hi,

What for front end do you use?
Do you write own application and want to write MDX query for it?
What API do you use?


The brutalest method would be "insert .. select" in the fact table :-)

Vladimir Chtepa

"Handerson" <handerson.koerich (AT) gmail (DOT) com> schrieb im Newsbeitrag
news:1137676486.274624.324580 (AT) g49g2000cwa (DOT) googlegroups.com...

Hi,

At first time I was looking for some MDX to do that, because some data
could be in write back table and every six month I will clean my fact
table and build a new partition to acelerate the cube process and save
some space in disc.

But I'm changing my mind, I can't find some MDX function to do that,
then I'm thinking that the only way is to copy the write back table to
my fact table, clean the fact table at 12 months or more and copy the
data in the fact table.

Any better idea?

Handerson

I forgot, my application is a asp.net application. I'm using AMO (to
build the cube) and MDX querys.