forum.venkateswarlu.net
      Register      Login
ssas

1 replies to this topic

Arvind Srivastava #1
Member
22 Points
 Posted on 25 Apr 2012 12:38 PM IST 1. Any body can provide the Life Cycle of SSAS project?
2. How many Maximum Fact and Dimension table should be in SSAS Project.
3. On which basis we are partitioning the table.
 
SSAS     886 views     Reply to this topic
Ram D #2
Member
20 Points
 Replied on 27 Apr 2012 06:28 AM IST 1.I think there is no such life cycle officially released by Microsoft. I think the below one may help you. This is simple SSAS life cycle.
Step1:Make sure the completeness and correctness of all the data feeds that are
coming into DW.
Step2:Understand the business and decide what are the Facts and Dimensions
Step3:Create DS, DSV, Facts and Dimensions and Cubes
Step4:Design Partitions and Aggregations if necessary
Step5:Build, deploy and Process
Step6:Define the Security

2.There will very less no of facts in a project, but you can have maximum 32 dimensions in SQL Server 2005 and 64 dimensions in SQL Server 2008.

3. It is depends on your business requirements. You can do the partitioning based on the following usually.
1.Monthly/Quarterly/Yearly
2.Based on separating the business entities. For instance, if you take Customers
entity, you can do the partitioning based on the country code. 
Reply to this topic