Search found 1577 matches

by Wim Gielis
Sat Feb 24, 2018 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a Dynamic Subset
Replies: 3
Views: 77

Re: Creating a Dynamic Subset

Q1: use Excel references and IF formulas to come up with the right elements. Do you put these months/years in the columns of a websheet ? Or where exactly do you use those 2 subsets ? Q2: I would use a SUBNM to aks a period/year combination by the user. Then make all your subsets once manually and p...
by Wim Gielis
Sat Feb 24, 2018 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic listing of elements using MDX
Replies: 8
Views: 176

Re: Dynamic listing of elements using MDX

Mark RMBC wrote:
Thu Feb 22, 2018 5:01 pm
I always forget you can use the single quotes in the excel sheets (force of habit is my excuse!)! A far more elegant solution!
Better to forget that one, than using =+ at the start of Every ! God ! damn ! formula ;-)
by Wim Gielis
Sat Feb 24, 2018 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display element alias using TM1RPTRow and MDX
Replies: 13
Views: 323

Re: Display element alias using TM1RPTRow and MDX

Hi Mark Hope I understand your question. I should qualified my previous reply better. There is indeed a relation between an MDX and an alias. For instance: A Period dimension with elements M01 to M12. Alias Jan, Feb, ..., Dec. {TM1FilterByPattern( TM1FilterByLevel( TM1SubsetAll( [Period] ), 0), "M01...
by Wim Gielis
Sat Feb 24, 2018 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a Dynamic Subset
Replies: 3
Views: 77

Re: Creating a Dynamic Subset

Creating a subset happens in 1 dimension. A subset (usually) has little knowledge of what happens in the other subsets of cube dimensions. It depends on the client used. In Excel and TM1 Web, you can use Excel cell references to come up with logic to return the required elements. In the cubeviewer t...
by Wim Gielis
Sat Feb 24, 2018 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 8
Views: 207

Re: TM1 Chore Schedule Information

*.cho files are text files and it's easy to write a TI to Read them and pull the chore attributes and store them in a 2-dimensional cube (one of dimensions being }Chores) That's indeed the approach taken in the link that George posted to a kind of documenter tool by myself. It has a custom dimensio...
by Wim Gielis
Sat Feb 24, 2018 11:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Chore Schedule Information
Replies: 8
Views: 207

Re: TM1 Chore Schedule Information

At least in 10.2.2 FP4 there is a cube called }StatsByChore that has some good stuff in it. You have to do the crazy serial date conversion math but it will give you the up coming schedule and last completion time. Thanks for posting. A requirement is that the }StatsByChore cube is filled in - e.g....
by Wim Gielis
Thu Feb 22, 2018 6:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display element alias using TM1RPTRow and MDX
Replies: 13
Views: 323

Re: Display element alias using TM1RPTRow and MDX

Mark RMBC wrote:
Thu Feb 22, 2018 11:29 am
Hi,

I notice the alias in the TM1RPTROW is code and description but your mdx seems to be just code without description

Could this be the issue?

cheers, Mark
An MDX returns a number of elements, you can still apply whatever alias you want, to the returned elements.
by Wim Gielis
Thu Feb 22, 2018 7:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display element alias using TM1RPTRow and MDX
Replies: 13
Views: 323

Re: Display element alias using TM1RPTRow and MDX

At first sight, this should work.

Can you create a view in the cube viewer with the alias turned on and your MDX expression,
then Active form to Excel and see if that works ?
by Wim Gielis
Wed Feb 21, 2018 6:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display element alias using TM1RPTRow and MDX
Replies: 13
Views: 323

Re: Display element alias using TM1RPTRow and MDX

Can you copy / paste here the TM1RPTROW function that you now use ?
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: 13
Views: 323

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: 5
Views: 212

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

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

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

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

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

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

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

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

Re: PAW questions

Thanks all !