Friday, August 7, 2015

SSAS Concepts

SSAS (SQL Server Analysis Services)OLAP (Online Analysis Processing)
UDM (Unified Defined Model)
BISM (BI Semantic Model)
Data Source
       Impersonation Information
Data Source View
         Named Query
         Named Calculation
          Logical Keys
          Add or Remove Tables
          Refresh
Dimension
          Hierarchy
          Attribute Relationships
         AttributeAllMemberName
         Unknown Member
         UnKnownMemberName
         AttributeHierarchyEnabled
         AttributeHierarchyVisible
         DefaultMember
         IsAggregatable (Property)
         Type (Property)
         Usage (Property)
         Name Column
         Value Column
         Key Column
         Order By
         OrderByAttribute
         FormatString
Cube
Measure Groups
       IgnoreUnrelatedDimensions
       ProcessingMode
Proactive Caching
Storage Modes
          MOLAP
          ROLAP
          HOLAP
Tabs:
    Cube Structure
    Dimension Usage
             Relationships
   Calculations
            Calculated Measure
            Named Set
  KPI
 Actions

    Custom Drill Through Action

 Partitions
 Aggregations
 Perspectives
 Translations
 Browser
Processing Options:
Deployment:  

      Transaction Deployment
Roles:
Assemblies


Scenarios:

Creation of cube top-down
Message group has zero dimensional overlap