Oracle Business Intelligence

Products Banner

Issue in Multiple subject area cloud report

Received Response

Hi All,

I am working on Procurement subject areas in cloud BI version is

Report Requirement: Report should display total amount spent on different categories with or without Blanket Purchase Agreement

This is required to built with two subject areas

1. Procurement - Purchasing Real Time

2. Procurement - Purchasing Agreements Real Time

I pulled in Category name, Purchase order number, Item description, Source Agreement, Purchase Order Distribution Amount (Received Amount) from 1st Subject Area.

I Pulled Agreement number, Agreed Amount and Released Amount measures from 2nd subject area.

The report is not displaying the 2nd subject area measures properly.

How to solve this problem?




  • 3319067 wrote:The report is not displaying the 2nd subject area measures properly.

    If by that means that they are returned as NULL, then that means the measures from "Procurement - Purchasing Agreements Real Time" do not have properly set content levels for their parent fact's logical table sources. I.e. the non-conformed dimensionality can't be resolved.

    So an RPD fix is in order.

    Or you can try to cheat by using SET VARIABLE ENABLE_DIMENSIONALITY=1; but that's just a way to eliminate symptoms and not the root of the issue.