SSAS Articles 
Design Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling
Design Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling
| Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling |
| Written by Ajit Singh |
| Sunday, 20 July 2008 01:33 |
|
There are many business analytical needs whose data is in the form of “State Workflow”. A state workflow consists of a set of states. There are a valid number of “State Transitions”, i.e. changing of one state to another. The state transitions happen by some event. There can be a valid number of events responsible for state transition. The typical business problem that conforms to above situation is “Sales Pipeline” analysis. The typical queries that need to be resolved are: Read more... |
Latest Author Articles
- Fact table design for "State Workflow Analysis": Analysis Services Dimensional modeling
- NextAnalytics and MDX : Part 1 - Swap Cells with Row Labels
- Aggregate(), Sum() functions using calculated members does not work in Analysis Services 2005 SP2 (9.00.3042.00 version) but works in Analysis Services 2000 SP4
- Identifying intra-dimensional members relationship and reducing cube sparsity in Analysis Services 2005 SP2 : Cube design tip
- Code : utility code for converting cellset to a data table
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
