Search found 1567 matches

by Wim Gielis
Tue Feb 20, 2018 10:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display element alias using TM1RPTRow and MDX
Replies: 3
Views: 52

Re: Display element alias using TM1RPTRow and MDX

Did you Google the word 'TM1RptRow' and use the first link ?
by Wim Gielis
Mon Feb 19, 2018 10:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SUBNM in TM1Web
Replies: 2
Views: 91

Re: SUBNM in TM1Web

Hello,

Just for testing, does it work it work if you hardcode the first 2 parameters in the SUBNM ?
by Wim Gielis
Fri Feb 16, 2018 8:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with Pulling data from Sales Cube for AR Cube
Replies: 3
Views: 337

Re: Issue with Pulling data from Sales Cube for AR Cube

Analytics123 wrote:
Fri Feb 16, 2018 2:57 pm
Now I cannot use ELPAR in my rule to pass the value based on condition since i have multiple Hierarchies .
Typically you would use an attribute to store the desired parent. This way you avoid the problem of Elpar with multiple hierarchies.
by Wim Gielis
Wed Feb 14, 2018 3:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Evaluation of DBRW Formula in VBA
Replies: 7
Views: 208

Re: Evaluation of DBRW Formula in VBA

You have to do the hard work of splitting up the formula in pieces, one argument is 1 piece, and work from there. Watch out for arguments that are text but contain the separator for arguments, like a comma in the name of an element. The TM1 Tools addin has code for this, have a look at it, here on t...
by Wim Gielis
Sat Feb 10, 2018 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: formula for element property in hierarchy
Replies: 4
Views: 361

Re: formula for element property in hierarchy

You can consider alternative hierarchies in the most recent versions of TM1. But if the 9.5 in your profile is accurate then you could find newer versions (and that’s an understatement).
by Wim Gielis
Mon Feb 05, 2018 7:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: formula for element property in hierarchy
Replies: 4
Views: 361

Re: formula for element property in hierarchy

Hello, Weights are always fixed: the weight of an element in (one of his) parent(s) does not change. What is the relation between bots sets of data ? Can you change the sign when loading the data ? Or use a rule to convert values such that the natural consolidations with fixed weights can do their j...
by Wim Gielis
Mon Feb 05, 2018 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tools to copy and rename TM1 object
Replies: 6
Views: 250

Re: Tools to copy and rename TM1 object

Hello Kenneth, Tools like Notepad++ can help you, but in the end it will always be a semi-automatic task. Good testing will be very much needed because skipping 1 or more references is not uncommon. Or cases (though unlikely) where object names are derived as variables rather than hardcoded, don't f...
by Wim Gielis
Mon Jan 22, 2018 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What are TM1 Rules Capabilities?
Replies: 6
Views: 377

Re: What are TM1 Rules Capabilities?

Indeed, rules are like Excel formulas, to calculate certain areas in a cube in a dynamic way (i.e. calculation on the fly with every refresh).
by Wim Gielis
Thu Jan 11, 2018 6:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Enhancing Logic
Replies: 1
Views: 136

Re: Enhancing Logic

Hello, The length or number of statements is not so important. You can condense the notation by omitting the month but using an attribute to hold the previous month (and also one to hold the next month in order to feed the rule). Use DB() to refer to the previous month's value based on the attribute...
by Wim Gielis
Fri Jan 05, 2018 9:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW questions
Replies: 8
Views: 684

Re: PAW questions

Thanks all !
by Wim Gielis
Thu Dec 14, 2017 8:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Change in Element Name of a frequently used Dimension
Replies: 14
Views: 548

Re: Change in Element Name of a frequently used Dimension

One question i had is after Swapping the Alias with the Initial name, suppose we do not delete the Alias(which will now contain the Initial Element Name). Will this impact the existing Cubes Data/Rules/TI processes/Worksheets in a negative way i.e will they break them ? Or they will work as before ...
by Wim Gielis
Mon Dec 11, 2017 7:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: carry forward a dimension elements to another dimension
Replies: 5
Views: 373

Re: carry forward a dimension elements to another dimension

hi, I am adding to dimension A , but I am just appending dimension b to dimension A. But dimension B can change any time and that needs to be reflected on DImension A on daily basis. So I have to unwind Dim B elements in Dim A daily and then readd dim B elements to dim A . so to append Dim B to Dim...
by Wim Gielis
Sun Dec 10, 2017 10:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Anyway to prevent Files to Accidentally DBSW ?
Replies: 8
Views: 372

Re: Anyway to prevent Files to Accidentally DBRW ?

Jean, DBRW formulas on their own will not write data to a cube. Not in manual calc mode, not in automatic calc mode. So it has to be the case that you or the user enters a value over a DBRW. Or do you use a DBS function ? A DBRW formula will only show what is currently in the cube, if you do not ent...
by Wim Gielis
Sun Dec 10, 2017 11:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW questions
Replies: 8
Views: 684

Re: PAW questions

And what about the TI function in hierarchies as the variant of Dimsiz ? To count the number of elements in an hierarchy, or do I miss something ?
by Wim Gielis
Sun Dec 10, 2017 12:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW questions
Replies: 8
Views: 684

PAW questions

Hello all, We can create a process in PAW, and the editor shows coloured functions, arguments to functions, and more of that. However, where can I indicate the data source of the process, like a subset or a text file for example ? When a process creates a dimension, it seems that a Refresh of the ob...
by Wim Gielis
Sat Dec 09, 2017 2:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: converting to date for comparing dates
Replies: 3
Views: 279

Re: converting to date for comparing dates

Did you spend a minute in the help on TM1 rules functions ? Long, Scan, Insrt, and so on.
by Wim Gielis
Wed Nov 29, 2017 5:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adjusting font size of action buttons with VBA
Replies: 2
Views: 232

Re: Adjusting font size of action buttons with VBA

Hi there,

I ran accross the very same issue. Sometimes it works when you save, close and open the sheet, but it's not a guarantee.
So I decided to do it manually rather than automated.
by Wim Gielis
Wed Nov 29, 2017 5:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is TM1 dimension index important?
Replies: 4
Views: 471

Re: Is TM1 dimension index important?

One area where the the index order is important, is when you expand a consolidation. Then TM1 will show the immediate children based on the index. One might want to change the index when this is important. For example, Total Year has 12 children as the months. Then you don't want to have a random li...
by Wim Gielis
Fri Nov 17, 2017 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Name of subset using in view
Replies: 4
Views: 633

Re: Name of subset using in view

EP_explorer wrote:
Thu Nov 16, 2017 1:53 pm
Thank you
You're welcome, glad you like it.