You are not logged in.

JOB don't creat CUBE

Dear visitor, welcome to Palo Community Forum. If this is your first visit here, please read the Help. It explains in detail how this page works. To use all features of this page, you should consider registering. Please use the registration form, to register here or read more information about the registration process. If you are already registered, please login here.

JuergenK

Professional

  • "JuergenK" started this thread

Posts: 24

Date of registration: Jul 10th 2010

  • Send private message

1

Wednesday, October 13th 2010, 3:45pm

JOB don't creat CUBE

Hi everybody!

I have created a TABLE JOIN and than a LOAD CUBE. I have tested both and I got no warnings.

After this steps I create a JOB, with these LOAD CUBE but I got following warning:

"ERROR : Cannot import Data into Cube Kunden_Umsatz: Failed to initialize cube Kunden_Umsatz: Dimension NUMMER does not exists."

The Dimension NUMMER is the first column in the table. I have tried CREATE, ADD, UPDATE CUBE but no success.

Can anybody help me please?

Thanks, Juergen

Etan

Intermediate

  • "Etan" is male

Posts: 15

Date of registration: Apr 16th 2010

  • Send private message

2

Wednesday, October 13th 2010, 6:15pm

Hi Juergen,

first of all you have to create the dimensens which are needed in the cube.
Dimensions are independent of the cube, because you can use one dimension in more then one cube f.e. Month.

Every dimension need a separate ETL-process.

After that you can built the cube (you can use your import) with the option create.

Regards

Etan

tish1

Sage

Posts: 761

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

3

Wednesday, October 13th 2010, 9:50pm

Hi,

please be aware that the dimensions will be added in the cube in the order provided be your load. So be careful about the implications.

Regards.
Robert Tischler
Senior Consultant Vector SW DV GmbH

JuergenK

Professional

  • "JuergenK" started this thread

Posts: 24

Date of registration: Jul 10th 2010

  • Send private message

4

Wednesday, October 13th 2010, 11:38pm

Hello,

thanks for answers. Indeed I have forgotten the DIMENSIONS in LOADS. I will have a look at the order of the dimensions in the load.

Thanks, regards
Juergen

JuergenK

Professional

  • "JuergenK" started this thread

Posts: 24

Date of registration: Jul 10th 2010

  • Send private message

5

Thursday, October 14th 2010, 5:52pm

Hello,

until now I couldn't create my cubes effective for working at Excel too.
I need the ETL process for data imports, but I haven't found the right way to call them (with dimensions) at Excel.

Have anybody an workaround or workflow solution?

Thanks, Juergen
Rate this thread