Modifying icons for process flow activities

I would guess many people are using user defined activities in process flow. As do we when we do partner work. Wouldn't it be nice if you could change the icons for the user defined activities to better show what is being done in that activity? In some cases it might be, and it is quite simple to do.

First step is to create an iconset. You do this in the Global Explorer under icon sets. Here is an example of the completed dialog.

IconSetScreen:

Next is to actually associate this iconset with the process flow activity. For mappings this can be done within the UI, but for process flow activities this is done via scripting:

OMB+> OMBALTER PROCESS_FLOW 'LOAD_ORCL' MODIFY ACTIVITY 'RUN_SIS_JOB' SET REFERENCE ICONSET 'STARANALYTICS'
Process Flow Activity RUN_SIS_JOB altered.
Process Flow LOAD_ORCL altered.
OMB+>

After this you get a wonderful icon reflecting the actual external job you are calling.

ProcessFlowWithIconReplaced:

If you want to show separate icons on the mappings, here is how you do that. It is on the properties panel and it will change the icon in the design center.

ChangedMapIcons:

Now of course you are wondering what Star Analytics is. Well, this is a company / product that allows you to re-integrate your Essbase data back into the relational data warehouse. It handles the extraction from Essbase, in this case into Oracle base tables. You then run the OWB mappings to load the data into the Oracle data warehouse. Quite cool if you need to integrate for example finance data back into the EDW.

Comments:

Can you tell me what are the main benefit's of Star Analytics SIS product and how has this application benefitted your organisation? Did you consider any other tools / approaches to extraction of your Essbase data and metadata?

Posted by R Bielstein on July 23, 2008 at 02:10 PM PDT #

Hi, Remember we are part of the OWB development team and we are trying to solve a problem for our customers. That said, I think the nice thing about SIS is the knowledge it has about Essbase. You can work in an outline and pick and choose the exact information out of Essbase you want. It all is very familiar to the Essbase audience. The tool also moves calculated measures as real data points across, so you don't have to re-code those calculations in your data warehouse. All in all it seems all very straightforward to the Essbase administrator, and with the large number of possible export formats, you can easily use a tool like OWB to move it into the Oracle warehouse. Hope that helps a bit...

Posted by Jean-Pierre Dijcks on July 24, 2008 at 02:49 AM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed
About

ETL, CDC, Real-Time DI and Data Quality for the Oracle Database from the inside.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today