Load Testing Tool required for Excel Pivot table based OLAP Application

[Guest]

We have developed a solution which provides reporting services from MS-Analysis Server, using MS-Excel as the user interface. Pivot Table services of Excel are used to access the OLAP data. We have not customized the query or the interface protocols; everything is handled by inbuilt MS features. What are the mechanisms and tools available to do load testing of such a solution? An existing HTTP/Socket session license of a Load Test software is unable to meet this requirement

Any suggestions for the Load Testing

Thanks in advance

 

[Wei-Dong Xu [MSFT]]

Hi,

Thanks for participating the community!

Currentlly we are performing some research on this problem, and we will
reply you as soon as possible if we get any results! Have a nice weekend!


Wei-Dong Xu
Microsoft Product Support Services
Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter Huang]

Hi,

Thanks for posting in the community.

From your description, I understand that you wants to you wants to use the
Pivot Table services of Excel to access the OLAP. Based on my understanding
the Loading Test in your post means tests the performance of the OLAP
service.(e.g. what the performance will be if query a lot data from OLAP)
Have I fully understood you? If there is anything I misunderstood, please
feel free to let me know.

In the Excel side, I think you can use the VBA code to connect to the OLAP
server and retrieve the data.
Sub Macro1()
With ActiveWorkbook.PivotCaches.Add(SourceType:=xlExternal)
.Connection = _
"OLEDB;Provider=MSOLAP.2;Data Source=sha-michael-01;Initial
Catalog=FoodMart 2000;Client Cache Size=25;Auto Synch Period=10000"
.CommandType = xlCmdCube
.CommandText = Array("Sales")
.MaintainConnection = True
.CreatePivotTable TableDestination:="[Book2]Sheet1!R1C1",
TableName:= _
"PivotTable1", DefaultVersion:=xlPivotTableVersion10
End With
With ActiveSheet.PivotTables("PivotTable1").CubeFields("[Marital
Status]")
.Orientation = xlColumnField
.Position = 1
End With
With ActiveSheet.PivotTables("PivotTable1").CubeFields("[Product]")
.Orientation = xlRowField
.Position = 1
End With

ActiveSheet.PivotTables("PivotTable1").CubeFields(5).TreeviewControl.Drilled
= _
Array("")

ActiveSheet.PivotTables("PivotTable1").CubeFields(4).TreeviewControl.Drilled
= _
Array("")
Range("B4").Select
ActiveSheet.PivotTables("PivotTable1").AddDataField
ActiveSheet.PivotTables( _
"PivotTable1").CubeFields("[Measures].[Sales Average]"), "Sales
Average"
Range("C3").Select
End Sub

You can use the record macro function of excel to generate the macro
automatically by Selecting Tool/Macro/Record New Macro...
And you can connect to OLAP and restieve the data from OLAP by wizard
operation provided by Excel, after that you will find the macro used to do
the same thing as the wizard do.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.