SSAS-Info.com website update information for January, 2013
PASS Business Analytics Conference - April 10-12, 2013 in Chicago, IL
If you're a business analyst, data scientist, architect, or BA/BI practitioner, you should consider attending PASS Business Analytics Conference in Chicago IL, USA on April 10-12, 2013.
SSAS-Info.com and PowerPivot-Info.com website users can use code BAC187BL to get 150$ discount of the current conference rate (discount is only for those who haven't already registered - it can not be used retroactively). More info about this conference can be found here.
The following information was added to the SSAS-Info.com website during the month of January.
News
- SSAS News - PASS Business Analytics conference - Chicago, IL - April 10-12, 2013
- SSAS News - Jan 24, 2013 Microsoft released Cumulative Update Package 2 (CU2) for SQL Server 2012 SP1
Articles
- MDX - Validating MDX Queries Without Running Them
- MDX - Nonlinear Regression MDX
- MDX - Creating and using MDX Stored Procedures - ADOMD.NET Server Programming
- MDX - Using MDX to Calculate Both Values and Percentages for Analysis Services
- MDX - Create a custom Calculation (Calculated Member) using Analysis Services 2012 Cube Designer
- Security - SSAS Impersonation Smackdown - Specific Windows Acct vs Service Account
- Excel - Pivot Filtering with Cell Selection and VBA
- AMO - PowerShell Script To List Elevated Permissions in an Analysis Services Database
- AMO - Hiding SSAS Attributes with PowerShell
- Design - Gotchas With Referenced Dimensions
- Design - SSAS: One giant cube or many small ones?
- Design - Hide a specific attribute hierarchy in role playing dimension - SSAS multidimensional
- Design - OLAP Rigidity wins against Tabular?
- Design - DAXMD and DefaultMembers
- Management - Changing database ID in Analysis Services
- Performance Point - SharePoint: MDX Expressions for PerformancePoint Filters
- Tabular - Modeling Viral and Marketing Growth, Part 3 of 3
- Tabular - Building Relative Date Reports in PowerPivot
- Tabular - Row Selection Using Slicers in PowerPivot - Part 2
- Tabular - Linkback Tables in PowerPivot for Excel 2013
- Tabular - Row Selection Using Slicers in PowerPivot - Part 1
- Tabular - Leveraging DAX query tables for staging Data Transformations
- Tabular - Managing Connections In Power Pivot
- Tabular - PowerPivot Compatibility across versions
- Tabular - Hardware Sizing a Tabular Solution (SQL Server Analysis Services)
- Tabular - 1 hour timeout for data refreshes in Powerpivot for Sharepoint
- Tabular - 1 hour timeout for data imports in Powerpivot for Excel
- Tabular - Parameterising PowerPivot Connection Strings in Excel 2013
- Tabular - What is new for the Tabular model in SQL Server 2012 SP1 and compatibility level
- Tabular DAX - Import Data from Tabular Model in Excel Using a DAX Query
- Tabular DAX - Currency Conversion in Tabular Model Using DAX
- Tabular DAX - Dynamic ABC Analysis in PowerPivot using DAX
- Tabular DAX - Modeling Viral and Marketing Growth, Part Two
- Tabular DAX - Modeling Viral Growth and Marketing in PowerPivot
- Tabular DAX - Grouping by an Aggregation in DAX
- Tabular DAX - A Different Approach To Last-Ever Non-Empty in DAX
- Tabular DAX - New Customers Per Day Generalized to "New Customers per Month," etc.
- Tabular DAX - Group Multiple Rows to Single Delimited Row in PowerPivot
- Tabular DAX - PowerPivot Use Case: Getting the active products between a date range using DAX
- Tabular DAX - Excel 2013, Power View, top 10, "long tail" and how DAX helps
- Tabular DAX - IF ISCROSSFILTERED performs better than IF HASONEVALUE
- Tabular DAX - New Customers per Day - Technique by David Hager
Webcasts
- SSAS Webcasts - Interview with Grant Paisley - SQL Down Under Show
Comments
- Comments - Great, but were are the samples ??? !!!
- Comments - I am not a programmer but I have this SQ
- Comments - Thanks for the tip. OLAP HeartBeat has
- Comments - Correct syntax is create member curr
- Comments - Is it needed to set the slices for MOLAP
- Comments - Is it possible to do an overview of how
- Comments - Nice explanation
SSAS Companies
- Consultants - InfoToad Consulting – Business Intelligence Consultants, CA, USA
And thank you for rating the articles!