In this video tutorial, you’ll learn how to use aliases in Oracle Analytics Cloud (OAC) to resolve missing data connections and restore workbook functionality. When a dataset is deleted or access is revoked, workbooks that depend on it may no longer display data. By assigning an alias to a replacement dataset, you can reconnect your workbook without rebuilding it.
In this tutorial, you’ll learn how to:
- Identify missing dataset connections that prevent workbook visualizations from displaying.
- Locate and copy the original dataset's unique object ID from the workbook error message.
- Create a replacement dataset with the same structure as the original dataset.
- Assign an alias to the replacement dataset using the original dataset's object ID.
- Verify that the workbook successfully retrieves data and displays its visualizations.
- Explore how aliases can also be used with database connections and subject areas.
Using aliases helps maintain workbook continuity when underlying data sources change, reducing the need to recreate existing analytics content. Watch the full video tutorial to see how to restore a missing dataset connection in Oracle Analytics Cloud.
For additional guidance, explore the Oracle Help Center documentation to learn how to copy a dataset's Object ID and add an alias to support legacy references.
Continue building your Oracle Analytics Cloud skills with self-paced training and additional resources in the Oracle Analytics and AI Learning Hub. You can also explore the Video Tutorial Playlists page to find step-by-step tutorials organized by product and task.