You are not logged in.

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.

BMWTouring

Intermediate

  • "BMWTouring" is male
  • "BMWTouring" started this thread

Posts: 9

Date of registration: Apr 1st 2012

Location: Netherlands

  • Send private message

1

Sunday, April 1st 2012, 12:21pm

Dimension only reads column one from File Extracts

I have accomplished a succesful connection
made a succesful extracts --> File
can see al the data and fieldnames when i click on
made a Cube
made the Dimensions corresponding the Extract and Cube
made a succesful Job

But....it only extracts and loads only the first column in all the dimensions.

How can this happen? it looks like ETL does not map the Dimension to the Field Name from the Extract....it makes Attributes???

tish1

Sage

Posts: 826

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

2

Wednesday, April 4th 2012, 12:28pm

Hi,

did you transform your source data of type "table" to type "tree" before loading the dimension? This can be done via Transforms "TreeFH" or "TreePC".

Regards.

BMWTouring

Intermediate

  • "BMWTouring" is male
  • "BMWTouring" started this thread

Posts: 9

Date of registration: Apr 1st 2012

Location: Netherlands

  • Send private message

3

Wednesday, April 4th 2012, 5:30pm

Hi

I followed your idea and it worked. I have to work out when to use TreeFH and when TreePC...

Thanks!

tish1

Sage

Posts: 826

Date of registration: Jul 13th 2009

Location: Vienna / Austria

Occupation: Senior Consultant @ Vector SW DV GmbH

  • Send private message

4

Thursday, April 12th 2012, 8:50pm

Hi,

gernerally TreeFH is for balanced hierarchies (ProductSegment, ProductGroup, Product), while TreePC is more flexible when you have to create ragged hierarchies like in account dimensions.

Regards.

Used tags

dimension, Extract, loads

Rate this thread