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…

@Kamal Raj , Welcome to the Oracle Analytics Community! I do not think this question has anything to do with Oracle Analytics. You might be well served if you can put the question in Oracle Customer Connect. - Welcome to Cloud Customer Connect. Thanks

As per my experience, it is not necessary that if a feature is available in OAC, it will be available in FDI as well. Reason is FDI must stay aligned with Fusion application semantics. Fusion Applications store and process timestamps in application-defined time zones. It already apply time zone logic consistently across:…

@DeepaliG-Oracle , I do not think we can refresh it manually. If it is a static repository variable, it's value is initialized in the Variable dialog. The value of the static repository variable persists and doesn't change until an administrator decides to change it. For example, suppose you want to create an expression to…

@User_D0GY2 , this is where we need to raise SR with Oracle Support by providing all the logs.

@Alexandria Toothman-Oracle , Thanks for sharing the webinar, appreciate it.

Thanks for the update, I see this is closed as Duplicate, although this is the original one, other should have been closed as Duplicate.

Hi @Sophie Haller , Welcome to the Oracle Analytics Community! This forum was last updated more than 18 months back. I would suggest starting a new thread with as much details as possible. It will help the community to understand the issue with new perspective and making it easier to step in and help.

@Jae.L, what is the exact error message, please share. Thanks

Here is the community link - Inventory Management — Cloud Customer Connect. Hope it helps!

@User_FK99J , this is not the correct community to post this question. Please refer to the Oracle Cloud Customer Connect Community and someone should be able to help.

Hi @MudshaikhMub, Welcome to the Oracle Analytics Community! You can always reach out to Oracle Sales with your business email, and someone from Sales team will help. Here are the more details listed in this fusion al data platform website. Hope it helps!

@Daniel Ryan, thanks for creating the idea. Upvoted!