Microsoft SQL Server Community Samples: Analysis Services

Source code checked in, #36691

vinival — Mon, 11 Jan 2010 00:07:17 GMT

Added Readme.doc for SSAS DMV Using Data Set. Seems that CodePlex doesn't support docx (Word 2007) format.

Source code checked in, #36689

vinival — Sun, 10 Jan 2010 23:59:05 GMT

Adding SSAS DMV Using DataSet

New Post: Problem running Activity Viewer

RoyalWulf — Tue, 08 Dec 2009 05:24:30 GMT

Hi,

When I run Activity Viewer I get this message:

"Unable to load the list of register servers.

Cannot locate register servers. Please make sure Analysis Servers have been register in SQL Server Management Studio."

I thought I had registered my Analysis Server.

What am I doing wrong?

Cheers,

John Edwards

New Post: Various Studies in same Fact table differing by at least on dimension table value

hydrodba — Tue, 24 Nov 2009 18:22:28 GMT

I have a user that does studies where the dimensions and fact table are set up for the initial study. Subsequent studies may change as little as one value in one of the dimensions from the initial study. The user wants to put the relevant information into the fact table pointing to all the rows for the dimension tables that were the basis for the fact rows of the initial study except for the changed values.

SSIS provided tasks are used to pull data in to the fact table whilst connecting with the dimension tables. The initial study and subsequent studies based on the initial study are identified by a version id. Rows in the dimension table are also identified by a version id. What type of guidelines might there be to the design of the dimension tables to make use of the provided SSIS tasks.

At the moment, it appears that all the rows in the dimension tables need to be duplicated for each subsequent studies. This wastes disk.

The end users of the fact table use excel to draw off scenarios from the fact and dimension tables to create pivot tables. They need to pull of information for the study they are focusing on. Their spreadsheet needs to contain appropriate dimension information that supports the study.

Thanks

Jim Schellenberg

Updated Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Mon, 16 Nov 2009 17:04:19 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Released: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

Mon, 16 Nov 2009 17:04:19 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Updated Wiki: Home

ddarden42 — Mon, 16 Nov 2009 16:59:04 GMT

This project contains SQL Server Analysis Services samples contributed by Microsoft outside of the regular release cycle, MVPs, and other members of the community.

If you would like to contribute new Analysis Services samples to this site or make contributions to samples already posted, Contact the Project Admin

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - Updated 3/6/09 to simplify install and use
Scripts for Using ASCMD for Stress Testing - Updated 2/23/09
Script for Creating a Processing Log File
Powershell Scripts for Querying Analysis Services 2008 DMVs
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
Load Test Reports
RSS Style Sheet
Activity Viewer
Aggregation Manager
AS Trace
Analysis Services Upgrade Verification Tool
SSIS Package For Collecting SSAS DMV Data
SSAS Monitoring Scripts For Management Data Warehouse
SsasHelper - Work with Visual Studio SSAS Projects using AMO, sample MSBuild task to build a SSAS project

Source code checked in, #29416

ddarden42 — Mon, 16 Nov 2009 16:55:12 GMT

Added sample MSBuild task, minor refactoring.

Created Issue: ssas.SSASCleanBatch looks to have bug. [10929]

opoudel — Thu, 12 Nov 2009 16:45:12 GMT

ssas.SSASCleanBatch procedure has where criteria as P_BatchID <= @BatchID in order to get rid of all the old batches. Should not that be P_BatchID < @BatchID?

New Post: Problem Installing SSAS Monitoring App

opoudel — Thu, 12 Nov 2009 16:43:09 GMT

In order to make it work you need to change WHERE P_BatchID <= @BatchID to WHERE P_BatchID < @BatchID to get rid of all batches before current batch.

Source code checked in, #29279

ddarden42 — Fri, 06 Nov 2009 07:13:12 GMT

Removed an unnecessary, but possibly confusing, line of code from the ValidateDatabase method.

Source code checked in, #29247

ddarden42 — Wed, 04 Nov 2009 00:45:31 GMT

Added a method to validate a SSAS Database. The method will return a true/false if there are errors, as well as returning the result collection.

