Search found 286 matches

by PavoGa
Thu Feb 14, 2019 8:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 260

Re: How to get top parent of an element ?

macsir wrote:
Thu Feb 14, 2019 8:25 pm
Yes, you are right. My query is not right. Anyway, learnt how to use TM1TupleSize functon. :P
Good deal! Glad I could help.
by PavoGa
Thu Feb 14, 2019 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 260

Re: How to get top parent of an element ?

I thought you were trying to find the top or root level consolidations for a given leaf element. The MDX queries you state as simpler specifically reference a consolidation ('d') according to the example you provided while I thought you were interested in determining ancestors of a leaf element. I b...
by PavoGa
Wed Feb 13, 2019 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 260

Re: How to get top parent of an element ?

This returns ALL the ancestors of 'e':

Code: Select all

FILTER( EXCEPT(TM1SUBSETALL([test_ANC]), TM1FILTERBYLEVEL(TM1SUBSETALL([test_ANC]), 0)), 
    TM1TupleSize(INTERSECT({[test_ANC].[e]}, DESCENDANTS({[test_ANC].currentmember})).item(0)) > 0)
by PavoGa
Wed Feb 13, 2019 12:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get top parent of an element ?
Replies: 12
Views: 260

Re: How to get top parent of an element ?

This will do it: FILTER( FILTER( TM1SUBSETALL([test_ANC]), [test_ANC].currentmember.parent.name = ''), TM1TupleSize(INTERSECT({[test_ANC].[e]}, DESCENDANTS({[test_ANC].currentmember})).item(0)) > 0) This assumes we are looking for all the top level consolidations of 'e'. And this: FILTER( FILTER( TM...
by PavoGa
Mon Feb 11, 2019 1:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 7
Views: 276

Re: MDX StrToMember Error

StrToMember(" [Site].[ "+[}ElementAttributes_Project].([}ElementAttributes_Project].[Primary Site])+"]") In your call to [}ElementAttributes_Project], the code is missing a reference to [Project] so it cannot find the desired intersection; it is just calling the measure [Primary Site]. I think you ...
by PavoGa
Fri Feb 08, 2019 1:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sorting consolidations dynamically
Replies: 4
Views: 115

Re: Sorting consolidations dynamically

If you can use subsets to control display, use a numeric attribute to control the display order.

Otherwise, as Tom states, you have to set dimensionsortorder to ByInput and then carefully control how objects are added.
by PavoGa
Thu Feb 07, 2019 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 10
Views: 167

Re: TM1 Server crash on saving dimension (status Suspended)

Thank you, Steve. When I get a chance, I'll try it again.
by PavoGa
Thu Feb 07, 2019 5:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 10
Views: 167

Re: TM1 Server crash on saving dimension (status Suspended)

Steve Rowe wrote:
Thu Feb 07, 2019 4:50 pm
Hi PavoGa,

What's your version number please? Did you get this acknowledged by IBM?

Cheers,
Yes, we did. PA 2.0.05
by PavoGa
Thu Feb 07, 2019 3:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Server crash on saving dimension (status Suspended)
Replies: 10
Views: 167

Re: TM1 Server crash on saving dimension (status Suspended)

Hi Ken, We had the same thing and were able to isolate at least one cause which was 100% repeatable. When loading data, if there is an element that does not exist in a dimension, we add that element to a consolidation called "Unregistered" to deal with later. If that consolidation is the first eleme...
by PavoGa
Tue Feb 05, 2019 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for getting Parent and Children
Replies: 17
Views: 210

Re: MDX for getting Parent and Children

This will get you the one level down including the target:

Code: Select all

TM1DRILLDOWNMEMBER( {[test2].[c]}, ALL)
will return c and d only.
by PavoGa
Mon Feb 04, 2019 4:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for getting Parent and Children
Replies: 17
Views: 210

Re: MDX for getting Parent and Children

I never understood the use of a TM1FILTERBYPATTERN and then a pattern without wildcards. We can reference the element in a direct way, can't we ? Agree, that does not make a lot of sense to me, either. I never use TM1FILTERBYPATTERN as a general rule within the context of TM1DRILLDOWNMEMBER, but co...
by PavoGa
Mon Feb 04, 2019 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for getting Parent and Children
Replies: 17
Views: 210

Re: MDX for getting Parent and Children

Hi, after testing around, I think I can replicate the issue. Very simple, as long as the parent exists in multiple rollups and one of grandparent has "&" in between , then it won't show the children of the parent. No difference for using TM1DRILLDOWNMEMBER or DRILLDOWNMEMBER. To me, those two funct...
by PavoGa
Fri Feb 01, 2019 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: cannot enter into a consolidation
Replies: 11
Views: 174

Re: PAW: cannot enter into a consolidation

Steve Rowe wrote:
Thu Jan 31, 2019 9:53 pm
Can you remember the creation sequence that led to this? In theory every N level should end up in the leaves hierarchy, if this is not reliable then this is a bit of an issue..
Not exactly, no. But the most common that I know of is cold migrations. A server startup does not fix anything.
by PavoGa
Fri Feb 01, 2019 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: cannot enter into a consolidation
Replies: 11
Views: 174

Re: PAW: cannot enter into a consolidation

Can you remember the creation sequence that led to this? In theory every N level should end up in the leaves hierarchy, if this is not reliable then this is a bit of an issue.. Absolutely agreed! ... This has me really scratching my head as there doesn't seem to be any "sync leaves hierarchy" funct...
by PavoGa
Thu Jan 31, 2019 7:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: cannot enter into a consolidation
Replies: 11
Views: 174

Re: PAW: cannot enter into a consolidation

Found the problem and just wanted to provide an update. In the ORG dimension, the leaf element the spread was being applied to did not exist in the Leaves hierarchy, just the ORG:ORG one. No problem with that, just add the element to the Leaves hierarchy and it spreads just fine. Except while correc...
by PavoGa
Thu Jan 31, 2019 6:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX for getting Parent and Children
Replies: 17
Views: 210

Re: MDX for getting Parent and Children

I always use TM1DRILLDOWNMEMBER with the ALL and RECURSIVE arguments. Is there a reason for not using that function vs. DRILLDOWNMEMBER?
by PavoGa
Wed Jan 30, 2019 11:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW TI Editor
Replies: 6
Views: 254

Re: PAW TI Editor

It may be "muscle memory," but Notepad++ seems to be much faster and offers some features I like over the PAW editors. If you take the time to say what these features are you never know who might be watching and find that these features make it into the product (eventually). I have found the produc...
by PavoGa
Wed Jan 30, 2019 11:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: cannot enter into a consolidation
Replies: 11
Views: 174

Re: PAW: cannot enter into a consolidation

Tried that as well and got the same error, Steve. Just flat out will not allow it. Changed method to do what needed to be done without entry at a consolidation, but at some point we are going to want to do user input at a consolidation and have it spread. I feel it has to be some setting and if/when...
by PavoGa
Wed Jan 30, 2019 2:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW TI Editor
Replies: 6
Views: 254

Re: PAW TI Editor

Agree the PAW editors are a tremendous improvement, although I, like Declan, use Architect for pretty much the same reason. I do use Notepad++ for TIs and Rules, then paste the code into the Architect editors. It may be "muscle memory," but Notepad++ seems to be much faster and offers some features ...
by PavoGa
Wed Jan 30, 2019 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: cannot enter into a consolidation
Replies: 11
Views: 174

Re: PAW: cannot enter into a consolidation

Additionally, PAX is not allowing entry into the consolidation either.