Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Maintain integrity in DIM/FACT WIDs
Summary
Looking for the best way to maintain links/joins from DIM & FACT tablesContent
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?
Version
18 , Cloud / Data-Sync 2.6
Tagged:
0