| Author |
 Topic  |
|
|
Villanuev
Constraint Violating Yak Guru
316 Posts |
 Posted - 02/21/2013 : 01:14:11
|
Hi Guys,
I'm a newbie in the area of SSAS.
just trying to make a sample SSAS project.
I have created the Data souces up to dimension but i have some question. please see below the detail. thanks.
Step 1 - Create Data Sources (MySample.ds)
Step 2 - Create Data Source Views (MySample.dsv)
• Just select all available object (available tables) then transfer or move in to included objects then click the next button
• Just provided the name then click the finish button to create new data source view.
• It display the MySample designer view
Questions:
1. I don’t have a foreign key, do I need to create new relationship?
2. The table with created relationship, is this the fact table or the measure group in dimension table?
Step 3 – Create Cubes
• Use the existing tables then click next
• Click the suggest button then click finish
Questions:
1. how and why I select tables that will be used as measure group?
2. What is measure group? Is this a table with numeric values?
3. Is this my Main master table?
4. It said that I will select one measure group, so what particular table should I
select in the measure group table? Is this the table with a numeric values?
|
|
|
Villanuev
Constraint Violating Yak Guru
316 Posts |
Posted - 02/21/2013 : 04:05:28
|
| Could you please give me a site tutorial or samples as my reference regarding SSAS. thanks. |
 |
|
|
bandi
Flowing Fount of Yak Knowledge
India
1719 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48119 Posts |
Posted - 02/21/2013 : 22:47:47
|
quote:
Originally posted by Villanuev
Hi Guys,
I'm a newbie in the area of SSAS.
just trying to make a sample SSAS project.
I have created the Data souces up to dimension but i have some question. please see below the detail. thanks.
Step 1 - Create Data Sources (MySample.ds)
Step 2 - Create Data Source Views (MySample.dsv)
• Just select all available object (available tables) then transfer or move in to included objects then click the next button
• Just provided the name then click the finish button to create new data source view.
• It display the MySample designer view
Questions:
1. I don’t have a foreign key, do I need to create new relationship?
2. The table with created relationship, is this the fact table or the measure group in dimension table?
Step 3 – Create Cubes
• Use the existing tables then click next
• Click the suggest button then click finish
Questions:
1. how and why I select tables that will be used as measure group?
2. What is measure group? Is this a table with numeric values?
3. Is this my Main master table?
4. It said that I will select one measure group, so what particular table should I
select in the measure group table? Is this the table with a numeric values?
1.You need to create relationships within SSAS to indicate how fact tables relate to dimensions
2.The table with relationship would mostly be fact table in a typical start schema with relationships to dimension tables
3. While you build the cube after you select tables by virtue of relationships it will try to identify tables with numeric values and show them as measure groups. you have option of selecting actual ones and deselect others (as it might even choose a few dimensions with count of id values added as a measure. Once you finsih identifying correct ones you can click nest and it will show you rest of tables as dimensions
4. measure groups are actual numeric values that you use for analysis in cube. It consists of numeric fields within your fact table.
5. Yep it is
6. same as 4 above
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Villanuev
Constraint Violating Yak Guru
316 Posts |
Posted - 02/25/2013 : 00:17:04
|
| Thanks Badi and VIsakh. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48119 Posts |
Posted - 02/25/2013 : 00:34:43
|
welcome
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Villanuev
Constraint Violating Yak Guru
316 Posts |
Posted - 02/25/2013 : 00:35:20
|
Hi Visakh,
I dont have the logial primary key setup in my tables. I have 6 tables that have the Field ESN as my Primary key to relate from other table. Could I create a relationship or setup a ligcal primary key through Data Source View New Relationship.
1.Right Click the table in the Data Source Desgin view.
2.Click the New Relatinship
3.Specify relationship
4.Source(Foreign Key) table (Destination(Primary Key) table
OR
1. Right Click table
2. Point to field that will be use and click set logical primary key |
Edited by - Villanuev on 02/25/2013 00:37:12 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48119 Posts |
Posted - 02/25/2013 : 00:41:10
|
yep...you can set the logical primary key and then relationship
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Villanuev
Constraint Violating Yak Guru
316 Posts |
Posted - 02/25/2013 : 00:49:30
|
THanks Visakh,
Another Query.
Once i finished the Cubes, How could i filter the data in cubes and i want to place a calculation. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
48119 Posts |
Posted - 02/25/2013 : 00:54:13
|
filter data in cubes where? where are you trying to view cube data?
------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
|
|
|
|
Alan Schofield
Starting Member
United Kingdom
23 Posts |
Posted - 02/26/2013 : 21:39:01
|
quote:
Originally posted by Villanuev
THanks Visakh,
Another Query.
Once i finished the Cubes, How could i filter the data in cubes and i want to place a calculation.
The OLAP viewer you decide to use will be able to filter your cube, SQL Server Management Studio for example, or even Excel can open OLAP cubes.
As far a creating calculations, you should look at creating a calculated member (look at the 'calculations' tab in the cube designer), that way it will be baked into the cube and available to whichever front end you view the cube through. |
Edited by - Alan Schofield on 02/26/2013 21:39:33 |
|
|
| |
Topic |
|
Creating SSAS
