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
TM1 API: evoking subset editor screen
-
- 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
Have you tried the following code?
mySubsets = myServer.Dimensions[dimension_name].PublicSubsets;
sSubset = mySubsets[subset_name];
mySubsets = myServer.Dimensions[dimension_name].PublicSubsets;
sSubset = mySubsets[subset_name];
- 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
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!
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