Please go through my previous post that explains how to connect Essbase with Power BI using the Essbase (beta) connector, if you are getting your hands in the first time.

There is a request from the Essbase & Power BI community to provide an official connector for connecting Essbase from Power BI. It started exactly 4 years back and Microsoft was delaying it for long time. Finally on Nov 7, 2018 the request has been taken care and moved from under review to backlog status.
Few days back we got our first beta version of the connector as well, with a warning
Another big gap from the previous post. I was being busy in the budgetting acitivities (which started in last Mar), as usual there were many change requests, allocation logic changes, etc., occupied most of my time. The budget is officially over and 2 forecast cycles are passed. So, I am free for sometime.
Just wanted to share my experience, while setting up the inbuilt functions/formulas using SmartView.
I recently encountered with a requirement that the users should input data in the Planning Forms only for Valid Intersection. There’s an option to setup Valid Intersection in PBCS. But, the requirement is to setup the same on premises environment. You ask me how to do it in Microsoft Excel using VBA or Microsoft Access using SQL Query, I would do it very easily. But in Hyperion Planning, there’s no such option available inbuilt.