Post reply

XML for Analysis alter statement problem

  • July 21, 2008 at 9:18 am

    #125019

    I am still relatively new to XMLA, so forgive me please if there is a simple solution to this problem that I have missed.

    I am trying to develop an XMLA script that will allow me to alter a dimension, in order to add a new attribute, on an existing data base.

    The dimension is used by two cubes on the data base.

    If I create the alter scripts for each object individually then I get errors when trying to run them.

    The only way that I have been able to effect the change on the dimension was to create an alter script for the entire database.

    I tried to get clever and edited the script to contain only the cubes and the dimension in question, but that removed all the other objects on the data base. Now I think I'll just stop and ask for directions...

    Is it possible to create a script that will only alter a couple of the objects on the database, and if so, does anyone know where I can look at some good examples of this sort of script.

    Thanks in advance,

    Richard

  • July 21, 2008 at 2:35 pm

    #846015

    Hey Richard,

    Take a read through this, in particular the section on 'Using the ObjectExpansion attribute'. I think what you're looking for is to set it to 'ObjectProperties', as 'EXpandFull' will perform the delete as you've described.

    HTH,

    Steve.

  • July 22, 2008 at 2:53 am

    #846230

    Hi Steve,

    Thanks for your response.

    I had previously tried the "ObjectProperties" option when processing the dimension by itself and had discarded it as it didn't work.

    This is what I have done now:

    1. I scripted the entire database to create an ALTER script. The following is the first line of the script to show the options that I set:

    2. I edited the database in VS to remove the new attribute from the dimension so that I could test the script to see if it would create it.

    3. I edited the alter script to contain only the dimension that I am changing and the two cubes that reference the dimension. I removed all the other dimensions and cubes as well as the data source and data source view nodes.

    4. I ran the script and it completed successfully, but the new attribute was not added to the dimension.

    If I read the comments on the link that mentioned correctly then the "ObjectProperties" option affects only the major objects and not the minor objects. At this point I am thinking that the dimension's attribute must be a minor object and as such I have to use "ExpandFull" in order to change it. This would then also mean that I have to have all of the database objects in the alter script.

    Is there something else that I am missing?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply