all groups > sql server data warehouse > august 2004 >
You're in the

sql server data warehouse

group:

"Design Storage and Process the Cube" issue


"Design Storage and Process the Cube" issue Courtney Fay
8/26/2004 5:33:21 PM
sql server data warehouse: To anyone who can help,

I am reviewing the processes in the Analysis Manager, and I am going
through the sample exercises offered by SQL Server's Analysis Manager Help.

So far, every step has been successful, but now I am running into a
problem. If you have the Analysis Manager installed, you should be able to
follow this directory to see the instructions I am following.

C:\Program Files\Microsoft Analysis
Services\Help80\Tutorial\design_stor_proc.htm

When I attempt to process the design storage to set the aggregations, it
is failing. I get the following error for why the process has failed:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified;IM002; Time:8/26/2004 5:25:00 PM

If you understand why this is happening, I would appreciate any tips. If I
go to redo the process it does show that I already have aggregates for the
cube. Does that mean it actually worked, or am I correct in my assumption
that the error is pointing to a problem that I need to resolve. Thanks for
any information!

Courtney

RE: "Design Storage and Process the Cube" issue Udi
9/21/2004 5:11:03 AM
Hi

Did u manage 2 fix the problem?

Udi

[quoted text, click to view]
AddThis Social Bookmark Button