1

Topic: SSAS XMA the code of creation of a DB to receive from the project automatically

Good afternoon all.
SSAS 2014
As under project SSAS to receive the code xmla DB creations
At  I see in bin Files
asdatabase
deploymentoptions
deploymenttargets
configsettings
Is Deploymnet wizard -  xmla in a manual mode.
Whether it is possible to receive xmla automatically (for simplicity - the most simple case  a DB from zero)?

2

Re: SSAS XMA the code of creation of a DB to receive from the project automatically

Probably incorrectly formulated the finite task
The purpose -  process  AS DB with CI  (Jenkins) or another
M. probably it to make through ms-build without formation xmla?

3

Re: SSAS XMA the code of creation of a DB to receive from the project automatically

Gulin Feodor;
From the description operation modes Deployment Wizard.
It is possible to launch in Answer mode, when  GUI and on your input -  configuration files, for the further usage. It is possible to launch in Silent mode - then it  the project according to a configuration. It is possible - in Output mode - then it  xmla a file which to you will need to be executed something.
At me at first becomes XMLA a file which is copied in  protocol. Then start in Silent mode becomes - which rolls changes. People do it for a production environment , that is process is automated and alienated.
That is important -  at stage Answer mode files better thoughtfully to clean. The reason - there is a lot of determinations, in particular, storage locations for measurements and measures, etc. I had problems when added new measurement, and in  by default answer mode its config was not, and it not .

4

Re: SSAS XMA the code of creation of a DB to receive from the project automatically

Ferdipux wrote:

Gulin Feodor;
From the description operation modes Deployment Wizard.
It is possible to launch in Answer mode, when  GUI and on your input -  configuration files, for the further usage. It is possible to launch in Silent mode - then it  the project according to a configuration. It is possible - in Output mode - then it  xmla a file which to you will need to be executed something.
At me at first becomes XMLA a file which is copied in  protocol. Then start in Silent mode becomes - which rolls changes. People do it for a production environment , that is process is automated and alienated.
That is important -  at stage Answer mode files better thoughtfully to clean. The reason - there is a lot of determinations, in particular, storage locations for measurements and measures, etc. I had problems when added new measurement, and in  by default answer mode its config was not, and it not .

Microsoft.AnalysisServices.Deployment.exe OLAP.asdatabase /s:d1.log/o:d1.xmla
THANKS - that that are necessary - created  through/a
And a file xmla through/o
And  xmla the File for  is rolled as?
(ps1: Invoke-ASCmd
Ascmd (At me while   for MS 14 project))
And in what all it becomes (bat the File) and whence and as it is launched
(I ask that  best-praktis without inventing a bicycle)

5

Re: SSAS XMA the code of creation of a DB to receive from the project automatically

Gulin Feodor;
Silent mode rolls the project without necessity creation to feed ready XMLA a file. It is caused so (example).
Microsoft.AnalysisServices.Deployment.exe. \CUBE\PROJ.ASDATABASE /s:Proj_diff.log

6

Re: SSAS XMA the code of creation of a DB to receive from the project automatically

Ferdipux wrote:

Gulin Feodor;
Silent mode rolls the project without necessity creation to feed ready XMLA a file. It is caused so (example).
Microsoft.AnalysisServices.Deployment.exe. \CUBE\PROJ.ASDATABASE /s:Proj_diff.log

Microsoft.AnalysisServices.Deployment.exe OLAP.asdatabase /s:d1_silent.log
Truth  in OLAP.configsettings was necessary to hands to add
For login to a DB at me goes under SQL  but it is a trifle

7

Re: SSAS XMA the code of creation of a DB to receive from the project automatically

Ferdipux;
If to not difficult steam of words is more detailed about:
And in what all it becomes (bat the File) and whence and as it is launched
(I ask that  best-praktis without inventing a bicycle)