TM1 Forum

Hi,
I think the answer is no but...
With an active form I can change the MDX being used to generate the row headers in a very dynamic way.

For exploration, quick and custom reports there is the VBA CreateFromMDX method available.

I've a strong preference for not using VBA as it traps any front end development in Excel and blocks me off from TM1 Web and or PAW.

From what I can see there is no way to interact with the MDX definition of a Quick or Exploration report in Excel (without resorting to VBA) in the same way as I can with a dynamic form.

Anyone want to point me in the right direction?

TIA, Steve

I have an "MDX" option just above "Design Mode" in PaFE when I am in an exploration view.
I assume that this has only appeared because I have enabled the ENABLE_EDIT_MDX_VIEW="true" configuration option on the PAW server.


Just going to hijak a bit to add that my first steps when doing a PAW install at the moment are to enable the 2 settings below:
ENABLE_EDIT_MDX_VIEW="true"
ENABLE_VIEW_EXCHANGE="true"

The first enables the MDX view editor in PAW (and PaFE by the sounds of it.)
And the second allows you to share views between PAW and PaFE using the content store.

Hopefully both of these will be enabled by default in the future as I can't think of any reason that you wouldn't want them.

Ignore the above; you still need to do that to get it in PAW.

But I have checked PaFE against a PAW server that does not have MDX views enabled and I still have the option in PaFE so I guess its just something that has been added on a more recent release than what you are working with. The 2 machines where I have it working; one is definitely PaFE 49 but I think the other is still on 45.