Report Portal

About me

I work as SQL Server DBA / Developer and BI Consultant in Toronto, Canada.Canada Flag More...
Vidas Matelis picture

Search

blank

Microsoft SQL Server 2008 RC0 – New Adventure Works Sample Databases for SSAS

June 10th, 2008 by Vidas Matelis

As you probably all already know Microsoft released SQL Server 2008 Release Candidate 0 (RC0).  You can download RC0 from here. You can also download SQL Server 2008 Books Online Release Candidate (RC0) and Microsoft SQL Server 2008 Feature Pack RC0, June 2008.

Just today Microsoft also released another related download: Sample Databases for Microsoft SQL Server 2008 RC0. New sample set contains 8 BI related files that lets you install Adventure Works DW and Analysis Services databases:

  • SQL2008.AdventureWorks_DW_BI_v2005.ia64.msi
  • SQL2008.AdventureWorks_DW_BI_v2005.x64.msi
  • SQL2008.AdventureWorks_DW_BI_v2005.x86.msi
  • SQL2008.AdventureWorks_DW_BI_v2005.zip
  • SQL2008.AdventureWorks_DW_BI_v2008.ia64.msi
  • SQL2008.AdventureWorks_DW_BI_v2008.x64.msi
  • SQL2008.AdventureWorks_DW_BI_v2008.x86.msi
  • SQL2008.AdventureWorks_DW_BI_v2008.zip

As you can see, installation files are split by CPU type (x86, x64 and ia64) and also by related SQL Server version. Files with _v2008 suffix can only be used with SQL Server 2008 and demonstrates some of the new features. If you want to do manual file copy, you can use 2005 or 2008 version zip file.

Read the rest of this entry »

Posted in SSAS, SSAS 2008 - Katmai | 1 Comment »

SSAS 2008 RC0 – New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets – DMVs

June 6th, 2008 by Vidas Matelis

In my previous post Katmai Analysis Services 2008 November CTP5 – tests on metadata rowsets I listed examples of new SSAS DMVs. But there were few DMVs that you could not query. For example if you would try to execute following query:

SELECT * FROM $SYSTEM.DISCOVER_PARTITION_DIMENSION_STAT

You would get this error message: 

The ‘DATABASE_NAME’ restriction is required but is missing from the request.

Read the rest of this entry »

Posted in SSAS, SSAS 2008 - Katmai | Comments Off on SSAS 2008 RC0 – New function SYSTEMRESTRICTSCHEMA for restricted schema rowsets – DMVs

Excel 2007 Pivot Table with SharePoint On Vista PC – works good after SP1

June 5th, 2008 by Vidas Matelis

Our company is using Microsoft Excel 2007 with Microsoft Office SharePoint Server 2007 and Excel Services as the primary interface to access Analysis Services cube data. This works very well on Windows XP PC, but was almost unusable on Windows Vista PC. On Vista PC you would get just too many “Enter UserName/Password” dialogs.

Here is what would happen on Vista PC when you try to open Excel report with Pivot Table from the SharePoint: Read the rest of this entry »

Posted in SSAS | Comments Off on Excel 2007 Pivot Table with SharePoint On Vista PC – works good after SP1