Client Safety Options

[javier del valle]

In Excel I receive an error when I import (with Pivot
Table Services) or retrieve "pass through" data from a
cube . The error message is "Client Safety Options do not
allow pass through statements to be issued to the data
source."
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

 

[Steve]

The only potential resolution that I have found is here
(http://www-3.ibm.com/software/data/informix/pubs/library/notes/relnotes/relnotes-ocae4.html)
which includes the following information:

"If you install Microsoft Analysis Service Pack 3 on a computer on
which Office Connect is installed, you will receive an error when you
export a cube your worksheet or when you retrieve data. The error
message you is "Client Safety Options do not allow pass through
statements to be issued to the data source." To workaround this issue,
close Excel, find the MSRegSec.reg file (under Office Connect
installed directory), double-click the MSRegSec.reg file, restart
Excel and Office Connect, and export the cube."

So, it appears that the problem is that Analysis Services SP3 mucks up
the "Client Safety Options", and it appears that only IBM has figured
out how to fix it.
Even uninstalling Analysis Services didn't work for me; so it may
require a re-installation of Excel; unless someone can find the .reg
file that IBM created to resolve this issue... ( I haven't been able
to find the .reg file yet...)