Search found 117 matches

by Drg
Tue Aug 08, 2017 7:05 am
Forum: Useful code, tips and tricks
Topic: Inspecting TM1 processes and chores
Replies: 4
Views: 2876

Re: Inspecting TM1 processes and chores

awesome, gret job.
by Drg
Mon Aug 07, 2017 9:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives hang when performing a slice or snapshot to Excel
Replies: 17
Views: 4706

Re: Perspectives hang when performing a slice or snapshot to Excel

hi faced with use perspectives and cafe in same excel.(create snapshot, slice)

IBM create a fix pack for cafe.


IBM Cognos CAFE IF 10.2.2.7 IF2
by Drg
Mon Aug 07, 2017 9:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process does not update updateable cell
Replies: 5
Views: 1157

Re: Process does not update updateable cell

use textoutput() function on your process to create snapshot of action on the TI script. Check rule on cell where you don't see you data(maybe on some action of users cell lock's CellIsUpdateable etc...). Faced in same trouble wheen copy data from version to version. We check al ldata flow and find ...
by Drg
Mon Aug 07, 2017 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
Replies: 6
Views: 1526

Re: Need help in attaching files in commentary without changing File Name - TM1 10.2.2

The first thing is to parse the structure of the form stored in the cube} ElementAnnotations_DimensionName cube to get a list of files (in the OS) and their names (the names that are needed to display to users) After this, two operations must be performed 1) replace the names in the folder} app 2) o...
by Drg
Fri Aug 04, 2017 2:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders - for conversion rule
Replies: 8
Views: 1178

Re: Feeders - for conversion rule

maybe ?
[Currency:'Local Currency'] => [Currency:'USD'];

This implies that all other dimensions of the feeds are one to one
by Drg
Fri Aug 04, 2017 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
Replies: 6
Views: 1526

Re: Need help in attaching files in commentary without changing File Name - TM1 10.2.2

Do you really think this is normal? :shock: :shock: :shock: How then should the system behave if your colleague append a file with the same name? In either case, you can serialize the form in the annotation cube and find the file name there Then you have two ways: Use changed name Change the name of...
by Drg
Fri Aug 04, 2017 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tracking User Logins
Replies: 19
Views: 5235

Re: Tracking User Logins

Unfortunately my typo only occured in the post, but not in the filename... this would have been easier :lol: I used lotsarams script, but faced the same experience: Log-file (userlogin.log) will be created after saving the file changes for ....properties. Then starting Perspectives, logging in, log...
by Drg
Fri Aug 04, 2017 2:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 2621

Re: Loading data in Cube with Picklist TM1

ODBCOpen( 'DSNname', ' userid' , 'passwd ' ); Squery = 'Select Services, client from table'; Anna use this construct only makes sense in cases of dynamic database queries (when you load different cubes from different tables by one unique process, I do not think you need to do this now) :roll: Hi ev...
by Drg
Fri Aug 04, 2017 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process does not update updateable cell
Replies: 5
Views: 1157

Re: Process does not update updateable cell

turn on logging on this cube and run you process. check transaction log after.
or use textoutput(),LOGOUTPUT() function on your process to find your error.
by Drg
Thu Aug 03, 2017 11:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: downgrade of Performance Modeller
Replies: 3
Views: 1026

Re: downgrade of Performance Modeller

try change:

<tm1 install dir>\webapps\pmpsvc\rcp_installs [clients]
<tm1 install dir>\webapps\pmpsvc\rcp_updates [updates config]

try to change to old version in
ModelingMDT.x86_64_app.xml
ModelingMDT_app.xml

I have not tested this solution so unsubscribe if you decide to apply it
by Drg
Thu Aug 03, 2017 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Source File Hung Up After TI Process??
Replies: 4
Views: 1395

Re: Data Source File Hung Up After TI Process??

you use RUNTI?
How do you verify that the data is loaded?
You use chore to run load process(What level of acceptance are you using)?
What structure does the process call the parent child processes?
by Drg
Thu Aug 03, 2017 6:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 2621

Re: Loading data in Cube with Picklist TM1

If i understand you correct you need this: In prolog write this code rowcount=0; In metadata or data write this code #your sql table variable #Services as v1 #Client as v2 #hand made rowcount rowcount=rowcount+1; #here past cod eto update Tipo service piclist dimension #insert data to cube CELLPUTS(...
by Drg
Thu Aug 03, 2017 5:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }PlanningControl What is this system cube? What is it for?
Replies: 2
Views: 724

Re: }PlanningControl What is this system cube? What is it for?

I don't see this cube on any of my systems except for those which have had "TM1 Applications" (Contributor) published at some point (none currently do). I can only assume this is created by Performance Modler. In the ApplicationParameters there are some params that refer to the "TUnit" which is the...
by Drg
Wed Aug 02, 2017 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Loading data in Cube with Picklist TM1
Replies: 12
Views: 2621

Re: Loading data in Cube with Picklist TM1

Make a picklist based on a dimension or a subset(dynamic) Option 1 Before uploading data in cube, upload a dimension After filling the cube cell's Option 2 As the cube is filled with data, check have element in the dimension(dimix func) if there is no element, then insert it into the demension DIREC...
by Drg
Wed Aug 02, 2017 3:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Capabilities cube
Replies: 1
Views: 507

Re: }Capabilities cube

What exactly are you interested in?

https://www.ibm.com/support/knowledgece ... ments.html
by Drg
Wed Aug 02, 2017 2:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }PlanningControl What is this system cube? What is it for?
Replies: 2
Views: 724

}PlanningControl What is this system cube? What is it for?

One of these days has found out the system cube a cube consists of two measurements. }ApplicationNames , }ApplicationParameters It is strange that the cube is filled from the user(in transaction log file) '*' There is no official documentation :shock: Can anyone explain what this cube is and why it ...
by Drg
Tue Aug 01, 2017 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can use variable in TI Variable Name?
Replies: 3
Views: 907

Re: Can use variable in TI Variable Name?

pStart=6 pEnd=17 vColumnIndex =pStart; while(vColumnIndex<=pEnd); vtypeclass = 'vColumn'|NumbertoString(vColumnIndex); if(DIMIX('product','vColumn'|NumbertoString(vColumnIndex)) = 0); #create variable name %VAR№% vtypeclass= EXPAND( ('%vColumn'|NUMBERTOSTRING(vColumnIndex) | '%' ) ) ASCIIOutPut('c:\...
by Drg
Mon Jul 17, 2017 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java API - pull data from view?
Replies: 14
Views: 7743

Re: TM1 Java API - pull data from view?

kjanssen wrote:
Mon Apr 13, 2015 2:58 pm
ok i found that i have to use view.getColumnSubset(i) & view.getRowSubset(i) and then use thier getElement()
Maybe y read this.

You were able to return the tuple using the method getArrayAxisTuple??? :oops:
by Drg
Sun Jul 16, 2017 6:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA API get view array with header???
Replies: 6
Views: 1380

Re: JAVA API get view array with header???

This is a pretty obscure question and I'm not surprised no one has answered. I've never even looked at the Java API and quite frankly, don't know why I ever would unless I was trying to create some third-party tool to try and sell to the TM1 community. Bumping it up to the top each day is not going...