I know that we can use PublishView to publish a named private view on the server but it only works with native view. Is there a way for a non-admin user to create a view in Workspace (MDX) and then publish it so another non-admin user can see it in PAX ? We would also want to use views created by non-admin user in PAW and publicly query them thought REST API.
Thanks
Publish MDX views
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Publish MDX views
Hi
I can't say that I have tried it but if you take the MDX from the view, you should be able to pass that as a parameter to a TI process and then that can create a public MDX view.
Probably easier to automate if the view is created in PAX rather than PAW. If created in PAW you would probably need the Rest API to get it.
Regards
Paul Simon
I can't say that I have tried it but if you take the MDX from the view, you should be able to pass that as a parameter to a TI process and then that can create a public MDX view.
Probably easier to automate if the view is created in PAX rather than PAW. If created in PAW you would probably need the Rest API to get it.
Regards
Paul Simon
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Publish MDX views
Or save that view and open it it in PAFE to retrieve the associated MDX ?
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Publish MDX views
Hi Wim
While what you say is true, I somehow doubt that a user is going to want to save a view in PAW, then open it in PAX, extract the MDX and paste it into the parameter area of a TI process which will then run to create the MDX view.
I am guessing that the original poster already has something that lets an end-user publish a private native view with the click of an Action Button which runs a TI process to publish the view.
I was therefore assuming that they would want something equally automated for an MDX view, either using the VBA API in PAX or the REST API in PAW.
Regards
Paul Simon
While what you say is true, I somehow doubt that a user is going to want to save a view in PAW, then open it in PAX, extract the MDX and paste it into the parameter area of a TI process which will then run to create the MDX view.
I am guessing that the original poster already has something that lets an end-user publish a private native view with the click of an Action Button which runs a TI process to publish the view.
I was therefore assuming that they would want something equally automated for an MDX view, either using the VBA API in PAX or the REST API in PAW.
Regards
Paul Simon
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Publish MDX views
I agree Paulpaulsimon wrote: ↑Tue Jul 27, 2021 9:14 pm Hi Wim
While what you say is true, I somehow doubt that a user is going to want to save a view in PAW, then open it in PAX, extract the MDX and paste it into the parameter area of a TI process which will then run to create the MDX view.
I am guessing that the original poster already has something that lets an end-user publish a private native view with the click of an Action Button which runs a TI process to publish the view.
I was therefore assuming that they would want something equally automated for an MDX view, either using the VBA API in PAX or the REST API in PAW.
Regards
Paul Simon
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 1817
- 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: Publish MDX views
In terms of users being able to share views between PAW and PAX.
If the user has an "Analyst" role in PAW and edit access to a PAW folder, they can save a view within the PAW folder structure.
That view can then be opened by any user who has access to the same folder in both PAW and PAX.
To open it in PAX they need to click the "View" button in the ribbon and it brings up the same folder structure as PAW from the content store.
If the user has an "Analyst" role in PAW and edit access to a PAW folder, they can save a view within the PAW folder structure.
That view can then be opened by any user who has access to the same folder in both PAW and PAX.
To open it in PAX they need to click the "View" button in the ribbon and it brings up the same folder structure as PAW from the content store.
Declan Rodger
-
- Posts: 139
- Joined: Tue May 21, 2019 3:33 pm
- OLAP Product: TM1
- Version: PA 2.0.x
- Excel Version: 2016
- Location: The Internet
Re: Publish MDX views
Thanks everyone for your answers, it gives me a lot of idea. My next question would be; is there an "easy" way to convert MDX view to Native view? I know we can use tm1py to convert native view to MDX but I was wondering if the opposite is possible ?
-
- MVP
- Posts: 1817
- 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: Publish MDX views
There are things that you can do in an MDX view which are not possible in a traditional view. As such there would be no method to convert the view which would be guaranteed to work 100% of the time.Emixam wrote: ↑Fri Aug 06, 2021 3:39 pm Thanks everyone for your answers, it gives me a lot of idea. My next question would be; is there an "easy" way to convert MDX view to Native view? I know we can use tm1py to convert native view to MDX but I was wondering if the opposite is possible ?
Declan Rodger
-
- Posts: 139
- Joined: Tue May 21, 2019 3:33 pm
- OLAP Product: TM1
- Version: PA 2.0.x
- Excel Version: 2016
- Location: The Internet
Re: Publish MDX views
That's what I thought when I looked at the .xbv file.
Thanks !
Thanks !