Making a private dimension subset public

[ChrisF79]

Greetings:

I have a coworker that is not an admin and made a subset in one of the dimensions. He saved that subset and asked me to make it public. I'd like to but I don't see it. Is there a way I can make a user's subset public?

Thanks

[Alan Kirk]

I have a coworker that is not an admin and made a subset in one of the dimensions. He saved that subset and asked me to make it public. I'd like to but I don't see it. Is there a way I can make a user's subset public?

If this is a one-off the easiest way is to log off, copy the .sub file from the user's folder (which will be something like \UserName\DimName}subs) into your own folder in the data directory, then when you log in it'll appear as one of your private subsets. You can then right click on it in the subset list and select Publish.

[ChrisF79]

That will work well. Thanks!

[kpk]

I have a coworker that is not an admin and made a subset in one of the dimensions. He saved that subset and asked me to make it public. I'd like to but I don't see it. Is there a way I can make a user's subset public?

If this is a one-off the easiest way is to log off, copy the .sub file from the user's folder (which will be something like \UserName\DimName}subs) into your own folder in the data directory, then when you log in it'll appear as one of your private subsets. You can then right click on it in the subset list and select Publish.

If you copy the subset this way you have to restart the server in order to see it as your own private.
Using this approach you can copy the subset directly into the Database\DimName}subs folder and see it immeditately as a public subset (after restart).

If you want to avoid the server restart then try to use the PublishSubset(dimension, subset) function.

[Alan Kirk]

I have a coworker that is not an admin and made a subset in one of the dimensions. He saved that subset and asked me to make it public. I'd like to but I don't see it. Is there a way I can make a user's subset public?

If this is a one-off the easiest way is to log off, copy the .sub file from the user's folder (which will be something like \UserName\DimName}subs) into your own folder in the data directory, then when you log in it'll appear as one of your private subsets. You can then right click on it in the subset list and select Publish.

If you copy the subset this way you have to restart the server in order to see it as your own private.

I assure you, you don't.

Go ahead and try it.

Private views and subsets seem to be read in on demand (ie when the user logs on), unlike public ones.

[kpk]

I assure you, you don't.

Go ahead and try it.

Private views and subsets seem to be read in on demand (ie when the user logs on), unlike public ones.

Wow! That really works.
Thanks!

[Gregor Koch]

Hi

I agree with Alan, if it is a once off just use the "File - Copy - Bounce - Server" approach.

But...
Although the private subsets might not be in memory they are still stored as .sub files in the users folder. Hence if you know the user name, dimension name and subset name you know where to look for the .sub file. You can use the file as source and by fiddling with the '270,x' section (which lists the elements of the subset) of that file and do a 'simple' SubsetCreate (SubsetExists check, SubsetElementInsert etc) and you are good to go.
Yep, a whole lot of coding and you can take it to the extend of checking for a dynamic subset, but it beats restarting the server if you have to do it every month, week or day.

Cheers