Any database gurus
any database guru here... ???
I wanted to explore the rsik and assumption in a project based on OLAP,dataminming and data ware housing..
can n e buddy help me in this regard...
or point out some good data base forum so i can post my question there....
regards
"when one door of happiness closes
another opens;but often we look so long
at the closed door that we do not see
which one has opened for us "(Helen Keller)
Peter J. Boettcher posted this at 13:24 — 29th April 2002.
They have: 812 posts
Joined: Feb 2000
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!
PJ | Are we there yet?
pjboettcher.com
kirun posted this at 04:15 — 30th April 2002.
She has: 54 posts
Joined: Sep 2001
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
"when one door of happiness closes
another opens;but often we look so long
at the closed door that we do not see
which one has opened for us "(Helen Keller)
kirun posted this at 04:35 — 30th April 2002.
She has: 54 posts
Joined: Sep 2001
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 )
"when one door of happiness closes
another opens;but often we look so long
at the closed door that we do not see
which one has opened for us "(Helen Keller)
Peter J. Boettcher posted this at 15:54 — 30th April 2002.
They have: 812 posts
Joined: Feb 2000
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.
PJ | Are we there yet?
pjboettcher.com
Peter J. Boettcher posted this at 13:10 — 1st May 2002.
They have: 812 posts
Joined: Feb 2000
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!)
PJ | Are we there yet?
pjboettcher.com
kirun posted this at 04:20 — 3rd May 2002.
She has: 54 posts
Joined: Sep 2001
i am using SQL server 2000
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.