Oracle Fusion #38: OTBI Report using two subject Area

[@MohamedLabidi-hd1rz]

Thank you, Naresh, for the great video! The errors that pop up when using multi-subject areas is very common in analysis creation. Most of us would like to know the cause and how to address it.

[@TechTalkwithNaresh]

@Mohamed Share the screenshot of error and other details on [e-mail]. I will review and prepare new video with alternative process or some resolution.

[@MohamedLabidi-hd1rz]

@@TechTalkwithNaresh I have sent you screenshots and details of this specific issue. Thank you!

[@Felipe_Matheus_1991]

Hello, firstly thanks for the great video. I want to know, how can I make a subquery within a column, I need that it come back a aggregate value from correlate sub query. Is it possible?

[@TechTalkwithNaresh]

@User I have to check this, will let you know.

[@sumit4170]

Excellent💯

[@TechTalkwithNaresh]

@Sumit Thanks... Subscribe to get latest updates.

[@mariaxydopoulou3537]

Hello and than you for your video. I'm facing a problem regarding Requisition Recruiter filter in OTBI dashboard. Starting from the first tab of the dashboard, named Requisitions (SA: Recruiting Real Time), we give this filter a value and we take the data. Moving on to the next tab, named Applications (SA: Recruiting Real Time), the value we gave in the filter remains so we can immediately see the next set of corresponding data. The issue arises when moving to the next tabs, named Inactive Applications, where the filter doesn’t retain its value and the user needs to input it again manually. I have the same behavior for Person Type filter. Can this be relate with the fact that Inactive Applications belong to a different subject area (Recruiting Events Real Time)? Or is it something else? Am I missing something? Thank you!

[@TechTalkwithNaresh]

Hi Maria, It is bit difficult to understand the issue, can you elaborate more.

[@mariaxydopoulou3537]

@@TechTalkwithNaresh I have a Dashboard with the following analysis (tabs) called: 1. Requisitions (SA:Recruiting Real Time) 2. Applications (SA:Recruiting Real Time) 3. Inactive Applications (SA:Recruiting Events Real Time) For all of these analysis I have created some prompts. One of them is for the Recruiter Full Name. So, when I'm analysis 1. and I select a value for the Recruiter Full Name filter, it gives me back the required result. Same will happened If I'll just click to navigate to the second analysis. Although, for the third analysis, the value does not remain and I have to manually selected again. I don't know if still my explanation is enough.... thank you

[@TechTalkwithNaresh]

@Maria I got your point, but I won't face such situation any time. Please check all same condition for the second and third prompt or not.

[@kishorekk42481]

Please make a video on creating OTBI analysis for PO life cycle..with just few columns of PO number, PO amount, Shipped amount, Receipt amount, invoiced amount..

[@TechTalkwithNaresh]

@kishore I will try to upload asap.

[@mdbashoeb]

Hello Naresh can you please make analysis report using two subject areas from receivables which fetch transaction and receipts

[@TechTalkwithNaresh]

@KB I will Try to upload asap. Subscribe to get latest updates.

[@mdbashoeb]

@@TechTalkwithNaresh Done 👍

[@mdbashoeb]

Hello Mr. Naresh any update on my request

[@TechTalkwithNaresh]

@KB I had video based on 2 Subject area in my playlist. Go through the playlist for more details.

[@mdbashoeb]

@@TechTalkwithNaresh thanks for your prompt response Mr. Naresh however I can't make fetch data using two subject area for receivable specially for standard receipt and transaction with details such as invoice and payment details together.

[@sailarakesh9373]

Hello Naresh, when I attempted to retrieve data from two subject areas, I encountered an error message from the ODBC driver: 'Error during query processing (SQLExecDirectW).' Could you please provide the join conditions for these two subject areas? The subject areas are as follows: Procurement - Purchasing (Real-time) Procurement - Requisitions (Real-time) Please explain how to join them.

[@TechTalkwithNaresh]

@Sailarakesh Can you check on Oracle Support, you will able to get it. If any issues feel free to revert.

[@sailarakesh9373]

@@TechTalkwithNaresh I have already checked Oracle Support, but I can't find the issue. Please help me....

[@southgoogling1275]

Hi Naresh, I am able to add the two columns from two different subject area but not able to get the output from subject area . I am Getting this Error "State: HY000. Code: 14081. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - AR Payment Terms.Payment Terms". please help me in this matter.

[@TechTalkwithNaresh]

@South Googling Which column you are removing I didn't get that please write in detail. You can write on [e-mail].

[@karthikkumar5462]

Same subject areas i tried but in result data not showing.. Any Reason?

[@TechTalkwithNaresh]

@Karthik The user which you are using won't have the role to view the data for the subject area.

[@karthikkumar5462]

@@TechTalkwithNaresh ok Thanks, also I am using Two subject areas Receivables-Customer Real Time and Supplier-Supplier Real Time. But i am getting the Error : [nQSError: 14025] No fact table exists at the requested level of detail can u help me on this

[@bobbyjourdan7075]

Hi Naresh, i thought that to be able to use 2 subject areas you should use measurement columns from both subject areas. Here you use measurement from only one of the subject areas. So is it possible?

[@TechTalkwithNaresh]

@Bobby if you are going by first appearance which I explained it is ok to use it once, but if you are using second approach you have to take it from both the subject are for join condition.