You are not logged in.

Import Attributes

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.

rpfahl

Intermediate

  • "rpfahl" started this thread

Posts: 9

Date of registration: Jul 26th 2009

  • Send private message

1

Friday, August 7th 2009, 10:43am

Import Attributes

I need help to configure the Import Wizard (PALO.SETDATA) to import Attributes from ODBC.
How do I have to setup ?

Data (see attachments)

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

2

Friday, August 7th 2009, 11:00am

you have the Palo manual,
you searched this forum on "setdata AND attributes",
you looked at the samples that come with ETL-server

and you did not not understand ... ?

Please be more specific in your question.

rpfahl

Intermediate

  • "rpfahl" started this thread

Posts: 9

Date of registration: Jul 26th 2009

  • Send private message

3

Friday, August 7th 2009, 11:49am

Sorry, for my inability ;-)

I want to import "ProjektNummer" as attribute.

I create following to import "Projektnummer" :

=PALO.SETDATA("ProjektNummer;FALSCH;localhost/Import;#_Projekte;"ProjektName")

ProjektNummer as A1
ProjektName as B1

But it does`t work. What is wrong ???

axi

Sage

Posts: 661

Date of registration: Mar 5th 2009

Location: Germany / Bargteheide

Occupation: BI

  • Send private message

4

Friday, August 7th 2009, 12:05pm

Quoted

Sorry, for my inability ;-)

there is no excuse for inability! skin the newbies!!! d&rvf

The easiest way to build the SETDATA formula
is from a working DATAC formula.

Create a view for the attribute cube --> working DATAC formula

Copy this formula into another workbook, hardcode some references if that helps,
rename it to SETDATA, put reference to your input value and a FALSE into the beginning of the parentheses.

You can even have multiple SETDATA (for all attributes) in your import workbook.

Even better: use the ETL-Server

rpfahl

Intermediate

  • "rpfahl" started this thread

Posts: 9

Date of registration: Jul 26th 2009

  • Send private message

5

Friday, August 7th 2009, 2:17pm

I got it and now - it works.

Thank you very much
Rate this thread