Hello:
We are in the process of upgrading to BPC 10.0 NW .
I’m running into a requirement that was fairly easy to accomplish in 7.5, but I don’t know how to do it in version 10. The requirement is to be able to filter data based upon user selections in the context for 3 different dimensions i.e. Entity (Fund Center), Account (Cmmt Item) and Fund (user defined). However, we only want to send data based upon 2 of the dimensions (Fund Center and Cmmt Item), while the 3rd (Fund) should be sending data based upon a property of Fund Center. Every Fund Center has only 1 fund and is represented by a property of the fund center, but the fund is also a dimension. The reason we did it this way is because if you allow expansion based upon 3 different dimensions, then we have a lot of possible Fund Center, Cmmt Item and Fund combinations that shouldn’t happen. The only possible combinations should be Fund Center and Cmmt Item while the Fund is always directly related to the Fund Center.
For example, Fund Center 99999-110 has a fund of 110. No other data should ever be saved to any other fund, so it doesn’t make sense to include Fund in the expansion. Using a linked property of the Fund to Fund Center, works great when we send the data. However, if the user wants to restrict which funds are retrieved by altering the context (I’m using epmcontextmember() for this), adjusting the context will not restrict which funds are retrieved since we did a linked property for the row expansion of fund. This means that if a department is wanting to retrieve all of their fund centers, but doesn’t want to see a certain set of funds, then that requirement is not possible doing it this way. Alternatively, as already stated above, using BAS members of fund would allow more combinations than should be allowed. I've tried a few things using axis override as well, but haven't had much success.
We did this in BPC 7.5 by creating 2 EVDREs. One that would expand based upon only 2 dimensions (FC and CI) and the 2nd EVDRE would be responsible for sending the data to all 3 dimensions by using an EVPRO function to retrieve the fund from the fund center. How can we accomplish this in BPC 10? Please see attachments for illustrations.
Any help is greatly appreciated. Thanks
Edit: I have also thought about hiding the "extra" rows with VBA and using EPMSaveData to save the data to the correct intersections. I would like to avoid those 2 fixes if possible.