OLAP CUBE ERROR

G

Guest

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
 
G

Guest

Thats what i thought. I created the data base so i can change anything that
needs to be changed. Any suggestions?
 
G

Guest

The data base was created by me and currently resides on my c: drive. It was
created in access 2003 and i am trying to query it from excel 2003.
 
G

Guest

These are my steps.

DATA: Import external data: new database query:ms database query:i then
select the database which is on my c: drive, choose my columns, go to finish
the query, and i can select on of the 3.

1. Return data to MS office Excel.
2. View data or edit query in MS Query
3. Create an OLAP Cube from this query.

I choose 3, and follow the directions. It goes thru then i get the error
message i described earlier.

Im not srue what you mean when you say you are unaware of a "CUBE FUNCTION"
in excel. I think its classified as a query.

Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel file with olap cube gets corrupted 1
How to Import/Export an OLAP Data Cube 0
OLAP Pivot Table 1
ODC properties: OLAP Server Formatting 0
Olap cube as a Data Source 1
Summarise data by average in OLAP cube 2
Excel Error while connecting to OLAP cube 0
Changing Data Source on Multiple Pivot Tables at once 1

Top