asked on

Powershell select and edit node

Hey

How do I select/Edit: <member key="1" operator="eq" /> under database "000 name" and "HR Huston" (need to change key from 1 to 2)

Using Powershell

<roles>
<role id="{1234}" name="Unit12">
<databases permission="allow">
<database name="000 Name" inherit="true">
<cube name="HR" inherit="true">
<dimension name="HR Huston" inherit="true">
<hierarchy name="HR Huston" inherit="true">
<forcedcriteria>
<member key="1" operator="eq" />
</forcedcriteria>
</hierarchy>
</dimension>
<dimension name="HR Boston" inherit="true">
<hierarchy name="HR Boston" inherit="true">
<forcedcriteria>
<member key="2" operator="eq" />
</forcedcriteria>
</hierarchy>
</dimension>
</cube>
</database>
</role>
</roles>

ste5an

Please rephrase your question. Add the code you have so far. Cause there are too many open questions, e.g. is that XML, where does it come from (file, variable or pipeline).. etc.

But: changing a key means deleting the old row and adding a new row. Keys should be stable and optimally static. So what is you use-case here?

ASKER CERTIFIED SOLUTION

oBdA

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial