I was looking over internet trying to find a SP or UDF
to replace string accourences in the Text fields, I didn't
find any so I created ths trigger, may be it will be usefull as example. Be aware on the big documents it can be time consuming.
All it does is replacing < and > substrings of the encoded exml document when it is inserted to the database to the characters.
If somebody have better solution for this please let me know.
In this lesson, we will introduce a function that provides us the ability to derive a set by systematically applying a set expression to each of the members of a set we define. GENERATE() is a potent function in our MDX toolset, in that it enables us to select precisely only certain members of a dimension level. It effectively operates upon two sets to create a new set, based upon the members of a second set that are also in a primary set.