Welcome to All Things Warehouse Builder

Modifying icons for process flow activities

Jean-Pierre Dijcks
Master Product Manager

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.


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:

Process Flow Activity RUN_SIS_JOB altered.
Process Flow LOAD_ORCL altered.

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


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.


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.

Join the discussion

Comments ( 2 )
  • R Bielstein Wednesday, July 23, 2008
    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?
  • Jean-Pierre Dijcks Thursday, July 24, 2008
    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...
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.