I have a scenario where I need to create a Policy diemension which will hold the policy nos as dimension members in Essbase.The company has floated huge no of policies in the market so we cannot take them as static data and put it in my application.
I want to design a mechanism that as data comes in for policy then that Policy no should get added in the Dimension as a member.So the step which I want should be:
1-Extract all the policy nos from the application
2- Compare it with the list of todays list of policy
3- If there are any new polciies then add it as dimension member
4- Now load the data.
Kindly guide me as how this can be achieved.