Page 1 of 1

xml formatting

Posted: Wed Mar 23, 2011 10:01 am
by Nagaraj
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

Posted: Wed Mar 23, 2011 10:15 am
by eostic
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

Posted: Wed Mar 23, 2011 12:47 pm
by Nagaraj
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>

Posted: Wed Mar 23, 2011 1:39 pm
by Nagaraj
Had to write a post script to change it.
In the mean time you can tell me how to do it.

Posted: Wed Mar 23, 2011 2:15 pm
by chulett
He did.

Posted: Wed Mar 23, 2011 2:30 pm
by Nagaraj
Perfect.......gr8 thanks ernie and Chulet.

now i will change the thread to resolved :D :idea: :idea:

Posted: Wed Mar 23, 2011 3:21 pm
by eostic
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. ; )

Posted: Thu Mar 24, 2011 10:48 pm
by Nagaraj
yes ernie thats what i did. marking this topic as resolved.