set POV for HFM form in a single click in smartview
Hi,
I am trying to set the POV of multiple HFM dataforms in smartview using a single click.
1) The user will enter the POV that should be used for all dataforms in an excel sheet summary: entity, year, period
2) the user will click a macro button that will apply the POV to all the smartview forms
I tried to use the VBA HypSetPages, but i do not know how to make the dimension member list dynamically read from excel.
Any help would be greatly appreciated!