sql server data warehouse: Do someone have the patience to explain?

I´m a beginner with SQL Datawarehousing.
I am working in Sweden for a pracitical training. I have to analys the existing DWH with OLAP, but I don´t succeed. I established the connection between the Database and the Analysis Manager with ODBC. But if i try to define a cube with the editor or the wizard I always get some error messages:

Processing Cube 'TV_Order' failed. No changes have been made to the database.

Data source provider error: ; Time:2004-07-29 10:46:23

Error(-2147221411): Process operation failed; Time:2004-07-29 10:46:23

I updated the OLAP component of MS SQL with SP3 but it didn´t solve my problem.

Could someone explain how i can define a cube... or what i have to consider if i want to??

My tables are TV_Order as fact table and tabStål as dimension table?
In the tabStål table is "Kod" the primary key. This primary key is the connection to the TV_Order table which has UniqTvTv as primary key.
Through the tabstål table i am able to create several dimensions, but i can´t process the dimension, just get the same error messages again.

Would really appreciate if somebody could examine the situation and give some advices.

Thanks Jan

what is the authentication mode to access your database?
if its the NT user, then, insure that analysis services run under a user
account and not the system account.

During design time, the current logged user account is used for the database
authentication, but during processing the Analysis Services server account
is used.
its why you have to use a user account and not a system account for the
MSOLAP service


"Indyyan" <Indyyan@discussions.microsoft.com> a écrit dans le message de
news:3800BFA3-E010-4131-9A74-EE066B107A76@microsoft.com...
[quoted text, click to view]
existing DWH with OLAP, but I don´t succeed. I established the connection
between the Database and the Analysis Manager with ODBC. But if i try to
define a cube with the editor or the wizard I always get some error
messages:
[quoted text, click to view]