Multiple subject area Issue in Cloud BI report

User_JL3CW

Summary

Unable to get the measure values of 2nd subject area

Content

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,

Shubham Chandra

 

 

Santhi Kiran Y

Hi there,

I am from HCM, what I feel is you need to use common things in both subject ares to bring the results. It is what we do in HCM, looking at your details, I am not sure if you have used such columns or measures. 

You can check this video to understand how it is handled - https://www.youtube.com/watch?v=-2h3a7F_19k&t=23s

I hope it may help you to resolve your issue.

Thanks,

Santhi Kiran

Vijaya Kumar-70229

Hi All,

For HCM , its successful module . When it goes for SCM we cant use multiple subject area for all the Scenario. In such case you have to go for the SET OPERATORS(UNION, UNION ALL). So that you can create OTBI report using multiple subject area.

Regards,

Vijay Subramani