A few weeks ago I asked a question on Analysis Services 2008 forum if there will be PowerShell support for SSAS 2008. I got an answer from Microsoft, that no native support is planned. I know that Darren Gosbell released PowerShell Provider for SSAS 2005, but for the different reasons I cannot use it with all clients. But just this week Carl Rabeler (Microsoft) posted a new updated set of Analysis Services 2005/2008 Samples. One folder in these samples contained 4 PowerShell script examples that shows how to use it with Analysis Services. I tested these samples and they worked on a standard SSAS 2008 installation. Today Carl Rabeler actually updated these samples - fixed some minor issues and added one more sample - to get a size of Analysis Services database.
Vidas Matelis Analysis Services Blog
My work with Microsoft BI, SQL Server Analysis Services 2005, 2008
- SQL Server (3)
- SQL Server 2008 (1)
- SSAS (37)
- SSAS 2008 - Katmai (15)
- SSIS (6)
- Uncategorized (2)
- August 2008 (1)
- July 2008 (1)
- June 2008 (3)
- April 2008 (3)
- March 2008 (3)
- February 2008 (1)
- January 2008 (2)
- November 2007 (3)
- October 2007 (2)
- September 2007 (2)
- August 2007 (3)
- July 2007 (3)
- June 2007 (3)
- May 2007 (5)
- April 2007 (6)
- March 2007 (4)
- A great website with SSAS video learning material
- SSAS 2008 DMVs - querying from the SQL Server and database diagrams
- Microsoft SQL Server 2008 RC0 - New Adventure Works Sample Databases for SSAS
- SSAS 2008 RC0 - New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets - DMVs
- Excel 2007 Pivot Table with SharePoint On Vista PC - works good after SP1
- SQL Server 2008 Management Data Warehouse
- Pictures from the 2008 MVP summit
- I received Microsoft MVP award
- Analysis Services 2005 and 2008 with PowerShell - it works
- Live report example website with Microsoft BI technologies
- SSAS 2008 CTP6 - new DMV $SYSTEM. DISCOVER_ OBJECT_ ACTIVITY
- SQL Server 2008 February CTP6 - Read-only SSAS Shared Scale-out and other changes
- I am nominated for MVP award
- Splitting Analysis Services 2005 cubes based on measure groups
- Katmai Analysis Services 2008 November CTP5 - tests on metadata rowsets
- MS SQL Server Analysis Services 2008 - November CTP quick review
- Customizing object names in Analysis Services database using translations
- Microsoft Analysis Services Data mining webcasts
- Analysis Services property EnableFast1033Locale for English installations
- WSH Scripting for Analysis Services 2005
- SSIS: Issue with OLE DB Source component that is based on parametrized SQL Query
- New MS Paper: Identifying and Resolving MDX Query Performance Bottlenecks in SQL Server 2005 Analysis Services
- SSAS 2008 Katmai - MDX Changes
- SSAS 2008 Katmai - info from August 9th webcast
- SSAS 2008 Katmai - upcoming changes in the next CTP
- Script to backup Analysis Services 2005 databases
- SQL Server 2005 Best Practices Analyzer - test on SSAS database
- SSAS 2008 June Katmai - more testing results
- SSAS 2008 - Info from chat session
- SSAS 2008 Katmai review - installation and first impressions
- Presentation slides online - “SSAS Implementation Best Practices”
- My notes from Microsoft BI Conference
- 2007 BI Conference
- New MS Paper: 2007 Microsoft Office System Business Intelligence Integration with SQL Server 2005
- New SSAS blogger - Ramunas Balukonis
- SSAS database processing sometimes gets stuck
- SSAS security - different methods
- SSIS Package to drop/create partitions based on partition list in the SQL Server table
- SSIS package that process all partitions/measure groups/cubes in one database
- Numbers scale impact on SSAS 2005 storage
Live report example website with Microsoft BI technologies
I just found an great website with a live running demo of report examples with Analysis Services, SharePoint, PerformancePoint, Excel Services, Reporting Services and other Microsoft BI Technologies. This is Richard Lee’s website:
http://richardlees.com.au/sites/Demonstrations
From the site:
Site has a variety of data mining, OLAP and business intelligence tools on several real (census, web logs, Perfmon and libraries) and synthetic (foodmart) databases of over 100 Million records. The demonstrations are platformed on Microsoft SQL Server 2005 and Microsoft SharePoint Server, Microsoft PerformancePoint Server 2007 and Excel Services.
Well worth visiting and exploring all these online examples.
SSAS 2008 CTP6 - new DMV $SYSTEM. DISCOVER_ OBJECT_ ACTIVITY
Today I was reading Chris Webb post ”Visualising Analysis Services Trace Information in Reporting Services” where at the end he talks about tools to monitor SSAS, that made me thinking about SSAS 2008 DMVs again. So I went back to my SSAS 2008 installation to see what do we have new in CTP6. Just after release Darren Gosbell already blogged about new DMVs in his post “SSAS 2008: What’s new in the Schema Rowsets?“. But just after I started to run queries I realized how cool these new DMVs are. After quick test on them, I decided to blog today about my favorite DMV so far: $SYSTEM.DISCOVER_OBJECT_ACTIVITY.