Stack Overflow
Stack Overflow

Questions tagged [ascmd]

The ascmd command-line utility enables a database administrator to execute an XMLA script, MDX query, or DMX statement against an instance of Microsoft SQL Server 2005 Analysis Services (SSAS).

From the documentation page:

The ascmd command-line utility enables a database administrator to execute an XMLA script, MDX query, or DMX statement against an instance of Microsoft SQL Server 2005 Analysis Services (SSAS). This command-line utility contains functionality for Analysis Services that resembles the sqlcmd utility included with SQL Server 2005. For more information, see the topic sqlcmd Utility in SQL Server 2005. The execution results of the script, query, or statement can be stored in a file together with relevant SQL Server Profiler trace information.

11 questions
6
votes
3 answers

Where can I download a ascmd.exe?

I need to execute MDX query from command line (MS AS 2005). I have heard, that there is a program named ascmd, which can do this. Unfortunately, when I went to codeplex page I found that page supposed to deliver an ascmd doesn't work. Please help if…
michal
2
votes
2 answers

How to persuade ascmd.exe to make tables as output, not a XML file?

I'm trying to see data in my OLAP cube by ascmd utility. As input I put a MDX query, but only what I have as output (in command line) is a XML file. I tried to use -Tf text and -Tf csv parameters, but they don't work in the way I think they should…
michal
2
votes
1 answer

Ascmd.exe process stuck on OLAP creation

I'm pulling my hair out here for that I can't understand what is going on I have the following: Windows Server 2008 R2 64-bit SQL Server 2008 R2 64-bit When I run ascmd.exe it giving xml file in order to build OLAP database, most of the time the…
liorafar
  • 2,264
  • 4
  • 19
  • 39
2
votes
2 answers

Ascmd tool clamis database already exists however it does not appear

I'm trying to create OLAP DB via analysis services in SQL Server 2008 with ascmd.exe tool I get the following error: Error ErrorCode="3239313410" Description="Errors in the metadata man ager. The database with the name of 'CosmoComOLAPDB' already…
liorafar
  • 2,264
  • 4
  • 19
  • 39
1
vote
1 answer

System.OutOfMemoryException while MDX Query using Invoke-ASCmd

i want to import a MDX result set into Powershell using Invoke-ASCmd. Import-Module SQLPS -DisableNameChecking Import-Module SQLASCMDLETS Push-Location SQLSERVER:\SQLAS\$ServerInstance\Default\Databases\$Database\Cubes\ $result = Invoke-ASCmd…
abbgrade
  • 548
  • 5
  • 19
1
vote
1 answer

Invoke-ASCmd warning - Is this why the cube doesn't deploy?

SSAS 2012 and Powershell 5.0> I have a deployment automation process that runs the Deployment.exe wizard in silent mode to create an XMLA file and then uses Invoke-ASCmd to deploy the SSAS project to an SSAS server. It works fine for our…
Richard Schaefer
  • 525
  • 3
  • 13
  • 45
1
vote
2 answers

Run xmla file (Analysis Services) from command line

I'm looking for tool or a easy way to run xmla script (example for create or delete cube). I used to make exe file using Inno Setup program and there I can write command which can run another exe file just like in command line. I found that there is…
Monic
  • 726
  • 10
  • 31
1
vote
1 answer

How to get ascms.exe from ascmd.cs -.csproj and -.sln files?

I have downloaded Samples for MS SQL Server 2005 and I don't know how to get an .exe file from files like ascmd.sln, ascmd.cs, ascmd.csproj. When I'm trying to launch an .sln file in Visual Studio there is an error like: The application for project…
michal
1
vote
1 answer

sqlps Invoke-Ascmd Error Handling in ssas 2012

In SSAS 2012 Iam trying to use "sqlpls -C Invoke-ascmd -S server -i file.xmla" from command line for cube processing.%errorlevel% is 0 even if cube processing fails since sqlps executing succesfully.Can any one help me to understand how to do error…
rahnam
  • 13
  • 3
1
vote
2 answers

ASCMD for SQL Server 2012

Till now, I used ascmd to execute some queries to SSAS 2008R2. My company begin to install some new SSAS 2012 servers and I want to re-use all my maintenance scripts with these new servers. I can't find any ascmd tool in SQL Server 2012 neither any…
el_grom
  • 163
  • 1
  • 3
  • 15
0
votes
0 answers

how to run Invoke-ASCmd in Linux?

I'm running powershell command on a linux server, and I have powershell for linux as well as the SqlServer installed, but when I run Invoke-ASCmd I got Invoke-ASCmd: The term 'Invoke-ASCmd' is not recognized as a name of a cmdlet, function, script…
Nelson
  • 1