January 8, 2011 at 4:18 am
Hello All,
I want to creat a cube, i have goe through the business intelligence, but have still not understood when we slect the DSV data souse view, we select the tables for source data.Now, should these table be named as DimTableNM already then we process them here and call them as dimmensions?
that means that the snowflake schema is created in Database engine ? is this right?
January 8, 2011 at 7:08 pm
veena.jokhakar (1/8/2011)
I want to creat a cube, i have goe through the business intelligence, but have still not understood when we slect the DSV data souse view, we select the tables for source data.Now, should these table be named as DimTableNM already then we process them here and call them as dimmensions?that means that the snowflake schema is created in Database engine ? is this right?
This is a little confusing so I'm not sure if I got it right or not.
I assume we are talking about SSAS - is that correct?
In the affirmative case you can create cubes based on either Star or Snowflake schemas - as a side note, a snowflake schema is nothing but an extention of a classical Star one.
I would prefer to create the base schema by myself but SSAS has the ability to create a Star schema for you then you can modify it as needed.
Hope this helps.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.January 9, 2011 at 6:41 am
veena.jokhakar (1/8/2011)
Hello All,I want to creat a cube, i have goe through the business intelligence, but have still not understood when we slect the DSV data souse view, we select the tables for source data.Now, should these table be named as DimTableNM already then we process them here and call them as dimmensions?
that means that the snowflake schema is created in Database engine ? is this right?
When your source data has already tables called DimTableXX, it is probably already modeled as a star schema.
So, you have to create a data source view of all the tables you need and create the necessary relations to enforce your star schema. Then you will need to create the dimensions in SSAS based on those dimension table. In those dimensions you'll probably need to hierarchies and attribute relationships and do some proper formatting of the dimension.
After that, you can create your cube. The fact tables serve as a base for your measure groups and the dimensions you created earlier will serve as the base for cube dimensions.
If you didn't understand a word of what I've just written, you'll probably need to read a book about SSAS to get up to speed.
Recommended reading:
Smart BI solutions with SQL Server 2008
Kimball's Data Warehouse Toolkit
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 10, 2011 at 2:37 am
Thanks you so much.
I understand the process that is to be followed for Data source creation,then cube creation,then mining.I also understand what is strt schema and snow flake schema.
I am confused in following matters:
1) When and where the Tbles are names as DimTableXX? here in BI Studio or in database engine.
2) For tranformations like cleaning the data we shall be using SSIS right? so is that the place i have to name the tables?
3) where and when is the fact table created? at BI Studio or in database engine.
eg:1) I have data in Excel file-> import and export data 32-bit -> and get data in database-> withh then use BIstudio -> create Datasource View->Then follow all the further steps.
2) data in excel-> use SSIS for tranformation of data. Now i am new to this SSIS have to explre the steps yet.
Would we grateful if i am made this thing clear.
Thanks in advance...
January 10, 2011 at 2:46 am
1) Usually you do the design in the database itself, using Management Studio. So you create the tables there and of course, while you create them, you give them names.
2) Yup. SSIS. Although you can create tables through SSIS, I strongely advice you not to. Use SSMS for this.
3) Again, in the database itself using SSMS.
Recap: you create tables using SSMS, you populate them through SSIS and in SSAS you create your data source and your data source view.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 11, 2011 at 10:02 pm
Thank you so much for clear cut explanation.
January 11, 2011 at 11:38 pm
veena.jokhakar (1/11/2011)
Thank you so much for clear cut explanation.
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply