Search found 2546 matches

by Wim Gielis
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, ...
by Wim Gielis
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

pikolikoli wrote:
Wed Jan 20, 2021 11:15 am
Thank 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
Could it be that you're a French speaking person natively ?
by Wim Gielis
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.
by Wim Gielis
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...
by Wim Gielis
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.
by Wim Gielis
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 ?
by Wim Gielis
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 ...
by Wim Gielis
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 ;-)
by Wim Gielis
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.
by Wim Gielis
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...
by Wim Gielis
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;
by Wim Gielis
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

cdhodge2002 wrote:
Wed Dec 09, 2020 4:55 pm
Guessing that means no one has put data into a PAX report using data from Planning Analytics and Cognos Analytics at the same time.
I didn't, that's for sure.
by Wim Gielis
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... :o
by Wim Gielis
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...
by Wim Gielis
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

Re: PA Workspace - what can it do?

luizg2019 wrote:
Wed Nov 25, 2020 2:49 pm
Should I make a topic about this on the "Useful code, tips and tricks" section?
Sure, please do so 👍
by Wim Gielis
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...
by Wim Gielis
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 !