SSAS-Info.com website update information for July, 2012
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:
- SQL Server Analysis Services 2012 Tabular Workshop, September 2012, Dublin
The following information was added to the SSAS-Info.com website during the month of July.
News
- SSAS News - July 26, 2012 Microsoft released Service Pack 2 (SP2) for SQL Server 2008 R2
- SSAS News - July 25, 2012 - New book released "Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model"
- SSAS News - July 17, 2012 - Microsoft released Cumulative update package 6 (CU6) for SQL Server 2008 (SP3)
Software
- SSAS Tools - DAX Studio (Free)
- SSAS Tools - SSAS Compare - Redgate (commercial)
Articles
- Uncategorized - Analysis Services Tabular books #ssas #tabular
- MDX - Formatting Calculated Members
- MDX - Arbitrary Shapes in AS 2005
- Security - Securing a Dimension with Members Having the Same Name
- Excel - What's New in Office 2013 BI - (Part 1 - Personal BI with Excel)
- Excel - Running Excel 2013 in a separate instance #excel #powerpivot
- Excel - Excel 2013 and BISM Multidimensional
- Excel - [Office 2013] New OLAP Tools Part 1: Calculated Measure
- Excel - What Are The Big Changes In Excel 2013 For BI?
- AMO - Fetch cube data using .Net code
- Design - Color Expressions In SSAS
- Design - Building a data mart to analyse web log traffic
- Design - Modeling Dimensions with History Tracked, Generic Attributes
- Design - Thoughts Around "Aggregate Fact Tables"
- Design - Duplicate Attribute Keys in SSAS
- Management - SSAS: All Possible Scenarios of Changing SSAS Data Folder
- Management - Cleaning up Hanging Traces with PowerShell
- Management - Installing the BI features of SharePoint 2013 Preview
- Management - OLE DB error: OLE DB or ODBC error: Query timeout expired; HYT00
- Management - Automate creation of cube partitions
- Management - SSAS Deployment essentials
- Management - SSAS Crash Dump behavior
- Management - Analysis Services Stops Accepting New Connections -Processing commit locks hurt
- Management - Comparing DirectQuery and ROLAP for real-time access
- Management - How to configure HTTP access to the TFS Analysis Services Cube
- Management - SSAS Multithreaded sync with Windows 2008 R2
- Management - Introducing DAX Studio
- Management - Non Materialized Reference Dimensions, ProcessUpdate and Indexes
- Management - Process Cube objects using AMO
- Performance Point - Deploying PerformancePoint Content to another SharePoint Site
- Performance Point - Time Intelligence in PerformancePoint Services
- Tabular - Creating lookup tables in PowerPivot using SQL queries
- Tabular - Creating a Cycle Plot PivotChart
- Tabular - Video - Excel PowerPivot SQL 2012 vs. Excel 2013 Performance Demo
- Tabular - Merging data in PowerPivot
- Tabular - Going All In with Excel 2013
- Tabular - Consuming OData feeds from Excel Services 2013 in PowerPivot
- Tabular - Tiered Commissions, Income Taxes, and other "Tiered Rate" Calculations in PowerPivot
- Tabular - Enabling Tableau to read PowerPivot model updates
- Tabular - Building a Simple BI Solution in Excel 2013, Part 2
- Tabular - Building a Simple BI Solution in Excel 2013, Part 1
- Tabular - Supporting Multiple PowerPivot Versions
- Tabular - Date Filtering in Excel from your Analysis Services Tabular Model
- Tabular - "Mark as Date Table": When not to use it
- Tabular - Dynamic TopN Reports Using PowerPivot V2!
- Tabular - Woops I ran out of memory while processing my tabular model
- Tabular - The Tabular Model in SQL Server 2012
- Tabular - Excel Opens Up Limitless Possibilities for BI
- Tabular - PowerPivot for Excel as an XML/A Server
- Tabular DAX - Video - DAX in Action!
- Tabular DAX - Implementing a Dynamic Top X via slicers in Excel 2013 using DAX queries and Excel Macros
- Tabular DAX - DAX II - Extending the use of Evaluate
- Tabular DAX - DAX Querying Part I
- Tabular DAX - Create a Dynamic BI Distribution Chart in PowerPivot using DAX
- Tabular DAX - PowerPivot Top N Reports Using Excel Cube Formulas
Webcasts
- SSAS Webcasts - Video - Data Mining 2012 with Microsoft Excel 2010 and PowerPivot
- SSAS Webcasts - Video - Building the Perfect BI Semantic Tabular Models for Power View
- SSAS Webcasts - Video - Enriching Your BI Semantic Tabular Models with DAX
- SSAS Webcasts - Video - Developing and Managing a BI Semantic Model in Microsoft SQL Server 2012 Analysis Services
- SSAS Webcasts - Video - Building Self-Service BI Applications Using PowerPivot
- SSAS Webcasts - Video - Many-to-Many Relationships in BISM Tabular
- SSAS Webcasts - Video - BISM: Multidimensional vs. Tabular
- SSAS Webcasts - Video - Deploying and Managing a PowerPivot for SharePoint Infrastructure Using Microsoft SQL Server 2012
- SSAS Webcasts - Video - Optimizing Your BI Semantic Model for Performance and Scale
- SSAS Webcasts - SharePoint 2013 changes and features in PerformancePoint services
Comments
- Comments - Can any body send me screen shots of how
- Comments - Thanks dude :O)
And thank you for rating the articles!