querying a cube

  • Thread starter Thread starter j.valle
  • Start date Start date
J

j.valle

I have problems importing data with QueryTables from Olap
data sources (Pivot Table Services). The error message
is "Client Safety Options do not allow pass through
statements to be issued to the data source.". All is fine
when querying directly to a cube file (*.cub) previously
created.
I receive the same error refreshing a Pivot Table whose
data source is file cube (*.cub)

These are my Excel Query data:

Connection:
PROVIDER=MSOLAP.2;
Data Source=;
Persist Security Info=False;
Connect Timeout=60;
Source_DSN="Provider=SQLOLEDB.1;Integrated
Security=SSPI;Initial Catalog=Sie00;Data Source=SRV-DB;";
CREATECUBE=CREATE CUBE SieDele ( DIMENSION [Origen], LEVEL
[Periodo] ,
DIMENSION [Centro], LEVEL [ALL] TYPE ALL, LEVEL [Empr],
LEVEL [ddd],
DIMENSION [Concepto], LEVEL [Concepto] ,
MEASURE [Importe] Function Sum Format '#.#' );
INSERTINTO=INSERT INTO SieDele(
Origen.[Periodo],
Centro.[Empr], Centro.[ddd],
Concepto.[Concepto],
Measures.[Importe] )
OPTIONS PASSTHROUGH
SELECT Periodo, Empr, Codigo, Concepto, Importe
FROM MisDatos

CommandText: (MDX)
SELECT NON EMPTY { [Centro].MEMBERS } ON ROWS,
NON EMPTY { [Concepto].MEMBERS } ON COLUMNS
FROM SieDele

And this is my Environment:
Windows XP SP1
Office XP SP2
Analysis services 2000 SP3

Can anybody help me?
Regards
Javier del Valle
 
Back
Top