@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!

@Branden Pavell, thanks for creating the idea. Upvoted!

Upvoted!

@ianm.americold , thanks for the idea. Yes, there is a gap, hope it get enough votes.

Good to see it is Under Review.