Dimension level does not consolidate

sentosa · Jul 8th 2007, 4:15am

Hi!

I have been having a frustrating problem.
I am testing Palo with Foodmart sample from SQL2000 analysis services.
I have loaded the location dimension - screen Location Heirarchy attached below
When I paste view at the store 3 level - data is okay.
When I concolidate at WA level, data does not consolidate.

Why?

Can anyone help me?

Herman

Stephanie · Jul 10th 2007, 5:40pm

Hello Herman,

Could you please upload your sample?

Thanks!

Regards,
Stephanie

sentosa · Jul 10th 2007, 7:40pm

Hi,

The Foodmart sample is about 27MB.
It is a standard BI sample database.
I found a link you can download from...
acs.senecac.on.ca/ftp/ms/foodmart_2000.mdb

Do you want me to upload my cube database?
How do I do that?

Herman

Stephanie · Jul 12th 2007, 9:38am

Hello Herman,

You can either zip the folder and upload it right here or send me the
database via email. Stop Palo server, zip the according database of
the "data" folder of your installation all files included (csv, log etc.).

Regards,
Stephanie

sentosa · Jul 17th 2007, 5:28pm

Hi Stephanie,

I have emailed you the zipped database.
Did you find the same problem with the database?

Herman

Stephanie · Jul 18th 2007, 2:46pm

Hello Herman,

I can reproduce this, but have to do some more investigation.
I will provide you with feedback asap.

Regards,
Stephanie

Dimension level does not consolidate

Dimension level does not consolidate

RE: Dimension level does not consolidate

RE: Dimension level does not consolidate

RE: Dimension level does not consolidate

RE: Dimension level does not consolidate

RE: Dimension level does not consolidate

Share

Users Online 2