cancel
Showing results for 
Search instead for 
Did you mean: 

How to enable the user options with VBA code in EPM report.

Former Member
0 Kudos

Hi,

    We like to enable the "Force Symmetric Refresh for Large Asymmetric Axis" selection in the user options for a particular report.

     Please suggest how to enable this option using VBA code in report.

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor
0 Kudos

Easy:

Manual:

"42.4.3.3 SetUserOption"

...

ForceSymetricQueryWhenNecessary

Vadim

Former Member
0 Kudos

Hi, Thanks for the quick reply, We like to enable this option using the VBA code , not with manual process.

Please suggest here.

former_member186338
Active Contributor
0 Kudos

Sorry, but you don't even look inside the manual!!! 42.4.3.3 SetUserOption - is about VBA API!

Dim epm As New FPMXLClient.EPMAddInAutomation

epm.SetUserOption("ForceSymetricQueryWhenNecessary", True)

Answers (0)