Import from 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.

sadine

Professional

Posts: 18

Date of registration: Jan 13th 2008

Tuesday, January 29th 2008, 10:44am

Import from Excel

I had some difficulties to use the palo application.
I created 4 dimensions:
- Agence with element: nom (String)
- Produit with 4 elements: Type, groupeP, GroupeF, code (all String)
- Date
- DonnÃ©es with elements: QuantitÃ©, tonnage, (all numbers)
I create a cube with 4 dimensions (agence, produit, date, donnÃ©es).
I have an excel file with the following (

columns: agence, type, groupeP, groupeF, code, date, quantitÃ©, et tonnage.
How shall I import the data from my excel file (I already create the SDN, and run the ODBC import widzard via Palo but I cannot fill in the data into the cube)
Attached picture of my excel file.
Thanks in advance for your appreciated help.

My regards.

sadine has attached the following image:

Go to the top of the page

Pommie

Sage

Posts: 411

Date of registration: Feb 21st 2007

Location: Lytham UK

Occupation: OLAP consultant specialising in retail

Wednesday, January 30th 2008, 10:37pm

Hi Sadine you can make life easier for yourself by using the data import function. If you save you data in CSV format you can import them very easily

All you need to do is create a file with a PALO.SETDATA() formula. I think that the Palo 1.5 guide P 59 onwards will tell you all you need to know.

[Francais

Salut Sadine

Vous pourriez rendre la vie plus simple en vous en servant de la fonction "Data Import" sur le menu Palo. Si vous sauvez vos donnees en format CSV vous pourriez les importer tres simplement.

Il suffit de creer une fichier excel avec un formule PALO.SETDATA(). Je crois que la guide Palo 1.5 P59 et suite vous renseignera suffisament pour y arriver.]

Best wishes

John Hobson
The Planning Factory, Lytham, UK
www.planfact.co.uk

This post has been edited 3 times, last edit by "Pommie" (Jan 31st 2008, 11:17am)