Hi,
I have a team implementing SAP BI for a banking project. A production error highlighted that there were loops in the universe returning wrong values and therefore the implementing team created aliases for 2 dimensions to correct for this issue.
When asked the team said that if we have new reporting requirement using same dimensions we may need to create additional aliases for the same dimensions and so the more the reporting requirement grow the more we may create aliases. The aliases could expand exponentially. Does this seem right practice? Cant we reuse the same dimensions like we do in other data warehhouse practices?
so DIM_CURRENCY has Alias_of_DIM_CURRENCY and Alias_of_DIM_CURRENCY1 and Alias_of_DIM_CURRENCY2 ...
Does it make sense?
Thanks