New Post: Problem Installing SSAS Monitoring App

MKeuper — Thu, 08 Oct 2009 15:03:44 GMT

Hi,

I've just installed the monitoring app and the management data warehouse like it was described on yout paper.

But if i look into the trace table, there are no data for the performance traces. Everything else works fine. Including the SSIS tasks.

Could you please tell me why the app still doesn't work?

Best Regards

Marcus

Updated Wiki: Home

ddarden42 — Fri, 18 Sep 2009 20:09:35 GMT

Samples on this site include:

This release contains the following projects:

Compress M2M C# Application
A Solution for Collecting Analysis Services Performance Data for Performance Analysis - Updated 3/6/09 to simplify install and use
Scripts for Using ASCMD for Stress Testing - Updated 2/23/09
Script for Creating a Processing Log File
Powershell Scripts for Querying Analysis Services 2008 DMVs
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
Load Test Reports
RSS Style Sheet
Activity Viewer
Aggregation Manager
AS Trace
Analysis Services Upgrade Verification Tool
SSIS Package For Collecting SSAS DMV Data
SSAS Monitoring Scripts For Management Data Warehouse
SsasHelper - Work with Visual Studio SSAS Projects using AMO

Released: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

Fri, 18 Sep 2009 20:07:47 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Updated Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Fri, 18 Sep 2009 20:07:47 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Updated Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Fri, 18 Sep 2009 20:03:15 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Updated Release: Analysis Services Community Samples-February, 2009 (Feb 27, 2009)

ddarden42 — Fri, 18 Sep 2009 20:01:25 GMT

This release contains the following projects:

Activity Viewer
Aggregation Manager
ASCMD Stress Testing Scripts - Updated 2/23/09 to support Database name different from DatabaseID
AS Load Sim, including Load Testing Best Practices document
AS Query Generator
AS Trace
Analysis Services Upgrade Verification Tool
Compress M2M C# Application
Script for Creating a Processing Log File
Load Test Reports
A Solution for Collecting Analysis Services performance data from multiple sources (MonitoringSSAS.zip) - Updated 3/31/09 to fix one additional named instance bug
Powershell Scripts for Querying Analysis Services 2008 DMVs
RSS Style Sheet
SSIS Package For Collecting SSAS DMV Data - added 2/27/2009 (extracted from MonitoringSSAS solution)
SSAS Monitoring Scripts For Management Data Warehouse - added 2/27/2009 (extracted from MonitoringSSAS solution) - Updated to fix bug - named instance counters for SSAS must be entirely in capital letters
SsasHelper

Source code checked in, #28774

ddarden42 — Fri, 18 Sep 2009 19:53:34 GMT

SsasHelper - Initial Release Sample on working with Visual Studio SSAS Projects + AMO; Serialize/De-Serialize Databases, build .ASDatabase files, Clean SSAS projects for merging.

Closed Issue: Unable to use ASTrace in 64 Bit machine

furmangg — Fri, 21 Aug 2009 16:13:28 GMT

I tried to build ASTrace targetting x86 cpu and deployed into 64bit server. I cant get to start the service. It always fails with following message.
8/19/2009 10:28:54 PM: Error: Microsoft.SqlServer.Management.Trace.SqlTraceException: Failed to initialize object as reader. ---> System.Runtime.InteropServices.COMException (0x8004021A)
at ?A0x8159d01c.ProcessError(Int32 hr, UInt16* lpszMessage)
at Microsoft.SqlServer.Management.Trace.CTraceControllerBase.InitSource(Boolean bReOpen)
at Microsoft.SqlServer.Management.Trace.CTraceObjectsRowsetController.InitSource(Boolean bReOpen)
at Microsoft.SqlServer.Management.Trace.TraceServer.InitializeAsReader(ConnectionInfoBase serverConnInfo, String profileFileName)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Trace.TraceServer.InitializeAsReader(ConnectionInfoBase serverConnInfo, String profileFileName)
at ASTrace.Trace.OnStart(String[] args)

I have already applied the sugesstions given in the other thread related to this issue.

Please let me know what else needs to be done.
Comments:

resolved