OTBI Logical SQL complex query assembler - Updated to 10 subject areas

Anders W. Langholm

@Marybeth Snodgrass No, I resolved by creating the report in BI Publisher instead... ?

As far as I remember I tried to add it to a DB Prompt and create a dashboard, but still wasn't able to succeed.

Shjadhav

This is awesome.. Thanks

Sahil Makhiza

Hi Maxime Pignot-Oracle

Can you please attach the excel sheet here, not able to see the same.

Thanks in advance.

User_A7H10

Hi @Maxime Pignot-Oracle

Can you please provide spread sheet. Thanks in advance.

Maxime Pignot-Oracle

reposted a new V4 version supporting up to 10 logical SQLs, i had to default it to INNER JOIN to keep it simple.

Bhaskar Konar

Maxime Pignot-Oracle

Mar 6, 2025

reposted a new V4 version supporting up to 10 logical SQLs, i had to default it to INNER JOIN to keep it simple.

Thank you very much @Maxime Pignot-Oracle!

It'll be super helpful.

Nidhi Chhajed

Hi CA Nirmal Choudhary,

I have also created OTBI report using multiple subject areas. The report is giving correct data but in Criteria it says Invalid Subject Area.

Now I am stuck as I am not able to add prompt to dashboard. Example. I added the Prompt for Award Number nut data is not filtering after entering the award number.

Can someone please help me here.

Regards

Nidhi…

Maxime Pignot-Oracle

@Nidhi Chhajed , this is expected.

You WON'T be able to add new columns from this interface… or any interface at all. If you need an additional column, you have to add it to the query, no way around it, otherwise we wouldn't need the query builder.

Nidhi Chhajed

Hi Maxime Pignot-Oracle ,

I want to add filter for project and award. I created prompt to pass values to report. But that is not working.

How to use this report in Dashboard by using Prompt.

Regards

Nidhi

Nidhi Chhajed

Hi @CA Nirmal Choudhary ,

I have created cross subject OTBI report and in Criteria it says invalid subject area. The report is working fine however parameter / prompt is not working.

I made column as filter and created Dashboard column with same name. But It seems it is further searching to one level.

Example :

Project Number Prompt is not working , It seems it is searching for column filter "Project"."Project Number"

Any Idea will help as I am stuck on prompt part only

Regards

Nidhi…