Search found 1767 matches

by Wim Gielis
Sat Sep 22, 2018 9:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How should I do it? I want to modify the rules without anyone using TM1.
Replies: 3
Views: 567

Re: How should I do it? I want to modify the rules without anyone using TM1.

In the Security > Clients/Groups option, you can see who is active (logged on) at any point in time. Or you can use tools like TM1 Top or Operations console or other. Normally you would adjust/create rules in a development environment. After testing, they would be migrated to the production model wi...
by Wim Gielis
Thu Sep 20, 2018 3:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Name given View and Dimension Name
Replies: 3
Views: 353

Re: Subset Name given View and Dimension Name

Hello, This is indeed tricky. There is no such function. You could: - use code (TI, VB, Java, ...) to inspect the *.vue file (public or private view ?) - use the TM1 REST API (or similar), which can give you the layout of a view. This is advanced stuff, I cannot give you working code examples. For t...
by Wim Gielis
Mon Sep 17, 2018 11:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Recalculation Issue (DBRW)
Replies: 3
Views: 147

Re: Excel Recalculation Issue (DBRW)

Hello, - Are you sure that the user is in the same security groups compared to the user for whom it works ? I assume that for admin user it all works fine ? - The user has not been marked as 'ReadOnlyUser' ? - Can the user write a different cube with similar (or equal) dimensions ? Similar slices in...
by Wim Gielis
Mon Sep 17, 2018 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 322

Re: TM1 Question of the day

Thank you for confirming babytiger
by Wim Gielis
Mon Sep 17, 2018 7:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 322

Re: TM1 Question of the day

Someone who has the time to play around with it ? :D 5 minutes can always be donated :lol: A TI process with a dynamic level 0 subset as the data source, and the Metadata inserting an N-level element in the dimension, will have the Data tab including this new element. Anyone who can test in a diffe...
by Wim Gielis
Mon Sep 17, 2018 6:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 322

Re: TM1 Question of the day

I use Planning Analytics 2.0.5. In my case I have a string measure (both at N and C level), not a numeric measure. That is not tested. Also, what would happen if there are rules-calculated cells in the view, a CellPutN in the Metadata tab in a certain cell would mean that more cells should belong to...
by Wim Gielis
Sun Sep 16, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 322

Re: TM1 Question of the day

Absolutely correct George. Background: my view consists of string cells (at N and C level) with numeric input done on string elements. If the syntax for the 'string numbers' is not valid, or for other reasons, I clear cells in the Metadata tab. Other reasons could be: data that is to be moved to dif...
by Wim Gielis
Sun Sep 16, 2018 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 322

TM1 Question of the day

Hi all, Here's a TM1 question. I took the experiment and the answer is below, after a couple of Enter's :-) You have a TI process with a view as the data source. You have code in both Metadata and Data tab. In the Metadata tab you CellPutN a bunch of cells in the data source view to 0. Will these ce...
by Wim Gielis
Fri Sep 14, 2018 9:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 4
Views: 807

Re: TM1 REST API

Many thanks, I will continue when time permits.
by Wim Gielis
Wed Sep 12, 2018 8:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Caption attribute
Replies: 3
Views: 167

Re: Hierarchy Caption attribute

Not sure if this is:
1. possible
2. efficient or overkill,

but you could check whether the dimension }Hierarchies_dim exists in step 1.
If yes, you could do a Dimix > 0 on the hierarchy name within that dimension.
Do you see both names in that dimension ('Accounts Forecast' and 'AF1' ) ?
by Wim Gielis
Tue Sep 11, 2018 10:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 REST api - filter all subset except one dynamic subset
Replies: 4
Views: 142

Re: Tm1 REST api - filter all subset except one dynamic subset

There is a filter with 'Starts with' option that you can use, to exclude the subsets that start with ...
by Wim Gielis
Fri Sep 07, 2018 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Dashboard not adjusting
Replies: 4
Views: 171

Re: PAW Dashboard not adjusting

Hello Tom,

What is the version of PAW ? Maybe this is a known issue for which there are fixes or updates ?
by Wim Gielis
Fri Sep 07, 2018 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Saves not completing and retriggering 10.2.2 FP4
Replies: 13
Views: 243

Re: Data Saves not completing and retriggering 10.2.2 FP4

Hi Wim, Yes basically. I think the middle of the day data save is causing or has potential to cause more problems than it solves. If the server can't acquire the locks it needs for the save data and this is causing "thrashing" with multiple rollbacks and restarts then this is going to have performa...
by Wim Gielis
Fri Sep 07, 2018 10:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Saves not completing and retriggering 10.2.2 FP4
Replies: 13
Views: 243

Re: Data Saves not completing and retriggering 10.2.2 FP4

Hi, Thanks Lotsaram ! That's clear. In fact, to be complete, I should have added that after daily activity by the user, a few chores kick in (10PM). Then a Savedata is done at 11.30 PM, after which 7zip does a backup of the TM1 data dir. Lastly at 2AM the chores load data until 7AM, with a save data...
by Wim Gielis
Fri Sep 07, 2018 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Saves not completing and retriggering 10.2.2 FP4
Replies: 13
Views: 243

Re: Data Saves not completing and retriggering 10.2.2 FP4

We are running into an occasional issue where our data save (running on a chore) is not completing. It starts, we can see it running in Tm1Top, many other chores, processes and data loads are then happening alongside this. As others have said and as the IBM documentation states, the save data shoul...
by Wim Gielis
Thu Sep 06, 2018 8:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating subsets in Workspace
Replies: 6
Views: 159

Re: Creating subsets in Workspace

Or, put the dimension in a temporary cube and afterwards you throw away the cube.
by Wim Gielis
Thu Sep 06, 2018 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Saves not completing and retriggering 10.2.2 FP4
Replies: 13
Views: 243

Re: Data Saves not completing and retriggering 10.2.2 FP4

You really should NEVER have any other processes running when a Save Data is taking place, it's just going to cause problems. I fully agree. But then you have the users claiming that deadlines are tight and still somehow want to execute their 'small process' that only takes a couple of minutes... A...
by Wim Gielis
Thu Sep 06, 2018 11:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Not Working for Certain Cells
Replies: 1
Views: 176

Re: Rule Not Working for Certain Cells

Hello,

Are there other rules in the rules editor above the rules you show here ?
If yes, these rules would take precedence over the rules that you show.
by Wim Gielis
Wed Sep 05, 2018 7:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Dimension Elements to Subset in Tm1 REST api
Replies: 4
Views: 431

Re: Copy Dimension Elements to Subset in Tm1 REST api

Thanks for the information tomok. I would like to search dimension elements by alias, and filter the results that I want to store in subset. What would be the best way to achieve. TI Process?? This is a different question. Please keep 1 question per topic. You already have several other topics on t...