Currency Conversion PBCS ASO cube
PBCS application has 2 BSO plan types and 1 ASO plan type. Custom calculations are run in BSO cube via business rules and data is pushed to ASO plan type for reporting using data push feature. Year by year BSO plan type cube size is growing. So to reduce BSO plan type size, thinking to push Local currency data to ASO plan type and run currency conversions in ASO cube directly.
I have tried setting up a member formula on Currency/USD dimension member but it's not keeping the formula even after save and cube refresh.
Any suggestions would be much appreciated.
Tagged:
0