Forum Discussion
Helper IPower BI question with using Essbase
Hello,
I am using the essbase connector to pull the data such as Net income which requires multiple filters to get the data I need. I am able to visualize the values in a table but I want to be able to run some basic calculations such as Current Sales/Forecasted budget. Is there any way to get a value out table visualization?
Thank you in advance,
Daniel
So direct query will not work with Essbase and being able to make measures. I was able to pull what I need via the import method. Thanks for the help!
3 Replies
- amitchandak
Super User
Daniel48 , Connect all the tables with common date table/ dimension tables and analyze together
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bdaPower BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
Daniel48Hi I am using the Essbase connector and pulling the data via DirectQuery. I am unsure how filter as there are levels for some of the dimensions that are out there. I can not create a table or calculated column due to this link. So the video was not able to help
I would need it to say something like Fiscal Year 2023, ledger.level 1 is LOCAL, Periods.level 2 is January and February
- Daniel48
So direct query will not work with Essbase and being able to make measures. I was able to pull what I need via the import method. Thanks for the help!
