Search found 2467 matches

by tomok
Thu Sep 06, 2018 7:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Saves not completing and retriggering 10.2.2 FP4
Replies: 13
Views: 232

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. Turning on PI is not going to help because Save Data saves the entire cube at once, not just the area you changed. You need to go back and create a schedule that ensures that...
by tomok
Tue Sep 04, 2018 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Copy Dimension Elements to Subset in Tm1 REST api
Replies: 4
Views: 428

Re: Copy Dimension Elements to Subset in Tm1 REST api

Hi Everyone, Is it possible to copy the Dimension Elements into subset using Tm1 rest api? Will it leads to performance drawback? suggest me some direction. Thanks Have you even attempted to look any of this up in the documentation? I've never used the REST API before but I found what you were look...
by tomok
Wed Aug 29, 2018 6:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 271

Re: Order of Cube-Processing

Okay, got it. Thx. But, to stay with my example. I tested that A is processed before C. So can I say that all C's are processed before another A is selected or is this mixed? If you really want know what order you are going to get just take your view, use it as a data source, and instead of writing...
by tomok
Wed Aug 29, 2018 3:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Order of Cube-Processing
Replies: 10
Views: 271

Re: Order of Cube-Processing

The only way you can guarantee the order is going to be to create the subsets in the order you want (which you have already done), but instead of creating a view you cycle through all the combinations with a nested loop and do a CELLGETN statement to get the value. You'll be giving up zero suppressi...
by tomok
Tue Aug 28, 2018 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Problem
Replies: 4
Views: 215

Re: TI Problem

When you run a process via ExecuteProcess, the syntax is normally ExecuteProcess(Param1Name, Param1Value, Param2Name, Param2Value...ParamXName, ParamXValue). Your code is ExecuteProcess(Param1Value, Param2Value). You are not passing the name of the parameter. If you look at your error message screen...
by tomok
Thu Aug 23, 2018 10:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?
Replies: 8
Views: 648

Re: TM1 Excel files with DBR formulas still must be saved as paste values? is there a workaround ?

From your posts it sounds like you are using Perspectives. Have you not heard of the Print Report functionality in Perspectives that can take a report and generate either a PDF or range-valued Excel file out of it?
by tomok
Wed Aug 22, 2018 12:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Cube Design for a Financial Model
Replies: 6
Views: 409

Re: Best Cube Design for a Financial Model

Gross Margin is used the most and will have to contain an allocation model Tread very carefully here. If you attempt to do this via rules you may be less than pleased with the results, as far as performance is concerned. It may work fine in development but once you roll it out and the cube is amped...
by tomok
Tue Aug 21, 2018 7:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuration Directoy
Replies: 4
Views: 143

Re: Configuration Directoy

Just for giggles I Googled "TM1 Configuration Directory". Lo and behold the first entry in the search list answers your question. People are so helpless these days.
by tomok
Mon Aug 20, 2018 5:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Subset in TI Process
Replies: 3
Views: 113

Re: MDX Subset in TI Process

The string you are filtering for must be enclosed in quotation (") marks.

Code: Select all

vDataSet='"*'|v1|'*"';
by tomok
Mon Aug 20, 2018 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form with Perspectives
Replies: 2
Views: 186

Re: Active Form with Perspectives

In order for this to work everything for the zero-suppressed view have to be in contiguous columns. The columns you want to provide via a VIEW statement must be out to the right of the zero-suppressed section of the active form. If you mix them up the zero suppression won't work.
by tomok
Thu Aug 16, 2018 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Web Dashboards via REST API
Replies: 5
Views: 691

Re: Web Dashboards via REST API

Since what you will be doing is agnostic as to the data source I'm sure there are plenty of dashboarding toolkits that can deal with data in JSON format. Have you tried Googling that? If you are somewhat ambitious and have some web development experience there is always jQuery and jQueryMobile. Alth...
by tomok
Thu Aug 16, 2018 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to know last cube updated time in TM1
Replies: 7
Views: 752

Re: How to know last cube updated time in TM1

The .cub file update time is only useable, when you make a saveDataAll before you copy, otherwise you don't know if there are changes. Actually, you only need to save that cube, not all cubes. If you include in your process(es) one that does a CubeSaveData command for the cube in question you can t...
by tomok
Wed Aug 15, 2018 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTRow with MDX Expression that Returns zero elements
Replies: 8
Views: 530

Re: TM1RPTRow with MDX Expression that Returns zero elements

This is definitely a bug but it's been around awhile as I've had the same issue before. As a matter of principle I always put dummy elements in dimensions where there are going to be reports that may have no rows returned that say something like "No cost centers found", or something along those line...
by tomok
Wed Aug 08, 2018 11:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade action buttons
Replies: 2
Views: 272

Re: Upgrade action buttons

So I am looking for any alternatives to upgrade the action buttons which are not uploaded to TM1 server. Why? They don't have to be uploaded to their final resting place. They just need to be in an application folder somewhere. You can even do it on a development server and then move them to produc...
by tomok
Wed Aug 08, 2018 11:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading to Database; ideas
Replies: 5
Views: 217

Re: Loading to Database; ideas

Another idea would be to use a subset of the dimension as the datasource and then do an ATTRS or ATTRN to get the values and write one SQL statement to insert all the values for each Project at one time. I wouldn't use a cube view with just one attribute because if the attribute is empty and you are...
by tomok
Fri Jul 27, 2018 1:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pax & Perspectives => Active Forms not working
Replies: 4
Views: 773

Re: Pax & Perspectives => Active Forms not working

First off, the PAX and Perspectives add-ins cannot coexist. You have to have either one or the other loaded. It looks like the PA install program set the PAX add-in to auto load. It's simple, just stop it from auto loading in Excel. Then you can launch either PAX or Perspectves manually. As to your ...
by tomok
Fri Jul 20, 2018 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Journal validation - account combinations
Replies: 7
Views: 312

Re: Journal validation - account combinations

Steve already gave you an answer that should have put you on the right path. Given your new facts you could just create three dimensions; one with the valid AB combos, one with the valid AC combos and on with the valid AD. Then in your TI you just test the incoming record against each of these dimen...
by tomok
Fri Jul 20, 2018 12:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calling DBRW function without mentioning instance name in the first argument
Replies: 6
Views: 278

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

hemheman wrote:
Fri Jul 20, 2018 12:10 pm
But my question here his can we call DBRW function from excel without mentioning instance name in the first argument (cube argument) in the function.
Simple answer, no.
by tomok
Thu Jul 19, 2018 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Azure VM Type for Planning Analytics
Replies: 10
Views: 442

Re: Best Azure VM Type for Planning Analytics

I would be astounded if IBM support TM1 on any cloud platform other than IBM Cloud/Softlayer anyway. I don't know if the on-premise server license agreement specifically mentions restricting running it on your own hardware versus something in a cloud (other than IBM's) but I would imagine IBM could...
by tomok
Thu Jul 19, 2018 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 perspective to send mails automatically
Replies: 4
Views: 249

Re: TM1 perspective to send mails automatically

Now I want to do something such as sending an automatic mail to a group of users everytime a specific data in the cube is changed ! :)))) You can send emails via a TI process as has been mentioned but here is the rub, how are you going to know when the specific data you are referring to is changed?...