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
Report generation with MDX views
-
Steve Rowe
- Site Admin
- Posts: 2464
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Report generation with MDX views
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Report generation with MDX views
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.
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.
Declan Rodger
-
declanr
- MVP
- Posts: 1831
- Joined: Mon Dec 05, 2011 11:51 am
- OLAP Product: Cognos TM1
- Version: PA2.0 and most of the old ones
- Excel Version: All of em
- Location: Manchester, United Kingdom
- Contact:
Re: Report generation with MDX views
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.
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.
Declan Rodger