How to combine Purchasing Real Time and Requisitions Real Time subject areas in a single analysis?

Jose Renato Salvador

Is there a way to combine both subject areas? I need to create a report to analyze PO data and Requisition data. My goal is to find compute the time it takes from when a requisition line gets approved and the time the purchase order gets approved (PO Open Date).

gclampitt

Click on the "Add subject area" icon

Jose Renato Salvador

Hi Gclampitt,

I did that. First, I added Requisitions Real Time columns. After adding a Purchasing Real Time column it gives me this error.

gclampitt

hi the question in the post was how to combine SAs.

If you are getting an error - that is a different question.
Suggest you provide further details / sample XML etc and explain what you are trying to achieve

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/24591/how-to-combine-purchasing-real-time-and-requisitions-real-time-subject-areas-in-a-single-analysis

Hi @Jose Renato Salvador,

Please find below

Best Practices to combine the Multiple OTBI SAs:

• You should have common dimension in the subject areas used in the report.
• Add at least one Measure/Fact/Metric from each subject area on the report.
• Click on the Advance tab of the Analysis report --> Scroll down till you see Advance SQL clause --> Check the Dimensionality check box --> click on Apply SQL button. Go to the Results tab and test the results.
• Need to consider the lowest grain at which the Subject Areas built.
• More than one subject area reports are complex reports, make sure to apply proper filters on the report otherwise there might be performance impact.
• High level steps to debug the issue:
  • Create a simple report with one subject area and make sure it is returning data & working.
  • Remember to add as many dimension columns from first SA and add at least one measure.
  • Apply filters.
  • Add second subject area add required dimension columns and don't forget to add measure.

Hope this help.

Cheers,