SSAS-Info.com website update information for April, 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
The following information was added to the SSAS-Info.com website during the month of April.
News
- SSAS News - Apr 21, 2010 - SQL Server 2008 R2 released to manufacturing
- SSAS News - Apr 19,2010 - MS released Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3
Software
- SSAS Tools - ORAYLIS BI.SmartDiff (free)
- SSAS Client Tools - Intelligencia for SilverLight
Jobs
- SSAS Jobs - BI Architect opportunity, NJ, long term consulting
- SSAS Jobs - Microsoft Business Intelligence developer, Sunnyvale, California, 6+ months
FAQ
- Management FAQ - Q: Why SQL function: ObjIDUpdate() takes long time to execute when ROLAP SSAS cubes are used?
Articles
- MDX - MDX code snippet Existing
- MDX - Scope Assignments and Missing Members
- MDX - Finding Last n members of a Particular month of a particular Year from a Time Dimension using MDX
- MDX - MDX query for Subtree Members and Leaf Members
- MDX - Improving cell security performance in SSAS
- MDX - Pie chart with ‘others’ category (collected data)
- MDX - Variance calculation using MDX calculated measure in SSAS
- MDX - Searching substrings in MDX
- Security - Implementing measure security in SSAS 2008
- Security - Using EffectiveUserName To Impersonate in SSAS
- Excel - Improving Excel's Cube Performance
- Reporting Services - "T-SQL Tuesday #005" MDX and SSRS
- Data Mining - Association rules viewers
- Time Dimension - Period Dimension (Time Dimension) Creation with Year, Month, Day Hierarchy
- AMO - Compression with SSAS 2005 using ADOMD.Net
- AMO - Creating Role in SQL Server Database using C#
- Performance Tuning - Analysis Services and Solid State Disks
- Performance Tuning - Analysis Services I/O Time
- Design - Setting default member in role playing dimensions
- Design - Dimension Grouping and Ordering in SSAS
- Design - Naming Objects in Analysis Services
- Design - Properly showing values for unrelated dimensions (IgnoreUnrelatedDimensions)
- Management - Configure Surface Area Configuration for SQL Server 2008 Analysis Services Using Policy Based Management
- Management - SSAS: Errors in the OLAP storage engine: The sort order specified for distinct count records is incorrect.
- Management - Promoting Microsoft SSAS Changes to Test and Prod
- Management - Creating solution file from a SSAS database
- Management - SSAS – Synchronisation performance
- Management - Adding Actions to a Cube in SQL Server Analysis Services 2008
- Performance Point - Modifying PPS Dashboards with SharePoint Web Parts
- Performance Point - Installing and Configuring PerformancePoint Server 2007 in a Distributed Environment
- Performance Point - Up to Speed with PerformancePoint Dashboard Designer
- Performance Point - A General Caching Overview for Performance Point Services for SharePoint 2010
- Performance Point - Overcoming Calendar Limitations in PerformancePoint Planning
Comments
- Comments - Cool article. It instantly helped me res
- Comments - Can this default behavior be configured
- Comments - Thanks a lot, the link was very helpful
- Comments - Gbaksh, I updated link. Sorry about t
- Comments - Can you please provide the correct link
- Comments - Mike - Thank your finding correct url! I
- Comments - I think this link should be changed to:
- Comments - very good video. i thank u for this grea
- Comments - After I create the Model and press ok, I
- Comments - Hi, I am totally new to SSAS. As you
- Comments - Could you please explain how to understa
- Comments - Dave, a lot of your conclusions to your
- Comments - You can now download the tool at: http:
- Comments - I have 5 warehousetransactions: 2001-
- Comments - Spot on. Thank you.
- Comments - This link does not take you to any webca
- Comments - SSAS HY008 is nothing, there is another
- Comments - Great product .
- Comments - SSAS 2008 connection string properties a
- Comments - This is great! Is there a list for 2008
SSAS Companies
- Consultants - Kohera, Belgium
And thank you for rating the articles!