@Rakesh Chhoria-Oracle , Nice one!

@ManikSethi , very impressive, nice going. Keep it up!

@Jaydeep Puranik-Oracle @Abdul R Shaik-Oracle, very impressive, thanks for sharing!

@diego m schenquerman , Welcome to the Oracle Analytics Community! This is a very generic requirement and lots of information is already available. Nice thing about is that it can be done in the Sandbox and then can be published once you are happy with the configuration. Here is the latest oracle doc that has a very nice…

@Srikar Pusuluri , I just confirmed these indeed belong to Inventory and as far as the Consumption Advice Report is concerned, it basically used in the scheduled process. It is used to create consumption advices from consigned inventory-related transactions. When to Use A consumption advice is a periodic summary report of…

@Srikar Pusuluri , Welcome to the Oracle Analytics Community! These reports are located under Shared Folders/Supply Chain Management / Warehouse Operations/ Inventory. Please confirm.

Also, this forum is specifically for the Oracle Analytics, OTBI, BIP, FDI etc in terms of tools and it is okay to ask questions which are more related to the tools/technology etc, you should put the question in the Oracle Customer Connect for the Fusion Product related functionality. For example, in terms of Payables,…

@Arnab Das , Welcome to the Oracle Analytics Community! As mentioned above there is a definitely limit in terms of maximum rows as well as there are few ideas already logged to increase it. In terms of the issue reported, it will be best to debug it and understand that there are few options how to triage it. I am going to…

Actually, I have a question about CEAL team, how is it different from Oracle Analytics Product team?

@Archana Singh , Thanks for providing the opportunity to get the answers!

Upvoted!

@Anitha Ramarao-Oracle , very well-organized, thanks for sharing. Appreciate all the effort you have put in this workbook.

Hi @TrevorM , Welcome to the Oracle Analytics Community and asking the question in the forum. OTBI subject areas can only be combined if Oracle has defined conformed dimensions between them. In your case, looks like there is no common dimension in terms of Project Number from Procurement – Purchasing Real Time with…

@User_WJ43I , I am glad to see it worked for you. Appreciate if we can document the changes here, it will definitely help someone in the future. Thanks

Yes, hope it works for you.

@User_WJ43I, sure, let us know how it goes. Also, as per community guidelines, please mark the Answer as Accepted Answer so that it can be easier for community members to find replies that might help them in a similar situation. Thanks

@User_WJ43I , If I understood the question, the underlying issue is that your revenue fact at project level is being joined to task-level hierarchies, and when you join both facts using project_id+task_id, project-level revenue rows don’t have tasks to join, so the outer join fails. For this implementation you can try…

@Doug Ross , @SharonAtGorilla , this forum was last actively looked in July 2024. I would suggest starting a new thread with as much as details possible about your requirement. Thanks

As a workaround, if you don’t need a custom dataset (no joins, transforms, snapshots): Build the workbook directly on the OTBI subject area Let environment-specific OTBI connections handle themselves This avoids the dataset layer entirely and migrations become much cleaner.

@User_WJ43I , In OAC, custom datasets are tightly bound to the data connection they were created with (in your case, the OTBI connection in SIT). When you migrate a workbook: The workbook migrates cleanly The dataset migrates cleanly But the dataset keeps the original OTBI connection ID, not just the name So when the…