How can I load multiple dimensions (according to a star schema)?

Mon, 26 Nov 2012 23:26:04 GMT

Hi!

I have just followed the QlikView Tutorial.

With the following script, I get the message:

ErrorSource: (null), ErrorMsg: (null)

Especialidad:

SQL SELECT FL_ESPECIALIDAD, NB_ESPECIALIDAD

FROM OKW.C_ESPECIALIDAD

Can anyone explain me how I can solve this problem? Thanks in advance for your help.

Cordially,

--- Miguel-Angel

----- script ---------

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='$#,##0.00;-$#,##0.00';
SET TimeFormat='hh:mm:ss TT';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';
SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic';
SET DayNames='lun;mar;mié;jue;vie;sáb;dom';

OLEDB CONNECT TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=super;Initial Catalog=OKW;Data Source=192.168.137.115;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=WDESARROLLO03;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is cRGTaZVOQLZEHXC);

Plaza:
SQL SELECT "CL_PLAZA" AS "FL_PLAZA",
"CL_ESTADO" AS "FL_ESTADO",
"CL_PAIS" AS "FL_PAIS",
"NB_PLAZA",
"NB_DELEGACION",
"NB_COLONIA"
FROM OKW.C_PLAZA;

Especialidad:
SQL SELECT FL_ESPECIALIDAD, NB_ESPECIALIDAD
FROM OWK.C_ESPECIALIDAD;

Re: How can I load multiple dimensions (according to a star schema)?

Tue, 27 Nov 2012 00:04:14 GMT

Hi!

I changed a piece of the script as follows:

Plaza:

LOAD CL_PLAZA AS FL_PLAZA, CL_ESTADO AS FL_ESTADO, CL_PAIS AS FL_PAIS, NB_PLAZA, NB_COLONIA, NB_DELEGACION;
SQL SELECT "CL_PLAZA",
           "CL_ESTADO",
           "CL_PAIS",
           "NB_PLAZA",
           "NB_COLONIA",
           "NB_DELEGACION"
        FROM OKW.OKW."C_PLAZA";

Especialidad:
LOAD FL_ESPECIALIDAD, NB_ESPECIALIDAD;
SQL SELECT "FL_ESPECIALIDAD",
                       "NB_ESPECIALIDAD"
        FROM OKW.OKW."C_ESPECIALIDAD";

Now, it works !

Cordially,

--- Miguel-Angel

topic How can I load multiple dimensions (according to a star schema)? in QlikView

How can I load multiple dimensions (according to a star schema)?

Re: How can I load multiple dimensions (according to a star schema)?