Oracle Analytics Cloud and Server

Products Banner

Maintain integrity in DIM/FACT WIDs

Received Response
51
Views
4
Comments

Summary

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

Content

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:

Answers