SSAS-Info.com website update information for September, 2013
Message from our sponsors
Get SSAS and MDX training from experts at Technitrain. These courses are taught by top consultants who have a wealth of hands-on experience to share and who can answer all of your difficult questions. You'll acquire the practical skills you need to do your job as well as learn the tips and tricks that only the experts know.
Next available courses:
- Introduction to MDX - November 2013, London
- Real World Cube Design and Performance Tuning with Analysis Services, with Chris Webb - March 2014, London
The following information was added to the SSAS-Info.com website during the month of September.
News
- SSAS News - Sep 17, 2013 - Microsoft released CU6 for SQL Server 2012 SP1
Articles
- MDX - Problems With Calculated Members And Level Names
- MDX - SQL Server Analysis Services (SSAS) 2012 Top and Bottom Functions
- Excel - Excel - Using a Custom MDX Query in Excel Table
- Reporting Services - MDX+SSRS #31- Query Designer in SSRS only allows the Measures dimension in the first axis
- Reporting Services - SSRS-Creating reports using Custom MDX or DAX to query SQL Server Analysis Services (SSAS) Cube both OLAP and Tabular (Not using the Wizard)
- AMO - SSIS 2012 - Inserting data into a SQL Server Table from an MDX Query
- AMO - SSIS - Process Cube with XMLA and Analysis Services DDL
- AMO - Using Powershell to view Partition Slice Information in Excel
- AMO - PowerShell: Checking For Large SSAS String-Store Files
- AMO - Turn On Lazy Aggregations Through PowerShell
- AMO - Processing SSAS Databases Using PowerShell
- Performance Tuning - SQL Server Analysis Services Query Response Comparison by Storage Mode
- Design - Custom Attribute Names in Role Playing Dimensions for SSAS
- Design - Different options for creating a distinct count measure in SSAS
- Connectivity - Configuring Web server for accessing Cube using Excel
- Management - Analysis Services and Excel Tips and Tricks
- Management - you may obtain a .dstore related file system error when processing TFS cube
- Management - Unknown Unknowns: Analysis Services Failing to Start
- Management - SSAS - String Storage Calculator
- Management - Disk Space Analyser for Analysis Services (MOLAP)
- Performance Point - Integrating Power View with PerformancePoint
- Tabular - "Normalize" Your Measures for Fun and Profit!
- Tabular - Integrating MongoDB and Open Source Data Stores with Power Pivot
- Tabular - Power BI Preview Review Part 2: Q and A
- Tabular - Target well-formed Data Models when using Power Query
- Tabular - Power Query data loading example
- Tabular - Power BI Preview Review
- Tabular - Your first table choice in Power Pivot will haunt you - or how to set the default table name
- Tabular - Tabular: .Net Provider supported by Tabular Mode
- Tabular - Video - Choosing Between Tabular and Multidimensional Data Models
- Tabular - Tabular Basket Analysis: Simple Data Mining in Tabular databases
- Tabular DAX - DAX Statistical Functions
- Tabular DAX - Testing a DAX measure using Excel functionality - XIRR example
- Tabular DAX - DAX context propagation, inactive relationships and calculated columns
- Tabular DAX - USERELATIONSHIP in Calculated Columns
- Tabular DAX - Ranks and Exceptions that "Bubble Up" to Subtotals
- Tabular DAX - Handling Wrong or Missing Dates in Tabular
- Tabular DAX - Calculating First and Second Year of Sales by Customer in #dax #powerpivot #ssas #tabular
- Tabular DAX - Yearly Customer Historical Sales in DAX
Comments
- Comments - I want to calculate max sales for each d
- Comments - Very helpful for beginners to master in
- Comments - Important announcement from PowerPanels
- Comments - the first tuple of a set is not the firs
- Comments - thanks for your work
And thank you for rating the articles!