Hi Team, I would like to understand how you are managing the Entity
changes on a monthly basis. For eg: the Entity name in 2021 M6 is
San_Jose_213 and it is changed to SFO_213 in 2021 M7. If I choose the
rename option, then 2021M6 cube data will over...
Hi Michel, thanks for your response. Yes, we identified your proposed
solution couple of weeks back and we have started the setup to achieve
the same. Only hindrance we see in RCM where system showing entity name
from entity dimension. Seems we need ...
Hi Celvin,But there is a hindrance in your suggested approach. We have
built certain historical views which will allow top management to see
the trended data something like Last Qtr vs Current Qtr. In such case,
till M6 data is sitting in San_Jose_21...
Hi Sai,Thanks for your reply. Your suggestion won’t work in my case.Let
me explain with an example.Parent Entity - SFOChild Entities - SFO_210;
SFO_211 and San_Jose_213.Business users performed Account Reconciliation
till 2021M6 under the entity name...
Hi Nicole,Thanks for your explanation. We are using custom tables to
store additional attributes in the system periodically for our business
needs. We have built dashboards on top of the cube views.Business
requirement is that historical data should ...