Creating SSAS - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

Creating SSAS

Author

Topic

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-02-21 : 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

478 Posts

Posted - 2013-02-21 : 04:05:28

Could you please give me a site tutorial or samples as my reference regarding SSAS. thanks.

bandi
Master Smack Fu Yak Hacker

2242 Posts

Posted - 2013-02-21 : 04:49:31

I too don't have idea on SSAS..
Refer this link.. It may help you
http://msdn.microsoft.com/en-us/library/ms170208(v=sql.105).aspx

Detailed explanation is available here
http://www.accelebrate.com/sql_training/ssas_2008_tutorial.htm

http://www.ssas-info.com/analysis-services-articles
--
Chandu

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-21 : 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

478 Posts

Posted - 2013-02-25 : 00:17:04

Thanks Badi and VIsakh.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-25 : 00:34:43

welcome

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Villanuev
Constraint Violating Yak Guru

478 Posts

Posted - 2013-02-25 : 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

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-02-25 : 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

478 Posts

Posted - 2013-02-25 : 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

52326 Posts

Posted - 2013-02-25 : 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

23 Posts

Posted - 2013-02-26 : 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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources