xml formatting

Nagaraj · Post by **Nagaraj** » Wed Mar 23, 2011 10:01 am

Hi Folks,

Can anyone tell me how do i define a Tag which would start and end in this way? Also it would be useful if i understand what it means

<measure-group ID="X">
</measure-group>

Thanks

eostic · Post by **eostic** » Wed Mar 23, 2011 10:15 am

Assuming you are talking about the xmlOutput Stage, the column carrying the value "X" for ID will have a Description property on the input link that looks like:

.../.../---for all the upper parts of the xml hierarchy---/measure-group/@ID

The xml metadata importer will generate that for you just fine if you import this particular attribute [ID] for your table def.

Ernie

Nagaraj · Post by **Nagaraj** » Wed Mar 23, 2011 12:47 pm

Ernie

No there is no column(ID) like that required, all they are looking for is the Tag should have those

<measure-group ID="X">
</measure-group>

when defining the tag on a particular column there is only one way of doing it,
how i can get it as above.

right now i am getting

<measure-group>
</measure-group>

Needed

<measure-group ID="X">
</measure-group>

Nagaraj · Post by **Nagaraj** » Wed Mar 23, 2011 1:39 pm

Had to write a post script to change it.
In the mean time you can tell me how to do it.

chulett · Post by **chulett** » Wed Mar 23, 2011 2:15 pm

He did.

Nagaraj · Post by **Nagaraj** » Wed Mar 23, 2011 2:30 pm

Perfect.......gr8 thanks ernie and Chulet.

now i will change the thread to resolved :D

eostic · Post by **eostic** » Wed Mar 23, 2011 3:21 pm

For the benefit of future readers, I may not have been explicit enough --- worst case you just create a fake column called "myID" and put the value "X" into it (in an upstream transformer), and then follow the instructions above. I'll assume that's what you did. ; )

Nagaraj · Post by **Nagaraj** » Thu Mar 24, 2011 10:48 pm

yes ernie thats what i did. marking this topic as resolved.