Secondary India ledger with (4/4/5) calendar for reporting
There are two ledgers -
US Ledger (Common COA, USD, 4/4/5 CAL(e.g. 3/27/20 - 4/26/20), US AM)
India Ledger (Common COA, INR, Monthly CAL (4/1/20-4/30/20), IND AM)
We pull all data in OBIEE and report the data in US calendar by weekly segregation.
The issue is, the india data show in different weeks, since the calendar periods are different.
So, we decided to create a secondary india ledger with US calendar (4/4/5) and push the india primary ledger details to this secondary ledger.
This is only for reporting purpose. we are not going to use this secondary ledger for any other purpose.