Oracle Business Intelligence

Products Banner

Issue in Multiple subject area cloud report

Received Response
1
Views
1
Comments

Hi All,

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

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?

Regards,

Chandra

Answers

  • 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.