SSAS-Info.com April 2008
This newsletter can be accessed online at:
http://www.ssas-info.com/analysis-services-newsletters/45-site
Announcements
In April IT-Workplace released Intelligencia Query for BIDS and Reporting Services. Intelligencia Query combines a state-of-the-art query builder with custom data extensions to significantly improve the functionality and productivity of BIDS and Reporting Services. With IQ you are able to render any piece of valid MDX without having to conform to the restrictions imposed by the standard Reporting Services environment. Read more...
SSAS 2005 Articles
- AMO - SSAS Stored Procedures - connecting to the transactional data source
- Design - SSAS Beginner’s Guide: Storage Structure
- Design - Dimension Attributes: Introduction and Overview, Part II
- MDX - Currency formats: should they be tied to language?
- MDX - Semi Additive Measures using SQL Server Standard
- MDX - Leaves() : Works for regular hierarchies but not for parent child hierarchies
- MDX - SSAS MDX Round = Banker's Rounding
- MDX - Set Functions: The StripCalculatedMembers() Function
- MDX - Can your sum be a subtraction? Or can you avoid it altogether
- MDX - Regular Expressions for MDX
- MDX - Subselects, SCOPEs and hierarchy navigation MDX functions
- Parent-Child: Parent-Child Dimension in a correct DW? Easy
- Parent-Child: Parent Child Attribute performance woes in SQL Server 2005 SP2: A case study
- Performance tuning: powerSSAS: Getting Aggregations for a particular Attribute
- Performance tuning: Analysis Services 2005 Design Best Practices - Cubes & MDX
- Reporting Services: Support Parameterization from Analysis Services – Parameter Defaults
- Reporting Services: Passing MDX parameters in Reporting Services reports
SSAS 2008 Articles
SSAS Client Tools
SSAS Tools
- Intelligencia Query for BIDS and Reporting Services
- SqlSpec - documentation tool for Analysis Services 2005
- Transact Sql Server Analysis Services Metadata
Webcasts
- Virtual Lab: Data Mining with SQL Server 2008
- Virtual Lab: SQL Server 2008 Analysis Services- Delivering Analysis Services capabilities through Microsoft Office
- Virtual Lab: SQL Server Analysis Services- Managing Analysis Services Solutions
- TechNet Virtual Lab: Business Intelligence- Excel 2007 PivotTables and Analysis Services
SSAS Implementations
- Denny Lee from SQL CAT: Data Mining applied to medical research
- Podcast - Val Matison Gives Us Business Intelligence!
- Business Intelligence (BI) for Less Than $25k
Don't forget to rate the articles!