Not often, but some users may need to change the global settings of the EPM Add-in. To do this, navigate to
the installation directory and locate the file FPMClient.dll.config.
In order to change these values, you will need to open up Notepad and choose to run as administrator.
Within this file, you will see the following:
Example of global change:
When trying to return a large number of dimension members in a report, you may encounter an MDX error or a
splash screen stating you have requested too many tuples. The default is 150,000 but this may need to be
increased. To change this value, update the parameter LimitAmountAxisTupleInAxis.
Remember, if any parameters are changed, you will need to exit out of Excel and start it again