hi,friend, please have look:
I want to know, if I do:
dim tdatabase as Microsoft.AnalysisServices.database
' let tdatabase = someone existed on the server
tdatabase.update()
Will it cause the associated object be updated too ?
I mean, if I need NOT to do:
dsv.update()
dim.update()
cube.update()
measure.update()
and so on.
And, I can't find an update method on KPI. If that means I just need to update the cube object after I change a KPI object?
And, If I add/Remove a measure, need I do Process? Or just need to do Update?
Thanks!
 ivanchain wrote: |
| |
| I want to know, if I do: dim tdatabase as Microsoft.AnalysisServices.database ' let tdatabase = someone existed on the server tdatabase.update() Will it cause the associated object be updated too ? |
No it will not update all associated objects, see my next statment below.
| ivanchain wrote: |
| |
| I mean, if I need NOT to do: dsv.update() dim.update() cube.update() measure.update() and so on. |
The following is from this thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1842622&SiteID=1
Adrian Dumitrascu [MSFT]
The .Update() method only saves the minor properties and collections (thus not the major children) of an object. The major children are the AMO objects derived from the MajorObject class (Database, DataSource, Dimension, Cube, MeasureGroup, Partition, MiningStructure, MiningModel and others).
In our case, the database.Update() will save the database Name, ID, Description, Translations and other few minor properties, but won't save anything about the Role, which is a major object.
So you would need to call .Update on any major objects, so probably yes to dsv, dim, cube, but no to measure (I think a measure is a minor property of the measuregroup)
| ivanchain wrote: |
| |
| And, I can't find an update method on KPI. If that means I just need to update the cube object after I change a KPI object? And, If I add/Remove a measure, need I do Process? Or just need to do Update? |
If you add/remove a measure it will invalidate the cube structure, so once you do an update, your cube will be in an unprocessed state and you will need to process it.
|||
| ivanchain wrote: |
| |
| And, I can't find an update method on KPI. If that means I just need to update the cube object after I change a KPI object? |
Yes, you need to call .Update() on the parent Cube. The Update method is only available on major objects (the ones that can be created, changed and deleted by themselves on the Analysis Services server - in AMO they are derived from the MajorObject class). To add/modify/delete a minor object (like Kpi, Measure, DimensionAttribute, Hierarchy, Level) you need to call .Update() on the parent major object.
|||
Very clear answer!
Thank you!
