Check to see if an element exists with in a subset
-
- Posts: 90
- Joined: Tue Aug 19, 2008 4:56 pm
Check to see if an element exists with in a subset
If there a way to see if a element exists with in a dimension subset while running a Turbo integrator process? I am trying to create a dynamic subsets based on transaction outputs into a flat file.
-
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Check to see if an element exists with in a subset
Not sure that I see the connection between sentence 1 and sentence 2 there, but regardless the short answer is that there's no direct way of doing it since there's no "SubIx" function. Nor is there ever likely to be, even if someone takes the time to submit a business case for it, because Iboglix wouldn't be able to incorporate something like that into a fast paced multimedia presentation extravaganza with brightly coloured dashboard objects. That of course seems to be the primary criterion for getting new features implemented.cdhodge2002 wrote:If there a way to see if a element exists with in a dimension subset while running a Turbo integrator process? I am trying to create a dynamic subsets based on transaction outputs into a flat file.
The longer answer is that you'd need to iterate through the subset using the SubSiz and SubNm functions and a While loop to do to the check.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.