Report Portal

SSAS-Info.com website update information for January, 2010

Please add our newsletter address to your safe senders list!

This newsletter can be accessed online at:
http://www.ssas-info.com/analysis-services-newsletters/45-site

SSAS-Info.com Poll closed today

What do you think about PowerPivot/Gemini?

I have not seen it yet. 40.3% 
I saw demos of it and I like it.  25.4% 
I tested it and I like it. 16.1% 
I tested it and I don't like it. 13.3% 
I saw demos of it and I don't like it. 4.8% 

Number of Voters   :  248 

New SSAS-Info.com Poll

What is the most important feature for you in the BIDS Helper utility?  

 Aggregation Manager 
 Deploy MDX Script 
 Dimension Data Type Discrepancy Check 
 Dimension Health Check 
 Measure Group Health Check 
 Tri-State Perspectives 
 Smart Diff 
 All of the above features and more 
 I am not using BIDS Helper

(Read more about BIDS Helper here)

Please vote at: http://www.ssas-info.com/polls

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

News

- SSAS News - Jan 22, 2010 - First stable version of open source project "Ranet.UILibrary.Olap - Silverlight UI component library for OLAP" released
- SSAS News - Jan 18, 2010 - MS Released CU6 package for SQL Server 2008 SP1 (CU9 for RTM)
 

Articles

- MDX - Cube, Different Dimensions, Different Data
- MDX - Average among siblings
- MDX - Average Aggregation in Analysis Services
- MDX - SSAS Calculated Measures for Business (II): Annualized Measures
- MDX - Beware Hidden Calculated Members
- MDX - Excel and MDX multiselect problems revisited
- MDX - SetFocus BI/SQL Master's Program Tip (from student alumnus question): when PREVMEMBER alone isn't enough in MDX
- MDX - Scope statement & ignoring non leaf data
- MDX - SSAS: Median cube measures Aggregation
- Security - Cell Security and Calculated Members Defined in the WITH Clause or Session
- Reporting Services - SSRS and MDX: Detecting Missing Fields
- Reporting Services - Your First OLAP Report
- Reporting Services - Suppress Auto Update of MDX Parameter Datasets in Reporting Services 2008
- Data Mining - How to obtain RecordCount (or Number of cases) from a DMX query
- AMO - Paired T-Test in SSAS 2005+
- AMO - How to Audit SSAS role permissions
- Design - Do not set error configuration for KeyDuplicate to IgnoreError
- Design - Strange Perspectives
- Design - SSAS -- to Partition or not?
- Design - Different granularity in a single dimension
- Design - SSAS Calculated Measures for Business (I): Introduction
- Design - Five Basic Steps for Implementing an Analysis Services Database
- Design - Many-to-many in attribute relationship
- Management - Who Are Using The Cubes Now?
- Management - SSAS Cube Testing
- Management - Duplicate Attribute keys in SSAS
- Management - SSAS Quick Reference: Attribute Key Cannot Be Found
- Management - Take the cube offline
- Management - Backing Up SSAS Databases
- Performance Point - Using Excel Services Reports with PerformancePoint Server (PPS)
- Performance Point - Installing Dashboard Designer for PerformancePoint Server (PPS)
- Performance Point - Performance Point - Filter Connection Quick Reference
- Performance Point - Performance Point - Time Intelligence Formula Quick Reference
- Performance Point - Publishing PerformancePoint to Extranet Users
- SSAS 2008 DMVs - What are SSAS DMVs?
 

Comments

- Comments - M.Solcia, I believe this was very tem
- Comments - The link "read more" doesn't work. Web p
- Comments - Excellent article. Thanks so much.
- Comments - Absolutely brilliant. Thanks a bunch aga
- Comments - Hi "Creative OLAP" In the script that
- Comments - Dear Vidas, I want to thank you for t
- Comments - I felt the same too... looks like you do
- Comments - Hi Prasad, you can use this script for L
- Comments - All Parent-Child related articles that a
- Comments - Hi, I need some new pdf articles in the
- Comments - wow that was quick! I just wrote it yest
- Comments - The Last YTD is fine as per the code :
- Comments - The Content is just what the doctor pres
 

And thank you for rating the articles!

 

2007-2015 VidasSoft Systems Inc.