Is it possible to create a named calculation via .xmla

Hi all,

I want to create a named calculation for a Data Source View in SSMS via .xlma script. Frankly, I want to create a dozen of them, that's why I want to use a script.

I created one named calculation in Data Tools. Then went to SSMS, Script Data Source As -> ALTER To.

But I can't find any single character about named calculation! Isn't it exposed to SSMS? Does it exist only on the Data Tools level and, correspondingly, calculations are being made

March 28th, 2015 6:51am

Use SQLCMD.EXE that comes with SQL Server.  You can create batch files that will perform your queries without opening SSSMS.  Run very quick because SQLCMD.EXE is designed to archive data from the SQL Server.
Free Windows Admin Tool Kit Click here and download it now
March 28th, 2015 7:36am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics