SSAS FAQ Design FAQ

List of frequently asked questions (FAQ) and answers releated to designing SQL Server Analysis Services (SSAS) database, cubes, dimensions, partitions and other objects.
Filter     Display # 
# Article Title Author
1 How can I hide dimension attributes/hierarchy in one cube, but leave them visible in other Vidas Matelis
2 How do you create distinct count measure in the separate measure group from the same fact table Vidas Matelis
3 During processing I can see that SSAS read x records, but all measures in the cube return 0 Vidas Matelis
4 How in SSAS 2005 do you create what is used to be "Member Properties" in Analysis Services 2000 Vidas Matelis
5 How in Analysis Services do you order dimension attribute during design Vidas Matelis
6 Can you specify bucket start/end values for groupping attributes using DiscretizationMethod Vidas Matelis
7 What are recommended values for the InstanceSelection property in Analysis Services Vidas Matelis
8 When in Analysis Services should I consider splitting measure group into partitions Vidas Matelis
9 After processing dimension some of the attribute members are missing even I know they were read Vidas Matelis
10 How do you design KPI goal that is dimension dependant Vidas Matelis
11 I created Date/Time dimension, but Month level members are ordered alpabetically. Vidas Matelis
12 Do you put all measure groups into single cube or split them between cubes? furmangg
 
Strategy Companion