SSAS-Info.com website update information for April, 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 April.
News
- SSAS News - Apr 25, 2014 - Microsoft released CU1 for SQL Server 2014
Articles
- MDX - Free Video On Subselects In MDX
- MDX - Adventures in context with MDX
- Security - Analysis Services Security: Multiple Roles in Tabular vs. Multidimensional - Part 2
- Excel - MDX Cell Properties Supported By Excel
- Excel - Creating a Business Intelligence Solution with DB Business nd Excel 2013 BI Tools
- Reporting Services - Passing Parameters to MDX Shared Datasets in SSRS
- Data Mining - Explaining the Calculations of Probability and Importance for Complex Association Rules in SQL Server 2012 Analysis Services
- Drillthrough - BISM Drillthrough Capabilities
- AMO - Use Powershell to Get SSAS Partition Details
- AMO - SSIS - Creating new Partitions in SQL Server Analysis Services (SSAS) with XMLA and Analysis Services DDL
- AMO - SSIS: Creating Dynamic Data-driven SSAS Partitions
- Design - SQL Server Analysis Services Perspectives
- Design - Sort SSAS dimension attribute based on another attribute with example
- Management - OLAP Query Log and Subcube Vectors
- Management - SSAS DBA Tips and Tricks - How to change the default data folder location in SSAS
- Management - SSAS DBA Tips and Tricks - Where the data will be stored in MOLAP Storage mode
- Management - Tool - SSAS Role management easyROLES
- Management - Video - SSAS DBA Tips and Tricks - Flight Recorder in SSAS
- Management - Video - SSAS DBA Tips and Tricks - SSAS database backup using XMLA
- Management - Exposing the SSAS file system with the Metadata Sniffer
- Management - Video - SSAS DBA Tips and Tricks - How to delete Huge Cube Databases
- Management - How to Cluster SQL Server Analysis Services
- Management - Running MDX Studio against SQL 2012
- Management - 5 Tools for Understanding BISM Storage
- Management - SSAS : How to process multiple dimensions or measures from SSMS
- Management - SSAS Memory Configurations for Common Architectures
- Management - Tool for baselining MOLAP Processing
- Management - CREATE SESSION CUBE and disk usage
- Management - Analysis Services Tabular or Multidimensional? A performance comparison
- Management - How to Process Multiple Dimensions via BIDS and SSMS
- Tabular - Tool: xlDAX - an add-in for modern Excel
- Tabular - Automating PowerPivot Refresh operation from VBA
- Tabular - Implementing Column Security with #SSAS Tabular and #DAX
- Tabular - SQL SERVER - What is SSAS Tabular Data Model and Why to Use it
- Tabular - Baselining Tabular Model Processing with a trace file
- Tabular - PowerPoint and Excel: Perfect Partners for Dynamic Tables and Dashboards
- Tabular DAX - Dynamic Parent Child Security using DAX
- Tabular DAX - Linq To DAX
- Tabular DAX - Handling Different Granularities
- Tabular DAX - Using friendly week names in your date table
- Tabular DAX - Week Ending Date Calculation
- Tabular DAX - Creating a Dynamic, Parameterized Measure in DAX
- Tabular DAX - DAX: Always get the Latest date for a slicer
- Tabular DAX - Experiences and Tabular Tips
- Tabular DAX - ABC Classification
- Tabular DAX - Format the week number in your Power Pivot date table
- Tabular DAX - Check Empty Table Condition with DAX
- Tabular DAX - #DAX - Joining to a Slowly Changing Dimension
- Tabular DAX - DAX: Date Calculation Tables
- Tabular DAX - % of change since first month of the year using DAX and Power Pivot
- Tabular DAX - Turning "OR" Slicers Into "AND" Slicers
- Tabular DAX - DAX - Time Patterns
- Tabular DAX - CALCULATE(): More Examples and Reinforcement
- Tabular DAX - DAX: Calculating different rates on user defined inputs
Comments
- Comments - I want take one database back up not w
- Comments - Here is another article that explains ho
- Comments - Just for the benefit of those who are vi
- Comments - I am able to generate XMLA file. I want
- Comments - Thanks!
And thank you for rating the articles!