OLAP CUBE ERROR

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dcozzi - 22 Mar 2006 17:01 GMT

When trying to crate an OLAP CUBE from an access database in excel, i get the
following error. Does anyone know how to fix this?

CLIENT SAFETY OPTIONS DO NOT ALLOW PAS THROUGH STATMENTS TO BE ISSUES TO THE
DATA SOURCE

Reply to this Message

Michel Walsh - 22 Mar 2006 23:44 GMT

Hi,

Since Jet does not make cube, I assume your back end is MS SQL Server. It
is quite reasonable that the dba do not allow pass-through query (else,
imagine someone dropping all the tables ! something doable with
pass-through queries). If you have MS SQL Server 2000 or 2005, on the other
hand, you can ask that someone build code that returns your cube, on MS SQL
Server, and then, ask to be allowed to run that code (visible as a view or
as a function) from Access. It sounds to be a security problem, more than a
technical problem.

Hoping it may help,
Vanderghast, Access MVP

> When trying to crate an OLAP CUBE from an access database in excel, i get
> the
[quoted text clipped - 3 lines]
> THE
> DATA SOURCE

Reply to this Message

dcozzi - 23 Mar 2006 21:49 GMT

Mike,

Thanks for your help. The access database was built and designed by me in
order to organize a lot of data in one place. It resides on my C: drive. I
was able to query it using a cube before, but for some reason it will not let
me anymore.

Any ideas?

> Hi,
>
[quoted text clipped - 17 lines]
> > THE
> > DATA SOURCE

Reply to this Message

Michel Walsh - 23 Mar 2006 22:30 GMT

Hi,

Even if the Access application resides locally on your drive, it is more
that probable that is has "linked tables" toward some (unidentified) MS SQL
Server Database. So, for an illustration, Excel has a pipe connected to
Access which has a pipe connected to MS SQL Server. But something happened
to MS SQL Server since now, it does not allow Access to issue pass-through
query to it, so Access reports to Excel the error MS SQL Server reports to
Access. It does not look that Access refuses to make pass-through query
toward MS SQL Server. So I doubt Access is the problem, in that specific
case. Can you identify the MS SQL Server that really produces the CUBE on
the behalf of Access?

Vanderghast, Access MVP

> Mike,
>
[quoted text clipped - 34 lines]
>> > THE
>> > DATA SOURCE

Reply to this Message