OLAP CUBE: Do someone have the patience to explain

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

OLAP CUBE: Do someone have the patience to explain

Author

Topic

Indyyan
Starting Member

31 Posts

Posted - 2004-07-29 : 05:12:21

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

NicoNel2000
Starting Member

12 Posts

Posted - 2004-08-05 : 11:02:34

I got to dash (time to go home...check your news....flooding here in Cape Town).

For now, just make sure you fact and dimension tables does contain data? Know it's a stupid Q, but just that turns out to be the problem sometimes.

cya

Now where's rent a boat.....

ditch
Master Smack Fu Yak Hacker

1466 Posts

Posted - 2004-08-05 : 11:09:20

Hi Nico,
Just some freindly advice One Capetownian to another - Live close to work.

Duane.

Indyyan
Starting Member

31 Posts

Posted - 2004-08-09 : 10:22:06

Thanks for the "help". If I look in the SQL Database both tables contain data.

Is it possible that the relation field between fact and dimension table should be something else than datatype varchar.

Would really appreciate help, in three days i have to present my results...

Thanks Jan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources