You are not logged in.

How can i imput the fact data?

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.

sirtian463

Intermediate

  • "sirtian463" started this thread

Posts: 5

Date of registration: Jun 30th 2006

  • Send private message

1

Thursday, July 6th 2006, 5:30am

How can i imput the fact data?

Now, i follow the example "Importing Dimension Elements" in tutorial pdf, i have created the dimensions. But the example does not continue to import the fact data which exists in the metadata.txt, so i decides to continue it .

I hava created the fourth Dimension Measures, and in the Measures Dimension, i create Units element. And in newly created cube "market", it has four dimensions, look like the beneath :


now i changed the formula to "=PALO.SETDATA($G$1,FALSE,"localhost/Demo1","marktet","2005",$B$1,$D$1,"Units")" ,
then imput metadata.txt again, but in my created view, there is always zero in cell.

who can tell me what should i do?
sirtian463 has attached the following image:
  • meta cube difinition.gif

sirtian463

Intermediate

  • "sirtian463" started this thread

Posts: 5

Date of registration: Jun 30th 2006

  • Send private message

2

Thursday, July 6th 2006, 5:35am

the difinition of imput formula

the formula like the attachment:
sirtian463 has attached the following image:
  • meta fact import problem.gif

h_decker

Sage

  • "h_decker" is male

Posts: 763

Date of registration: Oct 26th 2005

Location: Cologne, Germany

  • Send private message

3

Thursday, July 6th 2006, 11:01am

RE: the difinition of imput formula

Hi,
it seems like the time-element "2005" is a consolidated element. Check out that SETDATA-Funtion in your sample only targets base-elements.

Greetings from Cologne
Holger

v_malicevic

Palo Team

  • "v_malicevic" is male

Posts: 455

Date of registration: Oct 26th 2005

Location: Germany

  • Send private message

4

Thursday, July 6th 2006, 11:05am

RE: the difinition of imput formula

Hi!
Try executing one single isolated SETDATA per hand and eventually check palo.log for errors. It is possible that you try to do write data on consolidated element in which case you should do the “splashing”.
Mit freundlichen Gruessen/ With kind Regards / Meilleures salutations

Vladislav Malicevic
Head of Research and Development

Jedox AG
Rate this thread