Search found 302 matches

by PavoGa
Wed Mar 20, 2019 7:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LEN works in Architect, not PAW
Replies: 1
Views: 22

LEN works in Architect, not PAW

This code: FILTER( TM1FILTERBYLEVEL(TM1SUBSETALL( [Organization]), 0), LEN([Organization].currentmember.Name) > 18); works just fine in Architect and TIs. Returns "Invalid MDX expression" in PAW. The Reference Guide does not list LEN as being a supported function so there is that. Has anyone else ha...
by PavoGa
Wed Mar 20, 2019 7:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LEN works in Architect, not PAW
Replies: 2
Views: 21

LEN works in Architect, not PAW

This code: FILTER( TM1FILTERBYLEVEL(TM1SUBSETALL( [Organization]), 0), LEN([Organization].currentmember.Name) > 18); works just fine in Architect and TIs. Returns "Invalid MDX expression" in PAW. The Reference Guide does not list LEN as being a supported function so there is that. Has anyone else ha...
by PavoGa
Wed Mar 13, 2019 7:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: List of all rules
Replies: 2
Views: 292

Re: List of all rules

Write a TI that uses WilcardFileSearch in the Data folder the instance. Create dimensions as needed to capture the returned objects you wish to catalog. Put this in a chore that runs regularly to keep those dimensions updated. There may be other methods, but that will do it. In Planning Analytics, t...
by PavoGa
Mon Mar 11, 2019 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Forecasting & Budgeting
Replies: 3
Views: 656

Re: Forecasting & Budgeting

jim wood wrote:
Mon Mar 11, 2019 11:30 am
Moved to the correct forum. I'll get my tin hat ready for when Tomok sees this!!
:lol: Had to laugh. As I was reading it, thought almost the same thing, "wait until Tomok sees this!"
by PavoGa
Mon Mar 11, 2019 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Instead SUBST
Replies: 1
Views: 282

Re: Instead SUBST

It appears the leaf level "1478524789" is a unique identifier and assume the prefix is a categorization such as business unit/etc. If true, I would have actually used the "1478524789" as the primary element name with the prefix as an attribute and have a alias that combines the two into the desired ...
by PavoGa
Wed Mar 06, 2019 12:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 182

Re: REST API: consolidated elements without children

Hi Not sure I understand why you would not use easier functions that TM1TupleSize and Item. Straight from my MDX page: @Wim, ask a hard question. :) 1) Have visited your MDX page. Just did not recall those queries or would have referenced them. 2) Have to admit I'm not as up on all the various MDX ...
by PavoGa
Tue Mar 05, 2019 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 182

Re: REST API: consolidated elements without children

lotsaram wrote:
Tue Mar 05, 2019 8:22 pm

Childless consolidations still evaluate as level 1 and not level 0.
Flat did not think about/realize that. Good tip, thanks.
by PavoGa
Tue Mar 05, 2019 5:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: consolidated elements without children
Replies: 8
Views: 182

Re: REST API: consolidated elements without children

Example Dimension has two consolidations without children: Test2 hierarchy.png This MDX code produces as set of the consolidations without children: FILTER(EXCEPT(TM1SUBSETALL( [test2] ), TM1FILTERBYLEVEL( TM1SUBSETALL( [test2]), 0)), TM1TUPLESIZE( ([test2].currentmember.children).ITEM(0)) = 0) Chil...
by PavoGa
Thu Feb 28, 2019 7:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 13
Views: 727

Re: Drill-through to a cube view

Tried that and the drill went back to the behavior of not returning the view name to the viewer and the same two dimensions without their associated subsets as well. However, an update on rebuilding the pre-existing view and calling it with ReturnViewHandle: it does return the view (sans the two sub...
by PavoGa
Thu Feb 28, 2019 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 13
Views: 727

Re: Drill-through to a cube view (EDIT)

Have run head-on into this with PA-2.0.05. Is it fixed in any of the subsequent releases? Did not have this problem in 10.2 using the technique of building custom cube views and by-passing the default Epilog ReturnViewHandle. UPDATE In 10.2, the method I used was building subsets and a view with a d...
by PavoGa
Mon Feb 25, 2019 6:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a multi-dimensional view with TI process
Replies: 3
Views: 135

Re: Creating a multi-dimensional view with TI process

Have you looked at the ViewColumnDimensionSet, ViewRowDimensionSet and ViewTitleDimensionSet functions? Those are the functions to use.

These functions have no effect on a view used for a datasource, only those used as cube views for end users.
by PavoGa
Mon Feb 25, 2019 6:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 439

Re: Temp View difference to Perm Views

I have found that a temporary subset is not available to a subsequent MDX query within the same TI. In that case, the first query has be a permanent subset and is removed in the Epilog. You mean using one subset as the base set for another? As in either ... {FILTER( [Dimension].[Temp Subset], filte...
by PavoGa
Mon Feb 25, 2019 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temp View difference to Perm Views
Replies: 14
Views: 439

Re: Temp View difference to Perm Views

I have found that a temporary subset is not available to a subsequent MDX query within the same TI. In that case, the first query has be a permanent subset and is removed in the Epilog.
by PavoGa
Wed Feb 20, 2019 10:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 569

Re: MDX StrToMember Error

One additional consideration. Just in case that primary site attribute were to contain a bad element, it will still cause a failure of StrToMember. One way to avoid that is to add another attribute, using DIMIX, that holds the index value of the primary site within the parent dimension. You would wa...
by PavoGa
Tue Feb 19, 2019 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX StrToMember Error
Replies: 13
Views: 569

Re: MDX StrToMember Error

This is what you need to reference the user id: StrToMember("[}Clients].["+USERNAME+"]") To figure out what part of the MDX is not working, take each section and parse it out to figure what is and what is not returning the expected result. For example, to determine if this is working as expected: St...
by PavoGa
Tue Feb 19, 2019 12:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Edit TI Process without first Executing it?
Replies: 16
Views: 2439

Re: How to Edit TI Process without first Executing it?

Assuming you want to save the coding on the Advance tabs: 1) save the TI off to another file. 2) delete the TI from within Architect. 3) open the copy with a text editor such as Notepad++ 4) rebuild your desired TI using the suggestions from above to set the data source, copy and paste the code sect...
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: 430

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: 430

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: 430

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: 430

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...