Yes, absolutely. Would not have even responded if I'd read it more closely. It suits me to just delete the extraneous posts.Wim Gielis wrote: ↑Wed Jan 06, 2021 8:02 pmWe both think Steve’s reply is already what the OP needs![]()
Search found 468 matches
- Wed Jan 06, 2021 9:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem With Slow process execution when Selecting child Elements and a single consolidated Element
- Replies: 6
- Views: 244
Re: Problem With Slow process execution when Selecting child Elements and a single consolidated Element
- Wed Jan 06, 2021 8:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem With Slow process execution when Selecting child Elements and a single consolidated Element
- Replies: 6
- Views: 244
Re: Problem With Slow process execution when Selecting child Elements and a single consolidated Element
We have seen performance of MDX views vs. standard/classic views to be poor. Looking at your MDX code, it does not appear you are using alternate hierarchies, so building a classic view should not be a problem. I would suggest trying that. I believe the performance problem is directly related to wh...
- Wed Jan 06, 2021 4:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem With Slow process execution when Selecting child Elements and a single consolidated Element
- Replies: 6
- Views: 244
Re: Problem With Slow process execution when Selecting child Elements and a single consolidated Element
We have seen performance of MDX views vs. standard/classic views to be poor. Looking at your MDX code, it does not appear you are using alternate hierarchies, so building a classic view should not be a problem. I would suggest trying that. I believe the performance problem is directly related to wha...
- Mon Jan 04, 2021 1:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 application validation error on approval hierarchy
- Replies: 1
- Views: 299
Re: TM1 application validation error on approval hierarchy
To list the elements of an element something like the following is a simple approach in a TI: dimApprovalHier = 'dimName'; sComponentElementName = 'MyChildElement'; sOutputFile = 'ListOfParents.txt'; nParents = ELPARN(dimApprovalHier, i = 1; While (i <= nParents); sParent = ELPAR(dimApprovalHier, sC...
- Wed Dec 23, 2020 3:56 pm
- Forum: General
- Topic: For anyone who has been depressed by the train wreck that was 2020...
- Replies: 4
- Views: 470
Re: For anyone who has been depressed by the train wreck that was 2020...
Merry Christmas to All!
And my most fervent wishes for a very Happy New Year!!!
And very heartfelt adieu to 2020. May we never see the likes of you again.
And my most fervent wishes for a very Happy New Year!!!
And very heartfelt adieu to 2020. May we never see the likes of you again.
- Thu Dec 10, 2020 1:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Will IBM ever convert Perspectives to use the Rest API?
- Replies: 6
- Views: 489
Re: Will IBM ever convert Perspectives to use the Rest API?
I literally laughed out loud at this. And, in a coincidence, watched the movie with Trevor Howard and Sir John Geilgud this past weekend. Howard was over the top.
- Wed Dec 09, 2020 11:30 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Order in an MDX cube view as datasource
- Replies: 13
- Views: 4126
Re: Dimension Order in an MDX cube view as datasource
Do you have a direct line to Stuart King on this issue? I do not have a direct line to Stuart King. As a contractor, I have to pass my findings/issues through regular staff, but they are knowledgeable and the firm has a substantial relationship with IBM. I can't fathom why IBM seems to insist that ...
- Tue Dec 08, 2020 8:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut on MDX views
- Replies: 4
- Views: 714
Re: ViewZeroOut on MDX views
FWIW, and I have not had time to test, we think it may be centered around the measure dimension elements being cleared cannot be in an alternate hierarchy.
- Tue Dec 08, 2020 8:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with IF...ENDIF and assigning a value to a variable
- Replies: 4
- Views: 284
Re: Problem with IF...ENDIF and assigning a value to a variable
Or don't use parameters at all and read the values directly from the control cubes in the TI concerned....This problem would then disappear. IMO if you have the parameter for a TI in a control cube then parameterising the TI is redundant and adds complexity. Alternatively treat all parameters as st...
- Tue Dec 08, 2020 8:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Order in an MDX cube view as datasource
- Replies: 13
- Views: 4126
Re: Dimension Order in an MDX cube view as datasource
Update. We have noticed a possible pattern with regards to output order not matching dimension order when reading an MDX cube view: We are observing the output order is by: 1) dimensions that are based on the default hierarchy (dimname:dimname) then regular dimension order. 2) dimensions where the M...
- Tue Nov 24, 2020 8:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with IF...ENDIF and assigning a value to a variable
- Replies: 4
- Views: 284
Re: Problem with IF...ENDIF and assigning a value to a variable
Tom, Agreed. Here is what I was really trying to do: IF (nNumberOfParams = 1); ExecuteProcess(sProcess, CellGetS(cubProcessControl, sProcess, '0', 'ParamName'), IF(SUBST(CellGetS(cubProcessControl, sProcess, '0', 'ParamName'), 2, 1) @= 'S', CellGetS(cubProcessControl, sProcess, '0', 'ParamSValue'), ...
- Tue Nov 24, 2020 4:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remove duplicate elements from the subset
- Replies: 7
- Views: 506
Re: Remove duplicate elements from the subset
TM1TupleSize maybe? This code will return the unique leaf elements of the subset: TM1FilterByLevel(FILTER( [pProduct].[pProductSubset], TM1TupleSize(INTERSECT([pProduct].[pProductSubset], {[pProduct].currentmember}, ALL).item(1)) = 0), 0) To find those that exist at least twice: TM1FilterByLevel(FIL...
- Tue Nov 24, 2020 3:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: zerout view
- Replies: 3
- Views: 245
Re: zerout view
stiill the same error : vDimension='Invoiced Partners'; vSourceSubset=vDimension| ' All N'; vMdx= '{TM1FILTERBYLEVEL( {TM1SUBSETALL( [Invoiced Partners] )}, 0)}'; if(SubsetExists(vDimension,vSourceSubset)=0); SubsetCreate(vDimension,vSourceSubset); Else; SubsetDeleteAllElements(vdimension,vSourceSu...
- Tue Nov 24, 2020 3:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with IF...ENDIF and assigning a value to a variable
- Replies: 4
- Views: 284
Problem with IF...ENDIF and assigning a value to a variable
I want to assign either a string or numeric value to a variable depending on a conditional test. I am somewhat surprised TM1 complains about this code reporting that vS: invalid numeric expression when trying to save the TI. vParam = 'pnDebug'; vtest = IF(SUBST(vParam, 2, 1) @= 'S', 1, 0); vN = Cell...
- Thu Nov 12, 2020 6:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with Feeder Processing in PA
- Replies: 13
- Views: 688
Re: Problem with Feeder Processing in PA
Thanks, Steve. Yes, it appears to be that dimension only.Steve Rowe wrote: ↑Thu Nov 12, 2020 5:13 pmThanks Ty, great work on narrowing this down and reporting back. Pretty challenging space to work in...
I'm assuming it is the last dimension in the built order rather than a re-ordered to last dimension?
- Thu Nov 12, 2020 4:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule for internal cell ref and alternate hierarchies
- Replies: 1
- Views: 745
Re: Rule for internal cell ref and alternate hierarchies
Have not tested, but suspect this may be related to the feeder problem related to alternate hierarchies on the last dimension in a cube.
viewtopic.php?f=3&t=15576
viewtopic.php?f=3&t=15576
- Thu Nov 12, 2020 4:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with Feeder Processing in PA
- Replies: 13
- Views: 688
Re: Problem with Feeder Processing in PA
Once last comment. It appears that alternate hierarchies on dimensions other than the measure (or last) dimension in the cube do not break shorthand multiple target feeders.
Add an alternate hierarchy to the measure dimension, however, and feeders will have to be examined. We have submitted to IBM.
Add an alternate hierarchy to the measure dimension, however, and feeders will have to be examined. We have submitted to IBM.
- Thu Nov 12, 2020 3:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with Feeder Processing in PA
- Replies: 13
- Views: 688
Re: Problem with Feeder Processing in PA
Additional information with more testing to come: In the initial testing, the dimensions involved had alternate hierarchies. In the second round of testing with the feeders working as expected, the dimensions did not. Added an alternate hierarchy to the measure dimension with a single leaf element. ...
- Tue Nov 10, 2020 5:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Problem with Feeder Processing in PA
- Replies: 13
- Views: 688
Re: Problem with Feeder Processing in PA
Well. Today, everything I described above as failing is now feeding correctly. One of the other team members was investigating this further and reported the problems were no longer appearing. Multiple targets, shorthand notation, chain feeder (A => B => C) and (A => B => C, D): all working. MTFeeder...
- Mon Nov 09, 2020 10:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Time period Dimension
- Replies: 9
- Views: 643
Re: Time period Dimension
I haven't tested this, nor do I say it's intuitive and needed and easy, but if we do a DimensionDeleteAllElements and insert them back in the correct sequence - I *think* this could work. I believe you are correct in your thinking. As long as all the dimension changes occur in the prolog and METADA...