David Allan's posts have been a major part of making the OWB Blog a must-read for our users. Soon, though, he will be joined by more members of our development...
David Allan's posts have been a major part of making the OWB Blog a must-read for our users. Soon, though, he will be joined by more members of our development staff, who will be bringing you more how-tos and insights into OWB 11.2 features that help you get the most value out of the tool. The first of these should be up shortly-- keep an eye out for it.
David Allan's posts have been a major part of making the OWB Blog a must-read for our users. Soon, though, he will be joined by more members of our development staff, who will be bringing you...
As a quick follow up on my post on accessing SQL views in 11g OWB, here is a simple one if you are in SQL Dev or...
As a quick follow up on my post on accessing SQL views in 11g OWB, here is a simple one if you are in SQL Dev or SQL Plus:beginowbsys.wb_workspace_management.set_workspace('workspacename', 'workspaceowner');owbsys.start_enable_owb_roles;end;Replace the italics for workspacename and workspaceowner with the name of your workspace and the name of the owner (or user of) the workspace.Now you can do what you need in direct access tools like SQL Plus...
In OWB 11g the repository is a set of workspaces. In the public views this means you need to set the workspace context.This is not an issue from within a map as...
In OWB 11g the repository is a set of workspaces. In the public views this means you need to set the workspace context.This is not an issue from within a map as the workspace context is set prior to invoking the map as the map audit needs this. However in order to view data inside OWB using the public views it is necessary to have this set and as OWB creates the connection, the only solution is a logon trigger. This also applies if you are going into any system where you do...
In OWB 11g the repository is a set of workspaces. In the public views this means you need to set the workspace context.This is not an issue from within a map as the workspace context is set prior...
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...
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...
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...
We know people read this blog, and so we try to use it to disseminate helpful tips and tricks. But we hope to make this more than a one-way conversation with...
We know people read this blog, and so we try to use it to disseminate helpful tips and tricks. But we hope to make this more than a one-way conversation with our customers, current and potential. So occasionally, we'll post a raw idea here-- something for which we don't necessarily have a complete answer today. We want to know if these issues are really problems for you, and what you'd like to see done about them. When designing a report or other output based upon your...
We know people read this blog, and so we try to use it to disseminate helpful tips and tricks. But we hope to make this more than a one-way conversation with our customers, current and potential. So...
A number of the experts on the exchange use a series of UI extensions to provide shuttle and data entry controls. They are written in java but project a tcl...
A number of the experts on the exchange use a series of UI extensions to provide shuttle and data entry controls. They are written in java but project a tcl interface that makes them fairly straightforward to use. You may find them useful or you can use the same technique to construct your own.The UI extensions include:Capture data input in a table (oracle.owb.jexpert.DataEntryTable)Information selection and ordering (oracle.owb.jexpert.ShuttleObjects)Display info in...
A number of the experts on the exchange use a series of UI extensions to provide shuttle and data entry controls. They are written in java but project a tcl interface that makes them...
There are useful OMB APIs (see OMBDESCRIBE) to introspect the OWB model and query object definitions. They provide a useful insight when building accelerators....
There are useful OMB APIs (see OMBDESCRIBE) to introspect the OWB model and query object definitions. They provide a useful insight when building accelerators. I've used them for building a few things including the configuration experts on the exchange (slice and dice object/properties/configurations).So if you want to see the core properties of an object (for example TABLE) you can perform the following from within OMBPlus (or panel):OMBDESCRIBE CLASS_DEFINITION 'TABLE' GET ...
There are useful OMB APIs (see OMBDESCRIBE) to introspect the OWB model and query object definitions. They provide a useful insight when building accelerators. I've used them for building a few things...
Just noticed this script, which I think many people might not be aware of. Ok it is not something you would need every day, but in some cases you may find...
Just noticed this script, which I think many people might not be aware of. Ok it is not something you would need every day, but in some cases you may find yourself in need of it...In <OWB_HOME>/owb102/owb/misc you find 3 scripts:unregister_location.sqlwb_env_util.plbwb_env_util.pksThe only one you care about is the SQL one... Now use this only (like the script says) when you cannot get to the control center anymore. Say the database got deleted (runtime that is), but your...
Just noticed this script, which I think many people might not be aware of. Ok it is not something you would need every day, but in some cases you may find yourself in need of...
As a quick follow up thought on the Multi-config post from today, multi config can be a nice way to ensure moving MDL between systems (lets say dev -> prod) in...
As a quick follow up thought on the Multi-config post from today, multi config can be a nice way to ensure moving MDL between systems (lets say dev -> prod) in a simple way.First of, everyone should really script these "go to production procedures" so the operations staff can run a single command line file to "get the new version and deploy to the database". All of this is possible and yes we should write it up for all to use, but no time... it will come though, promise!So...
As a quick follow up thought on the Multi-config post from today, multi config can be a nice way to ensure moving MDL between systems (lets say dev -> prod) in a simple way.First of, everyone should...