TM1 Forum

Vijji wrote:Hello guys,

I was going through this post and referred to TM1 Reference Guide and then came across the following:

PublishView function cannot publish a private view that uses private subsets. All private subsets in a private view must first be published with the PublishSubset macro function.
Link: http://publib.boulder.ibm.com/infocente ... ubset.html

PS: Sorry, I haven't come up with a solution (I am new to TM1) but an observation

VPKR wrote:Hello
I have a requirement where i need to publish a private subset for public access. Since it is not supported through TI process, I need to do it through excel macros.
Can anyone please share me a simple macro to achieve this?

Thanks

TM1 reference guide wrote: PublishSubset
This is a TM1 macro function, valid only in Excel macros and VBA modules.
This function publishes a named private subset on a server.

If you attempt to publish a private subset for which an identically named public subset exists, you will be prompted to overwrite the existing public subset.

Syntax
PublishSubset(dimension, subset)

dimension
The server-prefixed name of the dimension containing the private subset you want to publish. For example, to publish a subset of the Region dimension on the Finance server, you would pass "Finance:Region" as the dimension argument.

subset
The name of the private subset you want to publish.

Application.Run "PublishSubset" "cxmd:Product" "Top10 SKUs"

lotsaram wrote:As in ....

Code: Select all

Application.Run "PublishSubset" "cxmd:Product" "Top10 SKUs"

What more do you need?

Application.Run "PublishSubset", "cxmd:Product", "Top10 SKUs"

VPKR wrote:Hi Lotsaram and Wim Gielis, thanks much for your help.
I created a private subset and i can even able to publish it with my user ID with admin access ( using the template i build using the macro button).

I still need experts assistence in below things:
1) I could not publish any private subset created by other users or even other non-admin users could not publish their private subsets.
2) Another puzzle i have is TM1 allows multiple users to create a private subset with the same name. In this case how does system know which user's private subset to be published?

Your help in this will be highly appreciated.