Report Portal

SSAS-Info.com website update information for November, 2011

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:


Contest

Would you like to master PowerPivot?
We are giving away one complimentary registration to online PowerPivot workshop that will be held December 19-20th, 2011. To enter simply send an e-mail to This email address is being protected from spambots. You need JavaScript enabled to view it. with subject line "Online PowerPivot workshop draw" before December 6th, 2011.


 

The following information was added to the SSAS-Info.com website during the month of November.

News

- SSAS News - Nov 17, 2011 - Microsoft released SQL Server 2012 Release Candidate 0 (RC0)
 

Software

- SSAS Tools - DAX Editor for SQL Server (free)
 

Scripts

- SSAS Scripts - SSAS Dimension Process Update
 

Articles

- MDX - SSAS: Multiple SQL Queries in ROLAP Mode
- MDX - Creating Named Sets In Your Cube
- MDX - MDX:Handling division by zero errors
- MDX - Average Monthly calculations
- MDX - Ten MDX Calculations For Your Cube
- MDX - MDX: Nonempty v/s NonEmpty
- MDX - An MDX Outlier Solution
- MDX - Avoid Pitfalls of Fact Data Prefetching
- MDX - MDX - Counting Consecutive Days
- Reporting Services - Calculated measures and query scoped members in SSRS
- AMO - Managing SSAS Named Sets with Master Data Services Collections
- Design - How To: Many-To-Many Currency Conversions in Microsoft's SQL Server Analysis Services
- Design - Date Order
- Design - SSAS - Important Attribute Properties
- Design - SSAS: One Database, many Cubes Vs. One Database per Cube
- Design - Alternate Ordering of Attributes in SSAS
- Design - SSAS : Selecting facts with reference dimension
- Design - SSAS: Selecting facts with different dimensionality
- Management - SSAS Cluster: Issue with Mount Points while Performing Administrative Tasks
- Management - Handling NULL in dimensions and measures
- Management - Process Modeling - Is this a fact or a dimension?
- Management - Investigating the Resource Usage Profiler Event
- Management - An Informal Compendium of SSAS Errors
- Management - Use a DNS alias for SSAS 2005/2008 instance
- Performance Point - How to configure cascading filters in Dashboard Designer (SharePoint 2010 SP1)
- Performance Point - Can PerformancePoint have interactive features?
- Tabular - #DAX Query Plan in SQL Server 2012 #Tabular
- Tabular DAX - Stock levels as delta rows in DAX / BISM Tabular
- Tabular DAX - Solving the Events-In-Progress Problem in DAX V2.0
- Tabular DAX - Converting MDX to DAX - First Steps
 

Webcasts

- SSAS Webcasts - Video - Many-to-Many Relationships in DAX
- SSAS Webcasts - Video - Writeback-Here Comes the Sun
- SSAS Webcasts - Video - MDX and DAX-compare and contrast
- SSAS Webcasts - Video - Basic BISM
 

Comments

- Comments - informative..thanks for sharing. Karan
- Comments - OKAY! got it not everyone who claims to
- Comments - I'm here again. Now the link is work, b
- Comments - Hi Chris, I have a different situatio
- Comments - Drop the analysis service database and p
- Comments - veri nice, but doesn't work on R2? scrip
- Comments - what is data_type 20? It is not in your
- Comments - Hi, I know Mr. Rafal, he is great speake
 

And thank you for rating the articles!

 

2007-2015 VidasSoft Systems Inc.