This discussion provides an approach for a scenario where a custom schema needs to be created specifically for Finance users in a multi-pillar subscription.
Blog Link : https://blogs.oracle.com/analytics/post/fdi-custom-schema--finance-erp-analytics
Very helpful & informative.
The sample code from the blog is very useful too.
Thank you very much @Abhishek Bajpai - CEAL Team-Oracle!
@Bhaskar Konar Thanks for all the motivation and good words