Sunday, August 2, 2009

OBIEE UDML and Notepad

Sometimes you are using a trick for such a long time, you automatically suspect the whole world to know it. As you might know the internal communication protocol for the BI-server is UDML. A simple way of getting the UDML for a column is doing a CTRL-C of the column and pasting it into a text editor like notepad:

image

image

How can an RPD developer make use of this feature? Well the trick also works the other way around. If you need to make a lot of variations of column (FI: if you need to make TimeSeries variations for all you measures) simple do some clever Find and Replace (CTRL-H) in the notepad copy.

image

Select and copy it from notepad.

image

And paste it back in the RPD.

image

This can save you literally hours of tedious clicking in the RPD.

Till Next Time

No comments: