SSAS-Info.com website update information for January, 2012
Message from our sponsor
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:
- Real World Cube Design and Performance Tuning with Analysis Services (February 2012, London)
- Introduction To MDX (March 2012, London)
The following information was added to the SSAS-Info.com website during the month of January.
News
- SSAS News - Jan 16, 2012 - Microsoft released Cumulative Update package 3 (CU3) for SQL Server 2008 Service Pack 3
Software
- SSAS Tools - BISM Normalizer
Scripts
- SSAS Scripts - Script - SSAS Discover Current Processes
Articles
- MDX - Using TraceEvent for MDX Debugging
- MDX - Fun with MDX-Part 3: YTD and Prior YTD Calculations
- MDX - Fun with MDX: Part 2-Product Contribution Ratio
- Excel - Excel Writeback - Security and Leveraging the UPDATEABLE Cell Property
- Reporting Services - How To Default SSRS Parameter to Current Month using an SSAS Data Source
- Reporting Services - Using SSAS formatting in SSRS
- AMO - Processing data transactionally in AMO
- Performance Tuning - My Quick Guide to SSAS Query Tuning Part One
- Design - SSAS : Error with many-to-many dimension and level of granularity
- Design - Many-to-Many Relationships and Partition Slices
- Design - SSAS : Select Facts with Reference and Many2Many relationships
- Design - Analysis Services : Beware of unused dimensions "out of sight, out of mind"
- Design - [Denali CTP3] Analysis Services New Feature : Scalable String Storage
- Design - Analysis Services: What are the best practices for grouping measures ?
- Design - Near Real Time OLAP using SSAS Proactive Caching
- Management - Set the Slice on your SSAS Cube Partitions now!
- Management - Analysis Services Thread Pool Changes in SQL Server 2012
- Management - SSAS Locale Identifier Bug
- Management - Improving cube processing time
- Management - Additional SSAS Instance Installations in SQL Server 2012 (RC0)
- Management - Processing Past Data
- Management - Rename an Analysis Services Instance
- Management - Analysis Services Configuration Options
- Management - Doing a ProcessAdd in AMO
- Management - Rename an Analysis Services Instance
- Management - SSAS Crash Dump behavior
- Management - SQL Server 2008 and 2008 R2 Integration Services - Partition Processing Data Flow Destination
- Tabular - Publish a BISM Tabular Model Database Connection on SharePoint 2010
- Tabular - Working with relationships in PowerPivot and SSAS BISM Tabular
- Tabular - Building a BI Portal for the Tabular Model
- Tabular - Fact Tables with Different Granularities in #PowerPivot and #BISM #Tabular
- Tabular - Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012
- Tabular - BISM : Importing Text Files into Power Pivot
- Tabular DAX - QuickStart: Learn DAX Basics in 30 Minutes
- Tabular DAX - Aliasing Columns in DAX
- Tabular DAX - DAX - SUMMARIZE Statement
- Tabular DAX - DAX in the BI Tabular Model Whitepaper and Samples
- Tabular DAX - Sparse Snapshots in DAX / BISM Tabular
- Tabular DAX - The DAX DateAdd function and missing dates
- Tabular DAX - BISM : Competing and Continuous Store Sales using DAX
- Tabular DAX - From SQL to DAX: String Comparison
- Tabular DAX - String Comparison in #DAX
- Tabular DAX - DAX Query Plan, Part 1, Introduction
- Tabular DAX - Understanding Circular Dependencies in Tabular and PowerPivot
- Tabular DAX - PowerPivot: Calculate ratio to parent
- Tabular DAX - Use parameters in your #DAX queries
- Tabular DAX - Switching Subtotals On and Off Dynamically Using DAX in PowerPivot
Webcasts
- SSAS Webcasts - Video - SSAS database folder structure
Comments
- Comments - The link says the webcast is over, Is th
- Comments - Page not found on their website.
- Comments - Bad link - this article no longer exists
- Comments - Mate, if you were a real expert and anyw
- Comments - Thank you very much to share this approa
- Comments - HI plz check the below query... --PRE
- Comments - thanks for you comments.....
- Comments - Awesome
- Comments - thanks, its very helpful...............
- Comments - Hello, One of my customer run into th
- Comments - This worked perfectly for me.
And thank you for rating the articles!