dbTalk Databases Forums  

AS2005: Script commands sample needed to update actions, kpis...

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss AS2005: Script commands sample needed to update actions, kpis... in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default AS2005: Script commands sample needed to update actions, kpis... - 08-22-2006 , 11:09 AM






Hi,

I want to use the scripting capability of AS2005 to manage some part of my
cubes like the KPIs and Actions.

But how to update only 1 action by script?
(I mean without generating an alter script in managment studio, then
removing what we don't want to update etc...)

there is not enough info on the web around these scripting capability.

I want something like:
<Alter ObjectExpansion="ExpandFull"
xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">

<Object>

<DatabaseID>my DB ID</DatabaseID>

<CubeID>my cube id</CubeID>

<ActionID>my action id</ActionID>

</Object>

<ObjectDefinition>

<Action>

< new action definition here >

</Action>

<ObjectDefinition>

</Alter>



but this script failed because the <ActionID> cannot be a child of <Object>,
but where is the list of authorized child object?

where I can found more information around the scripting options?

or does it better to create AMO based code?



thanks.



Jerome.





Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.