List of subsets created

Post Reply
ulla
Posts: 4
Joined: Thu Sep 24, 2009 9:15 am
OLAP Product: IBM Cognos TM1
Version: 9.1
Excel Version: 2007

List of subsets created

Post by ulla » Mon Mar 01, 2010 11:17 am

Hi,

has anyone an idea of how to get a list of subset-names that are created for a dimension? Is there a function in ti that can be used? Or a system cube where the information is held?

Thanks,

Ulla

kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: List of subsets created

Post by kpk » Mon Mar 01, 2010 12:40 pm

Hello,

As far as I know in TI you have only the SubsetExists(DimName, SubsetName); function.
But you are right it would be nice to have that kind of TI function and one also for retrieving the list of views.

One possible workaround could be the following:
The public subsets of a TM1 dimension are stored in one level below the main model directory (DataBaseDirectory=) in a DimensionName}subs directory.
You could write a small program to read the list of sub files from this directory and write the result into a TM1 object (e.g a dimension).
This kind of program can be started from TI process:
ExecuteCommand(CommandLine, Wait);

Regards,
Peter
Best Regards,
Peter

Wim Gielis
MVP
Posts: 2465
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

Re: List of subsets created

Post by Wim Gielis » Tue Mar 02, 2010 9:31 am

Hi Peter and ulla

The WildcardFileSearch function (http://publib.boulder.ibm.com/infocente ... earch.html) is perhaps the easiest, rather than batch files, or programming such searches in ExecuteCommand statements.

Wim
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

kpk
MVP
Posts: 214
Joined: Tue Nov 11, 2008 11:57 pm
OLAP Product: TM1, CX
Version: TM1 7x 8x 9x 10x CX 9.5 10.1
Excel Version: XP 2003 2007 2010
Location: Hungary

Re: List of subsets created

Post by kpk » Tue Mar 02, 2010 12:55 pm

Wim Gielis wrote: The WildcardFileSearch function (http://publib.boulder.ibm.com/infocente ... earch.html) is perhaps the easiest, rather than batch files, or programming such searches in ExecuteCommand statements.
Great idea! Thanks!
Best Regards,
Peter

User avatar
paulsimon
MVP
Posts: 755
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: List of subsets created

Post by paulsimon » Tue Mar 02, 2010 11:06 pm

To get a list of subsets, you can also use the API.

This allows you to get a list of both Public Subsets and Private Subsets for the current user.

There are third party tools that make using the API easier

Other than that, the only methods I know are the file search ones already listed.

Regards


Paul Simon

kalyan846
Posts: 18
Joined: Fri Mar 06, 2020 4:48 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: office 365

Re: List of subsets created

Post by kalyan846 » Wed Mar 25, 2020 12:58 pm

Hi,
In Architect, when you login to the instance
you will be seeing all the cubes and dimensions
click on the dimension which you want subsets for
and then click on displayed properties window
now on your right hand side you will be seeing all the subsets
just click on the first one and Ctrl+A will copy all the subsets
and you can past it where ever you want to :)

Hope this will help you out

kalyan846
Posts: 18
Joined: Fri Mar 06, 2020 4:48 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: office 365

Re: List of subsets created

Post by kalyan846 » Wed Mar 25, 2020 1:01 pm

i think ctrl+A doesn't work
click on first subset holding on shift click on the last subset
now all the subset will be selected

declanr
MVP
Posts: 1663
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: List of subsets created

Post by declanr » Wed Mar 25, 2020 10:01 pm

I can’t remember the exact version when it was introduced but for quite a while now there have been standard system dimensions that list all of the subsets for each dim and views for each cube.

The dimension name would be }subsets_<yourdimname> and it just contains all of the subset names as elements.
No need to search the data directory etc.
Declan Rodger

User avatar
orlando
Community Contributor
Posts: 131
Joined: Fri Aug 04, 2017 8:27 am
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365

Re: List of subsets created

Post by orlando » Thu Mar 26, 2020 7:26 am

declanr wrote:
Wed Mar 25, 2020 10:01 pm
I can’t remember the exact version when it was introduced but for quite a while now there have been standard system dimensions that list all of the subsets for each dim and views for each cube.

The dimension name would be }subsets_<yourdimname> and it just contains all of the subset names as elements.
No need to search the data directory etc.
These dimensions are a great help. Unfortunately only the public views and subsets are shown

Post Reply