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