Hi,

the new XML/A commands to create a cube etc are good.
but where can I found references and sample to use it???

I have a large number of actions and KPI to create and to deploy to multiple
servers.
So I want to create the XML/A script myself without going into Visual
Studio and creating the new content here.

how to do this?
any sample?
any reference?

thanks.

Jerome.

Hi,
I'm writting some initial ideas, I don't know exactly how much you want to
automate outside Visual Studio.

1. If you want to create many kpis and actions and you don't want to use the
user interface from Visual Studio, then you can right click on the cube item
(in the BI project from Visual Studio) and use 'View Code'; this will allow
you to copy-paste-edit the xml for kpis and actions. But if you want to do
all this programatically, then you can use AMO (if needed, we'll exchange
new messages about how to use it).

2. Once you have all the kpis and actions created, you mentioned you want to
deploy on multiple servers. Will all these servers have the exact same cube
? Or they have slightly different cubes, but with the same kpis and actions
you created ?

3. If the multiple servers will contain the same cube, then you can do this:
- deploy the cube/database on a AS2005 server (no need to process it, just
deploy the meta-data, there is an option in the BI project properties)
- connect with SQL Management Studio, right click on the cube item and use
'Script as Create/Alter'
- the resulting script can be run on different AS2005 servers automatically
with a DTS task or with AMO

4. If the multiple servers will contain slightly different cubes, but with
the same kpis and actions, then you need to use AMO; because there isn't an
XML/A command to save just a Kpi, you will need to save the cube in order to
save its Kpis (in other words, Kpi is a minor object, cannot be saved by
himself).

Adrian Dumitrascu.



"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote