Search found 13 matches

by PTSD
Wed Jul 18, 2018 12:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 2075

Re: PAx - DBRW/DBRS only when requested

Automatic. I do still want standard excel formulas to work.
by PTSD
Tue Jul 17, 2018 6:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 2075

Re: PAx - DBRW/DBRS only when requested

It is about 1 second delay every time I key in a number and hit enter. Doesn't seem like much, but it is. There are a few thousand formulas on the sheet, half of those are TM1. Disconnecting from PAx doesn't change anything, which makes me thing it is excel. Never had this problem with SAP excel add...
by PTSD
Tue Jul 17, 2018 12:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 2075

Re: PAx - DBRW/DBRS only when requested

Weirdly enough, I unnested 70% of the formulas and see no difference in performance. I think it is just the sheer number of formulas on a sheet that effects the performance, not nesting.
by PTSD
Mon Jul 16, 2018 11:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 2075

Re: PAx - DBRW/DBRS only when requested

Sorry, I meant DBSW. My bad.
by PTSD
Mon Jul 16, 2018 7:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 2075

Re: PAx - DBRW/DBRS only when requested

Thank you.

It looks like I can easily unnest DBRWs.

Question on DBRSs - obviously hard-coding values is not efficient. If my DBRS formulas are referencing another cell for "send" value - is this considered nesting as well?

Thanks.
by PTSD
Mon Jul 16, 2018 5:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 2075

Re: PAx - DBRW/DBRS only when requested

Thanks!
It is a bummer though, cause nesting gets me the efficiency. I'll try to reorganize everything and see if I can build it in a similar way with no nesting.
by PTSD
Mon Jul 16, 2018 4:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 2075

PAx - DBRW/DBRS only when requested

Hi, I have an excel file with a lot of DBRW/DBRS formulas (roughly 1000 on each tab). Most of these are also nested in other standard excel formulas. The file works great, except can be very slow at times. Is there a way to make BBRW/DBRS formulas work only when you want them to, and not contentious...
by PTSD
Sat Jul 14, 2018 9:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX dependent drop down lists
Replies: 3
Views: 991

Re: PAX dependent drop down lists

"TM1ELLIST" - How does one actually use this in excel? How do I create a drop-down that displays members of a give dimension?
by PTSD
Mon Jun 25, 2018 8:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 1414

Re: Retrieving member name by alias

Try using a scan and subst function to find the hyphen between the code and description then subst to chop from the right to the end. If your codes are all uniform in length, you can subst from character 8 onwards (or wherever the description starts) Thanks again, I check out the syntax for subset....
by PTSD
Mon Jun 25, 2018 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 1414

Re: Retrieving member name by alias

You can try using: DBRA(<dimension name>,<element>,<alias>) e.g DBRA('Account','5010','Account Description') if in Perspectives (hoping PAX too) or in rules, use ATTRS(<dimension name>,<element>,<alias>) HTH Thank you!!! Exactly what I was looking for. The result I'm getting now is "5010 - Compensa...
by PTSD
Mon Jun 25, 2018 5:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 1414

Re: Retrieving member name by alias

Apart from your question, wouldn’t be 5001 the element and salaries overtime the alias ? Good point, shows my lack of understand TM1 infrastructure. So, based on attached, my alias ID is "5010" and alias description is "Compensation - Salary? Am I looking at this right? And would would be the funct...
by PTSD
Sun Jun 24, 2018 10:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 1414

Re: Retrieving member name by alias

Apart from your question, wouldn’t be 5001 the element and salaries overtime the alias ? Good point, shows my lack of understand TM1 infrastructure. So, based on attached, my alias ID is "5010" and alias description is "Compensation - Salary? Am I looking at this right? And would would be the funct...
by PTSD
Sun Jun 24, 2018 5:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Retrieving member name by alias
Replies: 10
Views: 1414

Retrieving member name by alias

Sorry I’m completely new to IBM Planning and Analytics. I’m looking for a simple function that will retrieve full member name based on alias. Basically the equivalent of EVDES() in SAP. I found some examples with DIMIX and DIMNM, but can’t get those arguments to work. For example, say I have 5001 as...