You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Did You Know? Use OTBI to find database tables and columns that hold transactional data

Announcement
123
Views
4
Comments

Whilst OTBI is the primary tool for transactional reporting, you sometimes need to know which database tables/columns hold specific transactional data e.g. when you create a bespoke data model for BI Publisher reporting/data extracts. In such circumstances you can use the following technique to find database those tables and columns.

To employ this technique you'll need:-

  • BI Administrator privileges.
  • The business objects you are interested in to be modelled in an existing OTBI subject area.

Let's explore an example where we want to know the database table and column that holds the description property of action items

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!