Page 1 of 1
Subset Name given View and Dimension Name
Posted: Thu Sep 20, 2018 3:26 pm
by My24
Hi all,
I searched dimension and subset manipulation functions of TI but I cannot find a function to retrieve a subset name given view and dimension name. I guess a TI process trick can give the subset name given these two arguments. Is there a solution to this problem?
Regards.
Re: Subset Name given View and Dimension Name
Posted: Thu Sep 20, 2018 3:36 pm
by Wim Gielis
Hello,
This is indeed tricky. There is no such function. You could:
- use code (TI, VB, Java, ...) to inspect the *.vue file (public or private view ?)
- use the TM1 REST API (or similar), which can give you the layout of a view. This is advanced stuff, I cannot give you working code examples.
For the first part, I posted a generic process on the forum to do these kinds of manipulations.
Note that a view is not obliged to use a subset, it could also be a selection of elements that is not contained in a subset.
Re: Subset Name given View and Dimension Name
Posted: Thu Sep 20, 2018 7:50 pm
by My24
Wim Gielis wrote: ↑Thu Sep 20, 2018 3:36 pm
Hello,
This is indeed tricky. There is no such function. You could:
- use code (TI, VB, Java, ...) to inspect the *.vue file (public or private view ?)
- use the TM1 REST API (or similar), which can give you the layout of a view. This is advanced stuff, I cannot give you working code examples.
For the first part, I posted a generic process on the forum to do these kinds of manipulations.
Note that a view is not obliged to use a subset, it could also be a selection of elements that is not contained in a subset.
Thanks Wim. I follow you in your website and forum and I am very thankful for your contributions.
Where is the link of your generic process, I could not find it.
And also if anyone has a code for the problem, please post a message in here.
Re: Subset Name given View and Dimension Name
Posted: Thu Sep 20, 2018 10:05 pm
by Wim Gielis
The 7th topic in the 'Useful code, tips and tricks' subforum:
http://www.tm1forum.com/viewtopic.php?f=21&t=13723