Search found 137 matches

by Drg
Tue May 07, 2019 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Name on TI Process
Replies: 14
Views: 6858

Re: Server Name on TI Process

There is a free solution from me.

just put this process on startupchore in the config.

after exec you get a dimension sys_ServerParameters with attributes cube where places all params in pParamsList variable.
by Drg
Tue May 07, 2019 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: StrToMember MDX function causing a server crash
Replies: 7
Views: 509

Re: StrToMember MDX function causing a server crash

you tried to put more curly braces???

Code: Select all

{GENERATE( {FILTER( TM1SUBSETALL( [Account] ),
	LEN([mycube].([Version].[Active1], [Measure].[myMeasure])) > 0)}
	, {StrToMember("[Account].[" + [mycube].([Version].[Active1], [Measure].[RollupAccount]) + "]")})}
by Drg
Tue May 07, 2019 12:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RulesOverwriteCellsOnLoad is NOT working
Replies: 10
Views: 788

Re: RulesOverwriteCellsOnLoad is NOT working

TM1SERVER_APP_version=TM1SERVER_APP-AW64-ML-RTM-11.0.6.71-0



WORKED FINE.
write some data in cube. append on this slice rule savedataall restart.

RulesOverwriteCellsOnLoad=F data save after disable rule
RulesOverwriteCellsOnLoad=T data loss after disable rule
by Drg
Tue May 07, 2019 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Link unable to access remotely
Replies: 3
Views: 452

Re: PAW Link unable to access remotely

maybe you network do not trust tm1.

try http://10.131.151.141:5895
10.131.151.141 is tm1 adminhost services
by Drg
Tue May 07, 2019 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel data loads and TM1runTI, Hustle
Replies: 11
Views: 1990

Re: Parallel data loads and TM1runTI, Hustle

our security service limits us in possible means therefore we have 2 processes of the parallel queue manager, one based on the flag files, the second based on the cube of the queue with the priorities of the chot processes allows building complex orchestrations, this option looks more reliable but i...
by Drg
Tue May 07, 2019 10:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 4028

Re: RunProcess and threads

As I said, process A and B would have their own transaction sets, so would not see the changes made by the other process. The process that finishes last commits its changes last. Thank you very much for confirming this. To get back to Yuri's point about controlling or orchestrating batch processes....
by Drg
Tue Apr 16, 2019 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOCKS on subset and views wheen mtq > 0
Replies: 3
Views: 609

Re: LOCKS on subset and views wheen mtq > 0

Hi, You code is showing a subset creation procedure, MTQ is applicable for data reads under following conditions: Queries exceeding 10,000 cell visits. Creation of TM1 ‘stargate’ vew. Views containing the results of rule derived calculations. Sorry, what do you mean by Parallel Unloading? Thanks ET...
by Drg
Tue Apr 16, 2019 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM SSO not working in Tm1web on Client machine
Replies: 2
Views: 497

Re: IBM SSO not working in Tm1web on Client machine

We fix it.

You need to double-check(refresh) all the settings of IIS.
there are suspicions that some of the paratmers have been updated for them, which leads to colisees
by Drg
Thu Mar 28, 2019 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: LOCKS on subset and views wheen mtq > 0
Replies: 3
Views: 609

LOCKS on subset and views wheen mtq > 0

Hi to all. Someone noticed a drop in the performance of parallel(runti) processes if mtq is greater than 1. I caught it when I produced parallel unloading from the model and used the same subsets to form views. a piece of code that forms subsets based on a custom user subset: vLastDim=param1; vSub=p...
by Drg
Tue Mar 26, 2019 7:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA Extension
Replies: 5
Views: 1152

Re: JAVA Extension

Hi Mate, As far as I know this has been depreciated in PA. Based on your profile you are on 10.2.2, but given its going out of support in the near future, I would not be investing my time into Java Extensions. Rest API is the way forward. There are open-source Python wrappers available online that ...
by Drg
Tue Mar 05, 2019 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web- Cell Background Color Change
Replies: 5
Views: 1205

Re: TM1 Web- Cell Background Color Change

if we talk abaut tm1 web you can change color directly in
C:\Program Files\ibm\cognos\tm1_64\webapps\tm1web\scripts\tm1web\themes\flat\flat.css
if you use this theme checked in browser in develop mode (f12)
by Drg
Tue Mar 05, 2019 6:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw installation: issue to open the admintool
Replies: 3
Views: 622

Re: Paw installation: issue to open the admintool

You can open your admin tool remotely:
after run start.ps1 and starting admin tool
open in web browser on your local machine url- http://your_paw_server:8888
by Drg
Fri Feb 15, 2019 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: collect logs to database
Replies: 0
Views: 665

collect logs to database

Hi to all Today I wondered why not to collect server logs not into a file but into a relational database. As I see it, there are several solutions: 1 use rest api 2 use log4j (tm1s-log.properties) 3 parse log files by other means 1 Checking the rest api on a large amount of logs, I realized that it ...
by Drg
Fri Sep 28, 2018 7:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How To Compare two dimensions
Replies: 8
Views: 3711

Re: How To Compare two dimensions

I use this approach in all major dimension updates. I update an _Origin version of the dimension first. This copy of the dimension is not used in any cubes so if the update fails for some reason it does not affect any data. I then have processes that compare the updated _Origin dimension to the cur...
by Drg
Wed Sep 26, 2018 8:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How To Compare two dimensions
Replies: 8
Views: 3711

Re: How To Compare two dimensions

Who faced the universal approach of comparing two dimensions with the comparison of hierarchies, implying that the serial numbers can be different? until I came to the conclusion that one of the systems should be considered a donor by another recipient and overwrite the measurement at boot, but this...
by Drg
Wed Sep 19, 2018 2:41 pm
Forum: Useful code, tips and tricks
Topic: Listing of all numerical TI process property values in .pro
Replies: 12
Views: 11760

Re: Listing of all numerical TI process property values in .pro

use java extension to parse *.pro files and collect his variable name with type [string,numeric].
if this is someone I need to post with examples
by Drg
Tue Sep 04, 2018 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 5399

Re: TM1 REST API

Hello Wim. Regarding your questions, some of them are described in the main dock, although I'll notice that they are described in the main dock very poorly, but there is still something there. https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rest_api.2.0.0.doc/tm1_r...
by Drg
Tue Mar 06, 2018 8:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Web Homepage redirection without re-login
Replies: 1
Views: 674

Re: TM1Web Homepage redirection without re-login

I do not think that someone will offer a ready solution. but you need to dig

...\ibm\cognos\tm1_64\webapps\tm1web\scripts\

https://www.ibm.com/support/knowledgece ... brary.html
by Drg
Fri Mar 02, 2018 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 3078

Re: Parallel run vs. ICX

I do not know the nature of such locks, I guess only that this is due to the presentation of data at a certain point in time those. in the moment you read of the cube, somebody put data into this cube but the reading is not blocked and the record is not blocked either, and the data you read is actua...
by Drg
Fri Mar 02, 2018 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Parallel run vs. ICX
Replies: 11
Views: 3078

Re: Parallel run vs. ICX

dear friend, let's imagine a situation where you open an architect and run one of your processes. after you run another architect and try to log in and execute the second process. what result will you get? I guess it depends on what is the purpose of both processes? :) so check that this! is not a ...