SSAS-Info.com website update information for January 2009
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 January.
- SSAS News - Microsoft announced that they will retire PerformancePoint as a product
- SSAS News - MS Released Cumulative update package 3 for SQL Server 2008
- Announcements - BIDS Helper version 1.4 released
- Announcements - Week of Warehousing Webinar Series, Free - Feb 23-27, 2009
- Announcements - Microsoft BI conference 2008 DVD set with recorded sessions available for sale
- SSAS Client Tools - BristolReport
- SSAS Client Tools - Actuate Analytics
- Management FAQ - Q:I would like to create an e-mail alert when some criteria has been met after processing Analysis Service cube. Any sugestion?
- SSAS 2008 DMVs - Analysis Services 2008 $SYSTEM.DBSCHEMA_% DMVs
- SSAS 2008 DMVs - Analysis Services 2008 $SYSTEM.DMSCHEMA_% DMVs
- SSAS 2008 DMVs - Analysis Services 2008 $SYSTEM.MDSCHEMA_% DMVs
- SSAS 2008 DMVs - Q:How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation?
- SSAS 2008 DMVs - Q: How can I get a list of measures in one measure group from SSAS DMVs?
- SSAS 2008 DMVs - Q: How in DMV can I convert data_type field from integer to string representation?
- SSAS 2008 DMVs - Q: How can I get a list of available SSAS databases using DMVs?
- SSAS Tips - Relationship between fact dimension could have type "Fact relationship" or "Regular relationship". No difference, except metadata
- SSAS Tips - Speed up MDX query preparation in Reporting Services by specifying default parameter value
- SSAS Tips - Set proper InstanceSelection property for attributes used in the Report Model with Lookup Entity
- SSAS Tips - You can order date dimension in descending order by setting OrderByAttribute property
- MDX - MDX equivalent of a filtered GROUP BY in SQL
- MDX - Named Set Subtotals in Excel
- MDX - Row number
- MDX - A simple MDX ratio problem
- MDX - Debunking the myth of MDX hierarchy, level and member once and for all!
- MDX - MDX is exceedingly hard to grasp
- MDX - Intrinsic Member Properties: The DIMENSION_UNIQUE_NAME Property
- MDX - Dynamic Set for MDX Calculations
- Excel - Excel 2007: Changing the pivot filter value changes the chart type
- Excel - Accessing Cubes from Excel 2007
- Reporting Services - Simple Pie Chart for Analysis Services Data
- Reporting Services - Speeding up the Query Parameters Dialog in the SSRS Query Designer
- Drillthrough - Issues executing a DRILLTHROUGH with a ROLAP dimension
- Drillthrough - Drill Through in Analysis Services
- AMO - Debugging SSAS stored procedures
- AMO - Backing up Analysis Service database using Windows PowerShell and SQL Server 2008 AMO
- AMO - Using Windows PowerShell and AMO to create an SSAS Database
- Performance Tuning - Formula Caching and Query Scope
- Design - Ignore Unrelated Dimensions in a SSAS Cube
- Design - Pre-Aggregated Data and Changing Dimensions
- Design - Attribute Relationships: Settings and Properties
- Design - Implementing Cube Settings
- Management - Add a UDF function to the MDX expression box in 2005 like in 2000
- Management - Moving writeback data in the Fact tables and avoiding problems with changing column names
- SSAS 2008 DMVs - What hierarchies are actually being used in my cube?
- SSAS Webcasts - Using SQL Server 2005 Analysis Services with the Project Server 2007 Cube Building Service
- Comments - Simply creating a hierarchy Year-Qtr-Mon
- Comments - "there are a number of new fancy feature
- Comments - Zia, SIrfnet - Thank you for letting me
- Comments - were is the article
- Comments - I certainly appreciate your opinions. I
- Comments - I think it's extremely important to have
- Comments - Actually, I think that "myth" is an inco
- Comments - Hi, Bill Thanks for your comments. I
- Comments - Take a look at my series "MDX Essentials
- Comments - Leandro, Based on the comments from t
- Comments - Somebody knows if issue nº 50003080 has
- Comments - Thank you very much, this is really hel
- Comments - When you design dimension, on the left s
- Comments - Where do you set the attribute relations
- Experience - Dave Rodabaugh's Analysis Services interview questions
- Experience - Microsoft Business Intelligence Surface Demo
- Consultants - Practical Computer Applications
And thank you for rating the articles!