I have a xml file is from the Microsoft SQL Server Analysis project which is a ssas cube file within Visual Studios. Ok so I need to set the visibilty property to 0 on many cube measures. SO I wanted to ask and check is it possible to do this via a xml script or some code because manually it will take a long time and I have to run it a few times.

here is the structure that I want to search for and turn off
small sample of file

<MdxScripts>
<MdxScript dwd:design-time-name="db366bed-0340-45a0-831a-a23fcd70f010">
<ID>MdxScript</ID>
<Name>MdxScript</Name>
<CreatedTimestamp>2012-10-12T14:54:06.916667Z</CreatedTimestamp>
<LastSchemaUpdate>2012-12-04T20:57:56.973333Z</LastSchemaUpdate>
<Commands>
<Command>
<Text>/*
The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit THIS command only if you manually specify how the cube is aggregated.
*/
CALCULATE;



CREATE MEMBER CURRENTCUBE.[Measures].[Test] as
[Dim Test Teams].[Tester Staff].[All].Children.Count,
Visible=1,DISPLAY_FOLDER = 'Test\Tester';


CREATE MEMBER CURRENTCUBE.[Measures].[Time] as
[Measures].[base Time Counter]
,FORMAT_STRING="#,###"
, VISIBLE=1,DISPLAY_FOLDER = 'Time';

</MdxScript>
</MdxScripts>


So I want to set VISIBLE=0 for every "Create member" statement that is in a list that I have listed in a file(file could be csv, exel, etc.). The list is a list of measures we no longer need in the Cube.

Any thoughts on how to do this?