Search found 2546 matches
- Thu Jan 21, 2021 12:07 am
- Forum: Enhancements
- Topic: New Combination of Area and Line Chart in PAW
- Replies: 1
- Views: 36
- Wed Jan 20, 2021 11:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating Dimensions Using Referentials .How does i work ?Where to learn about it
- Replies: 5
- Views: 97
Re: Creating Dimensions Using Referentials .How does i work ?Where to learn about it
I know that référentiel is used to set up dimensions. Actually, my colleagues in Paris have such a module, called référentiel, to quickly create dimensions. Similar to xdi but then in TM1 Web and a TI process with action button to create / update a chosen dimension. It's more of a template in fact, ...
- Wed Jan 20, 2021 9:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating Dimensions Using Referentials .How does i work ?Where to learn about it
- Replies: 5
- Views: 97
Re: Creating Dimensions Using Referentials .How does i work ?Where to learn about it
Could it be that you're a French speaking person natively ?pikolikoli wrote: ↑Wed Jan 20, 2021 11:15 amThank you So much Alan. This is very helpfull
The naming 'Referentiel' is what is used in some companies. I think it is a key word used by clients so it became a norme I guess.
Thank you
- Tue Jan 19, 2021 9:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form : code for no display Row
- Replies: 4
- Views: 122
Re: Active Form : code for no display Row
Isn't this just creating an MDX (in Excel) that drives the rows of the active form ?
Whereby the MDX filters out the desired elements based on an attribute flag.
Whereby the MDX filters out the desired elements based on an attribute flag.
- Wed Jan 06, 2021 8:02 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: 222
Re: Problem With Slow process execution when Selecting child Elements and a single consolidated Element
We both think Steve’s reply is already what the OP needs 
- Wed Jan 06, 2021 6:39 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: 222
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 Dec 23, 2020 6:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SubsetElementInsert difference between Position Index=1 and =2 in behaviour
- Replies: 3
- Views: 274
Re: SubsetElementInsert difference between Position Index=1 and =2 in behaviour
Use 0 everywhere if you want to insert elements in the order in which they are listed in the code.
- Wed Dec 23, 2020 6:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ASCIIOUTPUT does not create output file
- Replies: 10
- Views: 695
Re: ASCIIOUTPUT does not create output file
Are you really sure that your process enters the Metadata and Data tabs ? Did you check the view settings ?
- Sat Dec 19, 2020 1:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Element Security - Most restrictive
- Replies: 5
- Views: 329
Re: Dimension Element Security - Most restrictive
Maybe the documentation is referring to the rule that says if you have WRITE to the cube, WRITE to the dimension, but READ to the element then you have READ. You have to have WRITE all the way down to have WRITE. That would be new to me. READ access to a dimension is sufficient for WRITE access to ...
- Mon Dec 14, 2020 6:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DTYPE for hierarchies?
- Replies: 3
- Views: 590
- Fri Dec 11, 2020 12:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE CPU "Leak"
- Replies: 3
- Views: 433
Re: PAfE CPU "Leak"
I am having issues with that Russian terrorist called Kaspersky but it's the company choice 

- Thu Dec 10, 2020 4:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: User Upload csv files through PAW interface
- Replies: 4
- Views: 319
Re: User Upload csv files through PAW interface
I haven't done that yet. Yes, experimenting with a Perspectives websheet and the HYPERLINK function into it can maybe lead to a solution, use the TM1User function in Excel as well as part of the hyperlink to jump to.
- Thu Dec 10, 2020 9:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: User Upload csv files through PAW interface
- Replies: 4
- Views: 319
Re: User Upload csv files through PAW interface
I would give each user his or her own folder. All subfolders of 1 root folder. If you do this in a consistent way (through naming and/or attributes on the }Clients dimension) then the DataSourceNameForServer function in the Prolog tab can easily satisfy which subfolder it is, and load the data. Norm...
- Thu Dec 10, 2020 9:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Question about While Loop
- Replies: 3
- Views: 284
Re: Question about While Loop
Code: Select all
i = 1;
WHILE( i <= DIMSIZ( 'Region' ));
vRegion = DIMNM( 'Region', i );
IF( DTYPE( 'Region', vRegion ) @= 'N' );
# ...
ENDIF;
i = i + 1;
END;
- Wed Dec 09, 2020 8:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX connection to PA and CA
- Replies: 3
- Views: 257
Re: PAX connection to PA and CA
I didn't, that's for sure.cdhodge2002 wrote: ↑Wed Dec 09, 2020 4:55 pmGuessing that means no one has put data into a PAX report using data from Planning Analytics and Cognos Analytics at the same time.
- Thu Nov 26, 2020 10:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Excel VBA, PAFX: make a cell static
- Replies: 4
- Views: 615
Re: Excel VBA, PAFX: make a cell static
The fun becomes even bigger if we also take into account
- the CurrentArray range. It is associated with good old array formulas (Ctrl-Shift-Enter to confirm).
- the spill range. It is associated with the new dynamic array formulas (which are awesome by the way)
Joy joy...
- the CurrentArray range. It is associated with good old array formulas (Ctrl-Shift-Enter to confirm).
- the spill range. It is associated with the new dynamic array formulas (which are awesome by the way)
Joy joy...

- Wed Nov 25, 2020 9:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Refresh subnm mdx subset in pax
- Replies: 7
- Views: 374
Re: Refresh subnm mdx subset in pax
Hi You didn't show the SUBNM Does it by any chance identify the element in something in double quotes rather than an index number? If the value for the element is given in quotes, then it will always show that value whether it is in the subset or not. It you give an index it will show the element a...
- Wed Nov 25, 2020 5:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA Workspace - what can it do?
- Replies: 12
- Views: 616
- Tue Nov 24, 2020 6:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remove duplicate elements from the subset
- Replies: 7
- Views: 474
Re: Remove duplicate elements from the subset
Hi Wim Gielis, Thank you for your reply. I used the similar logic. Your code and my code produces distinct list of elements. But I want to delete all the elements that are appearing more than once. If you look at the example I provided in my original post, elements "Banana" and "Orange" appear twic...
- Tue Nov 24, 2020 11:06 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remove duplicate elements from the subset
- Replies: 7
- Views: 474
Re: Remove duplicate elements from the subset
Indeed, good catch !
I forgot, even when I do this all the time manually in the Subset Editor !
I forgot, even when I do this all the time manually in the Subset Editor !