we have observed that "Name_" column from "ASDIM_WC_GROUPSP_0" (dimension table for Spaces) for an "ID" from "ASFACT_WC_GROUPSP_0" (Fact table for Space) is getting updated automatically. All other columns remain the same ( example the DESCRIPTION_ ,ICONURL_) for that specific ID.
we have written a query to find the portal metrics (name of user,portal accessed by user, and last accessed on), In the result of this query we observe that the entry for "Webcenter Portal" (name coming from "ASDIM_WC_GROUPSP_0") which has its unique ID from "ASFACT_WC_GROUPSP_0" is getting updated to "Home Portal" , "Webcenter Portal"and to the name of our Custom Portal.
Why are these names getting changed for one unique id ? How does "ASDIM_WC_GROUPSP_0" capture data ? Why is it capturing name of Custom Portal.