SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Creating SSAS
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Villanuev
Constraint Violating Yak Guru

441 Posts

Posted - 02/21/2013 :  01:14:11  Show Profile  Reply with Quote
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

441 Posts

Posted - 02/21/2013 :  04:05:28  Show Profile  Reply with Quote
Could you please give me a site tutorial or samples as my reference regarding SSAS. thanks.
Go to Top of Page

bandi
Flowing Fount of Yak Knowledge

India
2217 Posts

Posted - 02/21/2013 :  04:49:31  Show Profile  Reply with Quote
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

Edited by - bandi on 02/21/2013 05:04:07
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/21/2013 :  22:47:47  Show Profile  Reply with Quote
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/

Go to Top of Page

Villanuev
Constraint Violating Yak Guru

441 Posts

Posted - 02/25/2013 :  00:17:04  Show Profile  Reply with Quote
Thanks Badi and VIsakh.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/25/2013 :  00:34:43  Show Profile  Reply with Quote
welcome

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

Go to Top of Page

Villanuev
Constraint Violating Yak Guru

441 Posts

Posted - 02/25/2013 :  00:35:20  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/25/2013 :  00:41:10  Show Profile  Reply with Quote
yep...you can set the logical primary key and then relationship

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

Go to Top of Page

Villanuev
Constraint Violating Yak Guru

441 Posts

Posted - 02/25/2013 :  00:49:30  Show Profile  Reply with Quote
THanks Visakh,

Another Query.
Once i finished the Cubes, How could i filter the data in cubes and i want to place a calculation.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52317 Posts

Posted - 02/25/2013 :  00:54:13  Show Profile  Reply with Quote
filter data in cubes where? where are you trying to view cube data?

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

Go to Top of Page

Alan Schofield
Starting Member

United Kingdom
23 Posts

Posted - 02/26/2013 :  21:39:01  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.09 seconds. Powered By: Snitz Forums 2000