SSAS

SQL Server Analysis Services

• Creating SSAS Cube
• Accessing SSAS Cube Via. Excel 
• Accessing SSAS Cube Via. SSMS
• Creating SSAS Tabular Model

MDX

• MDX
• Filters in MDX
• Filter based on used dimension in mdx
• Getting Top N values using RANK function
• Visual Total in MDX
• Parallel Period in MDX
• Getting MTD Values in MDX
• Getting YTD values in MDX
• The restrictions imposed by the CONSTRAINED flag in the STRTOSET function were violated
• Getting List of Top N Products for each year using MDX
• WTD in MDX  
• Generating Comma Delimited String In MDX 
• Hierarchize Function in MDX 
• Changing Date Format In MDX 
• RANK function in MDX
• Truncating Timestamp in MDX

 

 

 

 

 

Security