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

OTBI - Can We Use the Same Subject Area Twice in a Single Analysis?

in Enterprise Contracts

Summary:

Hi,

We are modifying the seeded "Related Contracts By a Contract Number" OTBI analysis.

The analysis currently uses the Enterprise Contracts - Contract Real Time subject area and returns information about the Contract Number and Releated Contract Number and its relationship. However, we need to display additional details for the related contract such as the Contract Start Date, Contract End Date, Supplier etc. These attributes are not available in the Related Contracts folder.

Can the same OTBI subject area be used twice within a single analysis (similar to a self-join) so that the Related Contract Number can be used to retrieve additional attributes? In other words, can we use the Enterprise Contracts - Contract Real Time once for the primary contract and a second time for the related contract within the same OTBI analysis?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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