Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Maintain integrity in DIM/FACT WIDs — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Maintain integrity in DIM/FACT WIDs

Received Response
edited Sep 11, 2019 5:18AM in Oracle Analytics 5 comments


Looking for the best way to maintain links/joins from DIM & FACT tables


All DIM tables have a Warehouse ID number (WID).  Joins are added to the Target FACT tables to link said DIM table in Data-Sync.  When/If changes (Add/Drop) columns or refreshing data back to initial load status are done.  This resets these WIDs.  This in-turn breaks the links within the report designer and can cause the lose of the visualizer report.

How can we keep this from happening?


Oracle Analytics Cloud Data Sync (2.6) / OAAC

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!