oooooops

kirun — Fri, 03 May 2002 04:20:37 +0000

i am using SQL server 2000

Peter J. Boettcher — Wed, 01 May 2002 13:10:29 +0000

Ok, first off, I've only used OLAP on SQL Server 7 so any new features introduced in Analysis Services (OLAP for SQL Server 2000), I'm not really familiar with.

Your fact table should hold the FKs from the tables you're pulling data on. It should also contain a field for whatever you're totalling (sales for example).

The tables you're pulling data from are called the dimension tables.

I'm not familiar with predicting fields, threshold values, or trained data, maybe these were introduced with SQL Server 2000?

If you use the cube wizard to generate your cube then everything should basically explain itself. You should probably pickup a good OLAP book, its a pretty high-level subject which requires a bit of understanding (I'm still learning!)

Peter J. Boettcher — Tue, 30 Apr 2002 15:54:51 +0000

microsoft.public.sqlserver.olap is a newsgroup, if you don't have a news reader you can view it by going to groups.google.com and searching for it.

I'm not at work today, which is where I keep all my SQL resources and samples, I'll need them to help you out with OLAP.

Make sure you're using OLAP for the right reason, you should only use it if you're dealing with queries that return very large amounts of data that would benefit from optimization and caching.

for a quick look

kirun — Tue, 30 Apr 2002 04:35:13 +0000

your can also chek this out

http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=15361

for more search for the posts which are posted by me ( named with KIRUN )

thanks

kirun — Tue, 30 Apr 2002 04:15:25 +0000

thanks peter you are a ray of hope for me.. i was looking for a person for soo many days that could help me in this OLAP thing but i coukdnt find a single person on earth ... so how can i discuss my prblem with you .. if you can chat with me on msn or your meail address so i would better explain my problem... and yes one more things you have mention a group.. is this a mail list or what..

I m definately loooking forward for your reply

Peter J. Boettcher — Mon, 29 Apr 2002 13:24:36 +0000

I don't have a lot of experience with OLAP, but I'll help you if I can. A great resource is the microsoft.public.sqlserver.olap newsgroup (assuming you're using SQL Server).

Dimensions and cubes are so much fun!