{"id":34,"date":"2007-09-25T20:34:43","date_gmt":"2007-09-26T01:34:43","guid":{"rendered":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/34_wsh-scripting-for-analysis-services-2005"},"modified":"2008-03-17T20:56:52","modified_gmt":"2008-03-18T01:56:52","slug":"wsh-scripting-for-analysis-services-2005","status":"publish","type":"post","link":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/34_wsh-scripting-for-analysis-services-2005","title":{"rendered":"WSH Scripting for Analysis Services 2005"},"content":{"rendered":"

Years ago I was using Windows Scripting Host (WSH)\u00a0for majority of my scripting tasks. It is installed by default on all Windows PCs, VBScript language is quite easy to learn\/use and you can do a lot with just a few lines of code. But since DTS was introduced, I started to use DTS more and more and now SSIS is default environment where I do all my scripting. This is because SSIS has very good error loging system and is so much more powerful. But I still use a few WSH scripts that gives me quick status of my SSAS databases. To test them in your environment just copy script to text file, name it with extension *.vbs and then run it with command “CScript YourScript.vbs” with required parameters.<\/p>\n

I have no problems running these scripts on any of my workstation PCs.\u00a0But when I tested these cscripts on my server machines\u00a0I\u00a0was getting error message “Microsoft VBScript runtime error: ActiveX component can’t create object ‘Microsoft.AnalysisServices.Server'”. Maybe I am getting this error message\u00a0because my servers are 64bit, or I might require to manually register some dll(s). If anyone knows how to make it work on server, I would appreciate if you’ll leave your comments here.
\nUpdated:<\/strong> Few hours after\u00a0I posted this blog I got solution from Andreau to this problem. On 64 bit environment\u00a0I have to execute script using command: “c:\\windows\\syswow64\\cscript.exe YourScript.vbs”. Thanks Andreau!<\/p>\n

Here are\u00a02 scripts that you might find useful: <\/p>\n

Script ListDBs.vbs. <\/strong>This script lists Analysis Services databases available on one server and list some basic information about each SSAS database.<\/p>\n

‘ List all SSAS databases in specified server.
\n‘ Run example
\n‘ cscript ListDBs.vbs \/ServerName:MyServerName<\/p>\n

Dim ServerName
\nSet Arguments = WScript.Arguments.Named
\nServerName = Arguments.Item(“ServerName”)<\/p>\n

DIM StateOfObject
\nStateOfObject = Array(“Processed”,”PartiallyProcessed”,”Unprocessed”)<\/p>\n

Dim oServer, oDB, State
\nset oServer = CreateObject(“Microsoft.AnalysisServices.Server”)
\noServer.Connect(ServerName)
\nWScript.Echo “=== SSAS databases on server ” & ServerName
\nFor Each oDB in oServer.Databases
\n\u00a0WScript.Echo oDB.Name
\n\u00a0WScript.Echo ”\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ” & StateOfObject(oDB.State)
\n\u00a0WScript.Echo ”\u00a0 Last Update\u00a0\u00a0 : ” & CStr(oDB.LastUpdate)
\n\u00a0WScript.Echo ”\u00a0 Last Processed: ” & CStr(oDB.LastProcessed)
\n\u00a0WScript.Echo ”\u00a0 Estimated Size: ” & FormatNumber(CDbl(oDB.EstimatedSize) \/ 1024 \/ 1024) & ” MB”\u00a0 ‘ On big DB could be slow, so consider commenting this line out
\n\u00a0WScript.Echo “”
\nNext<\/p><\/blockquote>\n

Note: \u00a0As double quotes might give you problems, please use this text file to get script code<\/a>.<\/p>\n

To run this\u00a0script you have to\u00a0copy script into the text file, rename it to ListDBs.vbs and then use command to\u00a0execute it:<\/p>\n

cscript ListDBs.vbs \/ServerName:Office1<\/p>\n

Here\u00a0Office1 is the name of your Analysis Services server.<\/p><\/blockquote>\n

Results of this script will look something like:<\/p>\n

C:\\Scripts>CScript ListDBs.vbs \/ServerName:Office1
\nMicrosoft (R) Windows Script Host Version 5.6
\nCopyright (C) Microsoft Corporation 1996-2001. All rights reserved.<\/p>\n

=== SSAS databases on server Office1
\nAdventure Works DW
\n\u00a0 State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Processed
\n\u00a0 Last Update\u00a0\u00a0 : 9\/11\/2007 10:38:59 PM
\n\u00a0 Last Processed: 9\/6\/2007 11:04:39 PM
\n\u00a0 Estimated Size: 51.89 MB<\/p>\n

C:\\Scripts><\/p><\/blockquote>\n

Script GetInfoOnOneDB.vbs. <\/strong>This script lists cubes, measure groups, partitions (optionally) and dimensions in one Analysis Services database.<\/p>\n

‘ List information (Cubes, measure groups, dimensions and optionally partitions) in one SSAS database
\n‘ Example to run:
\n‘ CScript GetInfoOnOneDB.vbs \/ServerName:IDS-DB4 \/DBName:iw61bIdsDM \/ShowPartitions:Yes<\/p>\n

Dim ServerName, DBName, ShowPartitions
\nSet Arguments = WScript.Arguments.Named
\nServerName = Arguments.Item(“ServerName”)
\nDBName = Arguments.Item(“DBName”)
\nShowPartitions = Arguments.Item(“ShowPartitions”)
\nIf LCase(ShowPartitions) <> “yes” Then ShowPartitions = “No”<\/p>\n

DIM StateOfObject
\nStateOfObject = Array(“Processed”,”PartiallyProcessed”,”Unprocessed”)<\/p>\n

Dim oServer, oDB, oCube, oMG, oPart, oDim
\nset oServer = CreateObject(“Microsoft.AnalysisServices.Server”)
\noServer.Connect(ServerName)<\/p>\n

FoundDB = False
\nFor Each oDB in oServer.Databases
\n\u00a0if LCase(oDB.Name) = LCase(DBName) Then
\n\u00a0 FoundDB = True
\n\u00a0 Exit For
\n\u00a0End If
\nNext<\/p>\n

If FoundDB = False Then ‘Database not found, terminate script
\n\u00a0WSCript.Echo “***ERROR. Server: ” & ServerName & ” SSAS Database: ” & DBName & ” NOT FOUND!!!”
\n\u00a0WScript.Quit(1)
\nEnd If<\/p>\n

\u00a0WScript.Echo “===== Database information”
\n\u00a0WScript.Echo “Name\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ” & oDB.Name
\n\u00a0WScript.Echo “State\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : ” & StateOfObject(oDB.State)
\n\u00a0WScript.Echo “Last Update\u00a0\u00a0\u00a0 : ” & CStr(oDB.LastUpdate)
\n\u00a0WScript.Echo “Last Processed : ” & CStr(oDB.LastProcessed)
\n\u00a0WScript.Echo “Estimated Size : ” & FormatNumber(CDbl(oDB.EstimatedSize) \/ 1024 \/ 1024) & ” MB”\u00a0 ‘ On big DB could be slow, so consider commenting this line out
\n\u00a0WScript.Echo “”<\/p>\n

\u00a0WSCript.Echo ” Cubes in the database”
\n\u00a0For Each oCube in oDB.Cubes
\n\u00a0 WScript.Echo “Cube: ” & LEFT(oCube.Name & String(15,” “), 15) & “, ” & StateOfObject(oCube.State) & “, ” & CStr(oCube.LastProcessed)<\/p>\n

\u00a0 For Each oMG in oCube.MeasureGroups
\n\u00a0 WScript.Echo ” MG: ” & LEFT(oMG.Name & String(25,” “), 25) & “, ” & FormatNumber(CDbl(oMG.EstimatedSize) \/ 1024 \/ 1024) & ” MB, ” & StateOfObject(oMG.State) & “, ” & CStr(oMG.LastProcessed)<\/p>\n

\u00a0 If LCase(ShowPartitions) = “yes” Then
\n\u00a0\u00a0 For Each oPart in oMG.Partitions
\n\u00a0\u00a0\u00a0\u00a0 WScript.Echo ”\u00a0 Partition: ” & LEFT(oPart.Name & String(25,” “), 25) & “, ” & FormatNumber(CDbl(oPart.EstimatedSize) \/ 1024 \/ 1024) & ” MB, ” & StateOfObject(oPart.State) & “, ” & CStr(oPart.LastProcessed)
\n\u00a0\u00a0 Next ‘ oPart
\n\u00a0 End If<\/p>\n

\u00a0 Next ‘ oMG
\n\u00a0 WScript.Echo “”
\n\u00a0Next ‘ oCube
\n\u00a0WScript.Echo “”<\/p>\n

\u00a0WScript.Echo “=== Dimensions”
\n\u00a0For Each oDim in oDB.Dimensions
\n\u00a0 WScript.Echo “Dim: ” & LEFT(oDim.Name & String(25,” “), 25) & “, ” & StateOfObject(oDim.State) & “, ” & CStr(oDim.LastProcessed)
\n\u00a0Next
\nWScript.Quit(0)<\/p><\/blockquote>\n

Note: \u00a0As double quotes might give you problems, please use this text file to get script code<\/a>.<\/p>\n

To run this\u00a0script you have to\u00a0copy script text into text file, rename it to ListDBs.vbs and then use command to\u00a0execute it:<\/p>\n

CScript GetInfoOnOneDB.vbs \/ServerName:Office1 \/DBName:”Adventure Works DW”\u00a0\/ShowPartitions:Yes<\/p>\n

Here\u00a0Office1 is the name of your Analysis Services server.<\/p><\/blockquote>\n

Results of this script will look something like:<\/p>\n

C:\\Scripts>cscript GetInfoOnOneDB.vbs \/ServerName:Office1 \/DBName:”Adventure Wor
\nks DW” \/ShowPartitions:Yes
\nMicrosoft (R) Windows Script Host Version 5.6
\nCopyright (C) Microsoft Corporation 1996-2001. All rights reserved.<\/p>\n

===== Database information
\nName\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Adventure Works DW
\nState\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : Processed
\nLast Update\u00a0\u00a0\u00a0 : 9\/11\/2007 10:38:59 PM
\nLast Processed : 9\/6\/2007 11:04:39 PM
\nEstimated Size : 51.89 MB<\/p>\n

\u00a0Cubes in the database
\nCube: Adventure Works, Processed, 9\/6\/2007 9:41:15 PM
\n\u00a0MG: Internet Sales\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 2.28 MB, Processed, 9\/6\/2007 9:41:10 PM
\n\u00a0 Partition: Internet_Sales_2001\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.03 MB, Processed, 9\/6\/2007 9:40:56 PM
\n\u00a0 Partition: Internet_Sales_2002\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.08 MB, Processed, 9\/6\/2007 9:40:59 PM
\n\u00a0 Partition: Internet_Sales_2003\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.95 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Internet_Sales_2004\u00a0\u00a0\u00a0\u00a0\u00a0 , 1.10 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0MG: Internet Orders\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 1.73 MB, Processed, 9\/6\/2007 9:41:10 PM
\n\u00a0 Partition: Internet_Orders_2001\u00a0\u00a0\u00a0\u00a0 , 0.03 MB, Processed, 9\/6\/2007 9:40:55 PM
\n\u00a0 Partition: Internet_Orders_2002\u00a0\u00a0\u00a0\u00a0 , 0.08 MB, Processed, 9\/6\/2007 9:40:50 PM
\n\u00a0 Partition: Internet_Orders_2003\u00a0\u00a0\u00a0\u00a0 , 0.73 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Internet_Orders_2004\u00a0\u00a0\u00a0\u00a0 , 0.85 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0MG: Internet Customers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 1.17 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0 Partition: Customers_2001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.01 MB, Processed, 9\/6\/2007 9:40:59 PM
\n\u00a0 Partition: Customers_2002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.03 MB, Processed, 9\/6\/2007 9:40:55 PM
\n\u00a0 Partition: Customers_2003\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.51 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Customers_2004\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.58 MB, Processed, 9\/6\/2007 9:40:57 PM
\n\u00a0MG: Sales Reasons\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 9:40:55 PM
\n\u00a0 Partition: Internet_Sales_Reasons\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 9:40:50 PM
\n\u00a0MG: Reseller Sales\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 3.15 MB, Processed, 9\/6\/2007 9:41:10 PM
\n\u00a0 Partition: Reseller_Sales_2001\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.29 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Reseller_Sales_2002\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.76 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0 Partition: Reseller_Sales_2003\u00a0\u00a0\u00a0\u00a0\u00a0 , 1.17 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0 Partition: Reseller_Sales_2004\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.64 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0MG: Reseller Orders\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 1.23 MB, Processed, 9\/6\/2007 9:41:10 PM
\n\u00a0 Partition: Reseller_Orders_2001\u00a0\u00a0\u00a0\u00a0 , 0.13 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0 Partition: Reseller_Orders_2002\u00a0\u00a0\u00a0\u00a0 , 0.31 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0 Partition: Reseller_Orders_2003\u00a0\u00a0\u00a0\u00a0 , 0.46 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0 Partition: Reseller_Orders_2004\u00a0\u00a0\u00a0\u00a0 , 0.26 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0MG: Sales Summary\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 2.85 MB, Processed, 9\/6\/2007 9:41:10 PM
\n\u00a0 Partition: Total_Sales_2001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.08 MB, Processed, 9\/6\/2007 9:40:56 PM
\n\u00a0 Partition: Total_Sales_2002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.42 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Total_Sales_2003\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 1.09 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Total_Sales_2004\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 1.07 MB, Processed, 9\/6\/2007 9:41:09 PM
\n\u00a0MG: Sales Orders\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 2.05 MB, Processed, 9\/6\/2007 9:41:10 PM
\n\u00a0 Partition: Total_Orders_2001\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.13 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Total_Orders_2002\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.32 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Total_Orders_2003\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.79 MB, Processed, 9\/6\/2007 9:41:08 PM
\n\u00a0 Partition: Total_Orders_2004\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.76 MB, Processed, 9\/6\/2007 9:41:06 PM
\n\u00a0MG: Sales Targets\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 9:40:55 PM
\n\u00a0 Partition: Sales_Quotas\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 9:40:50 PM
\n\u00a0MG: Financial Reporting\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.39 MB, Processed, 9\/6\/2007 9:41:01 PM
\n\u00a0 Partition: Finance\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.36 MB, Processed, 9\/6\/2007 9:41:00 PM
\n\u00a0MG: Exchange Rates\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.28 MB, Processed, 9\/6\/2007 9:40:55 PM
\n\u00a0 Partition: Currency_Rates\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.28 MB, Processed, 9\/6\/2007 9:40:50 PM<\/p>\n

Cube: Mined Customers, Processed, 9\/6\/2007 11:04:39 PM
\n\u00a0MG: Internet Sales\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 11:04:38 PM
\n\u00a0MG: Internet Orders\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 11:04:38 PM
\n\u00a0MG: Internet Customers\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 11:04:38 PM
\n\u00a0MG: Sales Reasons\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 11:04:38 PM
\n\u00a0MG: Exchange Rates\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , 0.00 MB, Processed, 9\/6\/2007 11:04:38 PM
\n=== Dimensions
\nDim: Promotion\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:16 PM
\nDim: Product\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:45 PM
\nDim: Customer\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:36 PM
\nDim: Geography\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:39 PM
\nDim: Reseller\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:49 PM
\nDim: Sales Territory\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:28 PM
\nDim: Employee\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:50 PM
\nDim: Scenario\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:23 PM
\nDim: Department\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:42:56 PM
\nDim: Organization\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:15 PM
\nDim: Account\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:09 PM
\nDim: Date\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:42 PM
\nDim: Source Currency\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:44 PM
\nDim: Sales Reason\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:34 PM
\nDim: Reseller Sales Order Deta, Processed, 9\/5\/2007 10:42:47 PM
\nDim: Internet Sales Order Deta, Processed, 9\/5\/2007 10:43:35 PM
\nDim: Clustered Customers\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:46:19 PM
\nDim: Subcategory Basket Analys, Processed, 9\/5\/2007 10:46:19 PM
\nDim: Sales Channel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/5\/2007 10:43:48 PM
\nDim: Destination Currency\u00a0\u00a0\u00a0\u00a0 , Processed, 9\/6\/2007 9:40:29 PM
\nDim: Sales Summary Order Detai, Processed, 9\/5\/2007 10:43:23 PM<\/p>\n

C:\\Scripts><\/p><\/blockquote>\n

Note: on the big databases, you might want to\u00a0comment out\u00a0code that get “Estimated Size” property value. This is because Analysis Services is quite slow to calculating value of this property.<\/p>\n","protected":false},"excerpt":{"rendered":"

Years ago I was using Windows Scripting Host (WSH)\u00a0for majority of my scripting tasks. It is installed by default on all Windows PCs, VBScript language is quite easy to learn\/use and you can do a lot with just a few lines of code. But since DTS was introduced, I started to use DTS more and […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[4],"tags":[],"aioseo_notices":[],"_links":{"self":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/34"}],"collection":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/comments?post=34"}],"version-history":[{"count":0,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/posts\/34\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/media?parent=34"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/categories?post=34"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.ssas-info.com\/VidasMatelisBlog\/wp-json\/wp\/v2\/tags?post=34"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}