This content has been marked as final. Show 5 replies
Your question isn't entirely clear to me. Are you asking whether it's possible for (a) the content of the Planning form to change dynamically based upon the page member selection; (b) the calculation range to be limited based upon the page member selection; or (c) something else?
I am thinking of the first option a in Ur post.
Please let me know if there are any other ways too...I will choose what will fit best in my case.
Any thoughts on achieving this? please let me know
You can use user variables to make form content somewhat dynamic, but they've never served my needs very well, largely because it's not possible for users to set user variable values via Smart View. They have to log on to the Planning web to set values, then go back to Smart View and refresh their forms. I believe this has changed in 11.1.2 such that users can set variable values from Smart View.1 person found this helpful
If you're on 11.1.2, or if Smart View isn't a major factor for your situation, then look into user variables.
Hi,1 person found this helpful
Assuming you have locations* on rows and months and accounts* on columns for example, prepare and load below data for all entity-location combinations to essbase.
Entity Location Period Data
X4 Y2 BegBalance 1
X4 Y3 BegBalance 1
Make sure you load this to begbalance and a dummy account which I assume is not used in budget data collection.
Place Begbalance as the first column on the form. Check "Suppress Missing Block" selection from form edit menu.
Now whenever you change the entity from page, only associated locations should be visible in the form.