Andreas Nobbmann

writing about Oracle Business Intelligence, Hyperion, IBM DB2, IBM Data Warehouse Edition and hopefully more

SA System subject area

Once upon a time I implemented the SA system subject area ....... I have to admit for the first time I followed one post from Venkat. And then I can remember discussing this in Brighton with Benjamin and John. Next in my memory is a mail and then ....

So, because somebody wanted the SA system subject area I would like to post it here. But to make it more challenging I post the UDML code, nothing else makes sense. You know "Scripting with OBIEE is fun !", so I hope you'll have exactly this with this little geeky piece of code.

Perhaps it would be a good idea to make a little introduction: the SA system subject area is an Oracle standard to define some default settings for the Delivers part of OBIEE. For example the default mail-adress, the language, the delivery profile etc. can be set using it.

But now let's start. Here are some screenshots, only an excerpt of the different layers.

The physical layer:

image 
(click here for Download as a UDML-file)

The Business model:

image
(click here for Download as UDML-file)

The presentation layer:

image
(click here for Download as UDML-file)

If you are facing problems with it post a comment and we'll sort it out together, OK ? Have fun !

BTW: replace YourDataSource, YourUser and YourPassword with your credential information in the UDML for the physical layer. And pleaSE plEASE PLEASE do a backup before trying anything, OK ? It is for your own safety. The "OBIEE-elders" Alex and Christian had their reasons when they said: "Don't let kids touch this one!" and "Don't try this at home".

So long,
Andreas

Kommentare

@lex sagte:

Thanks for the hat tip (and the "elder" ;-) and

please

please

please

www.youtube.com/watch

have a nice day

@lex

# Oktober 27, 2009 10:01

@drian sagte:

Christian, An Elder, but he looks 12!

Now Andreas I have a challenge for you and your 'scripting is fun'.  

Question is, are you up to it?

# November 3, 2009 10:17

Andreas Nobbmann sagte:

Hi Adrian,

yeah, of course, I am up to it.

Hear you soon and so long,

Andreas

# November 3, 2009 12:04

Henrik Nielsen sagte:

Hi, thanks for a good blog - one question: do you know if the user changes settings such as locale or language in the My Account page, will this information be stored in the SA_SYSTEM table?

# November 9, 2009 1:26

Andreas Nobbmann sagte:

Hi Henrik,

thanks !

No, as far as I know the values are not stored in the SA_SYSTEM tables. In contrary the SA system subject area values replace the settings the user has done. I think at least for language and locale.

Have a good one and so long,

Andreas

# November 12, 2009 12:07

Christian sagte:

> Christian, An Elder, but he looks 12!

What the heck? Watch it,mate! ;-)

# November 16, 2009 10:50
Kommentar abgeben

(verpflichtend) 

(verpflichtend) 

(optional)

(verpflichtend)