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.

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

1

Wednesday, March 14th 2012, 7:07pm

Loaded and filled Cube doesn't show the data, but export it

Hello,
I noticed a problem as follows:
1) ETL-Load into Cube works fine, success was stated, no errors or warnings, BUT:
2) Then cube was (tried...) to examine via Excel, Web-Spreadsheet and Palo Analyzer --> empty, when choosing all dimensions as All and only one small dimension and Measures on the grid; activating zero suppression, nothing remains displayed indicating it's really empty
3) Cube-properties indicate that data is loaded (cells filled)
4) .csv-export of cube data definitively result in data in the text file, so it exists in the cube as stated by ETL and Cube properties

Until now I never needed to activate a cube after loading or something like this. Manual inserting works anyway.

So my question is: Are there typical pitfalls I might have ignored? Is this a known issue? Some ideas somebody?

Any hint is highly (and desperately :| ) appreciated...

Best regards,
Stefan

kratzer

Master

  • "kratzer" is male

Posts: 92

Date of registration: Feb 23rd 2006

Location: Karlsruhe

Occupation: IT

  • Send private message

2

Wednesday, March 14th 2012, 9:11pm

Hi,
did you check a view on the N-level without any C-elements, not on ALL nodes? Did you trace one single cell and it's value which was exported? Perhaps dimensions went wrong during a parallel ETL process.

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

3

Thursday, March 15th 2012, 1:31pm

Hi, thanks a lot for the reply.

Really, it was an consolidation bug... unfortunately the frontends look like no values contained on zero suppression, good to know this...

Now I noticed, that my dimension elements are typed as S-type, not N-type. But I can't find something to influence this in ETL... I guess it's similar to TM1, that atomic elements need to be "numeric" even if they have string content?
The dimensions was loaded sequentially, and now the consolidation would look good in OLAP Manager, if the atomic elements would be numeric... (All Countries indicated as a C-Element, below of that several S-Elements as the atomic level).

How could I determine the ETL-Process to write the elements as numeric? I used a TreeFH Transform to generate the dim's hierarchy, and configured Global element type = Numeric; but this has no effect.
Any other switch somewhere...?

ethssn

Master

  • "ethssn" is male
  • "ethssn" started this thread

Posts: 54

Date of registration: Feb 16th 2012

Location: Hamburg

Occupation: BI-Consultant

  • Send private message

4

Thursday, March 15th 2012, 3:21pm

I got it. It's not sufficient to have only one dimension with leaf elements = numeric to ensure, that the consolidations aggregate the values, but needed for alle dimensions in the complete cube, as it seems. Thats why I had no success when changed the Global element type to numeric only in one TreeFH-transformation in ETL. It worked, but had only effect to the cube after doing so for all...

Here is a referring post, which gave me the hint: http://www.jedox.com/community/palo-foru…d&threadID=2944

Rate this thread