SSAS-Info.com website update information for March, 2014
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 Analysis Services 2012 Tabular Models with Chris Webb, 9-10 June 2014, London
- Advanced DAX Workshop with Marco Russo, 11-13 June 2014, London
- Introduction to MDX with Chris Webb, 13-15 October 2014, London
The following information was added to the SSAS-Info.com website during the month of March.
News
- SSAS News - Mar 19, 2014 - Microsoft released CU9 for SQL Server 2012 SP1
Articles
- MDX - How to implement OR condition in MDX
- MDX - Dynamic Dimensions
- MDX - SQL Server Analysis Services Top N Plus All Other Rollup
- MDX - MDX: Scope and Precedence for Calculated Members and Sets
- MDX - Arguments of the nonempty function
- MDX - Do You Know Why Your MDX Query Is Slow?
- Security - Analysis Services Security: Multiple Roles in Tabular vs. Multidimensional
- Security - SSAS (SQL Server Analysis Services) - Securing Measures in Measure Group for specific Roles
- Excel - Excel - User Input for Custom MDX query using VBA and Pivots
- Data Mining - SQL Server 2012 Analysis Services Association Rules Data Mining Example
- AMO - How to build your own SSAS Resource Governor with PowerShell
- AMO - SSAS - Listing Active Queries with PowerShell
- Design - SSAS - Using the SUM Function within a Measure Group to display a Distinct Count with SSAS (SQL Server Analysis Services)
- Design - Errors in the OLAP Storage Engine for a large dimension
- Management - Tabular: Cant see Databases in Management Studio
- Management - SSAS Server Properties: AllowedBrowsingFolders
- Management - SQL Server Analysis Services ProcessAdd for a Partition
- Management - Hope for running SSAS in the cloud with "Big Compute"!
- Management - Displaying last cube processed time in SSAS
- Management - SSAS - Out of memory exception during processing
- Tabular - Creating burndown charts for Project using Power Pivot and Power Query
- Tabular - SSAS Tabular: Internal Physical Files
- Tabular - Working with Data Models Created Using SQL Server 2008 R2 Power Pivot for Office Excel 2010 in Power BI
- Tabular - SSAS Tabular: Transactional Deployment
- Tabular - Automatically create data dictionary for your Power Pivot model
- Tabular - LASTDATE vs. MAX? CALCULATETABLE vs. FILTER? It depends! #dax #powerpivot #tabular
- Tabular - Open Data Mashup: UK National Census 2011
- Tabular - SSAS Tabular: Calculating the actual compression rate
- Tabular DAX - Manipulating a date column (aka remember time intelligence functions)
- Tabular DAX - DAX - Statistical Patterns
- Tabular DAX - Becoming one with CALCULATE()
- Tabular DAX - Dynamic Segmentation
- Tabular DAX - TopN as viewed by DAX Table Queries
- Tabular DAX - Static Segmentation
Webcasts
- SSAS Webcasts - Video - Power Pivot and Complex DAX Expressions
- SSAS Webcasts - Video - The 20 Minute Tabular Model
- SSAS Webcasts - Video - Data Lineage using SSIS, SSAS and Power Pivot
Comments
- Comments - Great to see support Google GeoChart is
- Comments - great tool, but no where find how to ret
And thank you for rating the articles!