You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can I synchronize POVs in two data input forms?

Summary:

I have a workbook with two worksheets. One worksheet has a data input form that is being used as a reference point ("Reference"), the other has a data input form that is being used for data submission "(Submission"). I want to be able to change POVs in the Submission form and have the same POVs selected in the Reference worksheet.

I understand I can get POV members from the Submission by using HypGetMembers function, and then set the same POVs in the Reference form by using HypSetPages function, but I may have a problem here.

My forms have valid intersection check functionality enabled. Say, I have a Country dimension that has members "France" and "Belgium", and I have a Product dimension that has members "Wine" and "Beer", and for simplicity purposes let's assume that in France they only drink wine, and in Belgium they only drink beer. If I switch from France/Wine combination to Belgium/Beer combination, then during the switch I will get France/Beer combination, which will be invalid, and the system will not allow me to do it. So, I'd have to clear selections first, before setting up new POVs, and if I try

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!