January 16, 2012 at 5:50 am
hi friends,
plzz share ur knowledge regarding my doubts..
1.do we have different kinds of cubes in ssas( today i came to know a word 'local cube' ), what does it means?
2. can we deploy our project into other dbs like oracle, db2?
3. difference of cube n data warehouse?
4.can we create a cube with only one table?(how)
5. am not getting the difference between exists n existing
January 17, 2012 at 9:35 am
PLZZ REPLY FOR THIS Q'S OR SUGGEST ME SOME ARTICLES RELATED TO THIS TOPICS..
THANX IN ADVANCE
January 17, 2012 at 10:01 am
hi friends,
plzz share ur knowledge regarding my doubts..
1.do we have different kinds of cubes in ssas( today i came to know a word 'local cube' ), what does it means?
2. can we deploy our project into other dbs like oracle, db2?
3. difference of cube n data warehouse?
4.can we create a cube with only one table?(how)
5. am not getting the difference between exists n existing
1. A local cube resides on a client system, often "built" (extracted might be a better term) using Excel. To an extent, these aren't heavily used. Back in the day (circa SQL 2000 SSAS) there was a utility (paid) that would help you build these, it's probably still around.
2. No, the SSAS project deploys only to MS SSAS. You can *read* your data from other systems, but not deploy to them. Note - many other BI front end tools can read/consume SSAS cubes.
3. Depending on the literature you read - a lot or very little. THis is a big topic, but generally, I would consider a cube a datamart, a sub component, front end representation of DW data.
4. Yes, you can. Should you, or do you want to, i would say "no". If you have a fact and dim tables now, simply create a view that joins the dims to the facts, bring that view in to your data source and use it as the soruce for your cube. This is NOT an optimal solutoon. You can't refresh dims seperately to facts. Partitoning would go away also. It's a bad idea, don't do it 🙂
5. you prob need to search out some blog entries, look for items from Mosha or Chris Webb.
s.
Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply