I have Dashboard Designer 4.0 FP3, SAP BPC 10.0 and SAP BI 7.3 in my system. I am trying to create a profit and loss dashboard using BPC cube.
so using the local connection, I can connect to the BPC cube and get the data in the dashboard and refresh the same with EPM Addin connection.
But there is no BPC hierarchy support with the local connection and also BPC planning data in not properly calculated with the local connection.
If I try to use the Web service connection for the BPC cube, it is not possible to refresh the data in the dashboard dynamically.
Is there any other way to have the hierarchy support with dynamic refresh option and the BPC data should be calculated properly?