You are not logged in.

crossing dimensions in excel

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.

josekote

Intermediate

  • "josekote" started this thread

Posts: 7

Date of registration: Mar 29th 2012

  • Send private message

1

Tuesday, April 3rd 2012, 11:43pm

crossing dimensions in excel

friends I am new to the forum, and I have problems with the intersection of dimensions.
place an etl, a record 2 connections to my database extraction and another clubdatabase.
extract data from a relational database SQL Server2005,
3 visits and then I load my extraction to stick as database dimension, these 3-dimensional position and run my task.

I open Excel and paste my view of my size but my area dimension I get always the value to 0 (zero) attached image.

mushas thanks for your help.
josekote has attached the following images:
  • 1.jpg
  • 2.jpg

kratzer

Master

  • "kratzer" is male

Posts: 87

Date of registration: Feb 23rd 2006

Location: Karlsruhe

Occupation: IT

  • Send private message

2

Wednesday, April 4th 2012, 8:02am

Welcome,

some hints to your problem:

- is your ETL process set up for 3 or 4 dimensions?

- to check if any data did arrive see this recent post: http://www.jedox.com/community/palo-foru…ight=#post14411

- did your ETL tool give any errors?

josekote

Intermediate

  • "josekote" started this thread

Posts: 7

Date of registration: Mar 29th 2012

  • Send private message

3

Wednesday, April 4th 2012, 3:32pm

cube does not display data in excel

Thanks for your reply.

my etl process currently has 4 dimensions.

no errors but warnings attached log
josekote has attached the following file:
  • LogEtl.txt (3.68 kB - 52 times downloaded - latest: May 21st 2013, 4:54pm)

konradmai

Master

  • "konradmai" is male

Posts: 54

Date of registration: Apr 18th 2007

  • Send private message

4

Thursday, April 5th 2012, 10:16am

Hello Jose,

the dimensions have to be in Tree format. It seems that you take the result of your database extract as input for the dimensions. Instead you should first build Trees from your database extracts (for example with the Transform TreeFH). And then take these Trees as input for the dimensions.

Have a look at the ETL manual.

BR,
Konrad

Similar threads

Used tags

dimension, excel

Rate this thread