TM1 API: evoking subset editor screen

Post Reply
fcapell
Posts: 11
Joined: Wed Jun 13, 2012 6:46 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2007
Location: São Paulo, Brazil

TM1 API: evoking subset editor screen

Post by fcapell »

Hi Everyone!

I have a C# Application and I need to provide a way for the user select a dimension element.

Is there a way to evoke the TM1 subset editor screen from a C# application?

Thanks,

Fausto
winsonlee
Regular Participant
Posts: 180
Joined: Thu Jul 01, 2010 3:06 am
OLAP Product: Cognos Express
Version: 9.5
Excel Version: 2007
Location: Melbourne, Australia

Re: TM1 API: evoking subset editor screen

Post by winsonlee »

Have you tried the following code?

mySubsets = myServer.Dimensions[dimension_name].PublicSubsets;
sSubset = mySubsets[subset_name];
User avatar
Harvey
Community Contributor
Posts: 236
Joined: Mon Aug 04, 2008 4:43 am
OLAP Product: PA, TM1, CX, Palo
Version: TM1 8.3 onwards
Excel Version: 2003 onwards
Contact:

Re: TM1 API: evoking subset editor screen

Post by Harvey »

Hi Fausto.

I work with the API a lot, and I seriously doubt it. There may be a way to hack into the COM dlls in the TM1 program folder, but it's certainly not a supported behavior.

I would suggest writing a dialog in your application that contains a .NET TreeView control and populating that with the dimension elements you wish to select from. If the dimension is particularly large, you'll need to make sure you implement some sort of paging.

This is really how the API is intended to be used. It does not contain any UI elements, just provides you with access to read and modify all the data structures in the TM1 server.

I have written a full subset editor in C# in the past and it is complex, but not too hard if it's read-only.

Good luck!
Take your TM1 experience to the next level - TM1Innovators.net
Post Reply