Search found 1718 matches

by Wim Gielis
Fri Jul 20, 2018 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset "XXXX" is being used by a view and cannot be
Replies: 8
Views: 2936

Re: Subset "XXXX" is being used by a view and cannot be

paulsimon wrote:
Fri Jul 20, 2018 8:15 pm
If you upgrade to PA you can use temporary views that will only exist for the duration of the process so there is no need to delete them.
Upgrading to 10.2.2 FP4 is sufficient for temporary views and subsets.
by Wim Gielis
Fri Jul 20, 2018 12:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calling DBRW function without mentioning instance name in the first argument
Replies: 4
Views: 66

Re: Calling DBRW function without mentioning instance name in the first argument

Next to being impossible technically, I’m struggling to find a real life use case for this situation. So you want to retrieve a value from a cube, but you don’t know which TM1 instance the cube is in. I can understand that. But then the choice for which instance it is, is set in a cube. I get that t...
by Wim Gielis
Thu Jul 19, 2018 7:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to refresh all Contributor Views of all users globally?
Replies: 7
Views: 112

Re: Is there a way to refresh all Contributor Views of all users globally?

If this change is a one-off, why don't you either: - do it just before the server starts again - if not possible, introduce downtime of, say, 6 hours somewhere during the week. Is the model so critical that a planned downtime to change the functionality is not allowed ? Or is this change not a one-o...
by Wim Gielis
Thu Jul 19, 2018 7:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rule Editor
Replies: 1
Views: 101

Re: TM1 Rule Editor

What client do you use ? Architect/Perspectives - Performance Modeler - PAW ? Is it the advanced rules editor ? Haven't used that in a long time so I don't know it's still in use. What about copying rules to Notepad++ and copying back to the rules editor when you're done ? You can have color coding ...
by Wim Gielis
Thu Jul 19, 2018 6:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to refresh all Contributor Views of all users globally?
Replies: 7
Views: 112

Re: Is there a way to refresh all Contributor Views of all users globally?

Paul-TM1 wrote:
Thu Jul 19, 2018 6:38 pm
deleting all views and restarting is not possible as our server takes about 5 hours to restart.
The model is operating 24/7 ? No time left for maintenance ?
Is this expected - 5 hours seems a long time (assuming the use of persistent feeders) ?
by Wim Gielis
Thu Jul 19, 2018 6:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 perspective to send mails automatically
Replies: 3
Views: 80

Re: TM1 perspective to send mails automatically

There is no event monitoring available to you that can trigger something when data is changed so you would have no idea when a user has changed the value in a specific cell in a specific cube. True but Excel has event monitoring like changing a certain cell or range. If you translate the cell chang...
by Wim Gielis
Thu Jul 19, 2018 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset "XXXX" is being used by a view and cannot be
Replies: 8
Views: 2936

Re: Subset is being used by a view and cannot be deleted

Sorry for the modest contribution but might help some beginner, how to find the view using your subset. If you are denied to delete a subset because it's used in a view but you've got many of them, use the Notepad++ / Search / Find in files... feature to spot in your data directory the .vue files u...
by Wim Gielis
Wed Jul 18, 2018 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 686

Re: PAx - DBRW/DBRS only when requested

I see what you mean, and while I don't like it either, suggested mode is manual calcs.
by Wim Gielis
Wed Jul 18, 2018 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset
Replies: 5
Views: 333

Re: Dynamic Subset

I would say the problem is with the naming of the element, the parentheses in the name, i.e. ( Cat Sales Inc ) are causing the mdx to break. Can you try the following and see if it works: {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {StrToMember("[Account PCR].[DLR_REC_NACD2 DEALER RECEIVABLES - NACD (C...
by Wim Gielis
Tue Jul 17, 2018 8:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset
Replies: 5
Views: 333

Re: Dynamic Subset

For me it works when I change the dimension name and the (consolidated) element name. As Edward asked for, what happens if you do this in the Subset Editor of the dimension 'Account PCR' ? Does the consolidated element have level 0 descendants ? Related to this, what happens if you use the undocumen...
by Wim Gielis
Tue Jul 17, 2018 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 686

Re: PAx - DBRW/DBRS only when requested

Do you have calculations on Manual or Automatic ?
by Wim Gielis
Tue Jul 17, 2018 7:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 686

Re: PAx - DBRW/DBRS only when requested

In that case, you will link to the cell that is to be sent to TM1. That's not considered nesting.
by Wim Gielis
Mon Jul 16, 2018 9:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx - DBRW/DBRS only when requested
Replies: 14
Views: 686

Re: PAx - DBRW/DBRS only when requested

PTSD wrote:
Mon Jul 16, 2018 7:06 pm
Thank you.

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?
What is the DBRS function in TM1 ?
by Wim Gielis
Fri Jul 13, 2018 6:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing TM1 formulae from a sheet
Replies: 2
Views: 101

Re: Removing TM1 formulae from a sheet

Usually, you should ONLY use: =DBRW( ... ) and =DBR( and that's it. No funny things like: * 1,000 at the end, and no - sign in front, no =DBRW( ... ) + DBRW( ... ) These manipulations should ideally be done in TM1. Does this make life more difficult for your macro ? Maybe yes. But that's about it. U...
by Wim Gielis
Fri Jul 13, 2018 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to get - TI parameters labels and inputs on run time
Replies: 4
Views: 224

Re: How to get - TI parameters labels and inputs on run time

Hello, It does not exist. The only thing you could do is, and it will be not easy and cumbersome too, is set up a cube containing all processes and their parameter names (in the good sequence). Then for your generic code, loop over the parameters of the given process (you can do that in the separate...
by Wim Gielis
Thu Jul 12, 2018 6:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Check if the data of two cubes are the same
Replies: 5
Views: 369

Re: Check if the data of two cubes are the same

Then you can: 1) Set up a 2nd cube next to the first cube, with the correct dimensions if they differ from the dimensions in the first cube 2) You have 2 sets of processes, one set to each cube, and with the different logic 3) You run the processes 4) You and some colleagues cancel your plans for th...
by Wim Gielis
Thu Jul 12, 2018 6:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with TI Building a Dimension
Replies: 1
Views: 63

Re: I’m new to Tm1

Poi, 1) Please create a new topic 2) Please post your actual, real code, which does not suffer from typo's, missing brackets, ... The code should save fine in a process. Show us what is in your variables dimension, Vdimension, and so on. 3) Format your code in tags 4) Please explain in words that we...
by Wim Gielis
Thu Jul 12, 2018 6:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: I’m new to Tm1
Replies: 8
Views: 384

Re: I’m unable to post the post here

poi wrote:
Thu Jul 12, 2018 6:08 pm
Hi
I’m unable to post the issue here tell me any restitution is given to me
What does this mean in normal speak ?