Search found 159 matches

by Drg
Wed Jul 24, 2019 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reclaiming disk space after PAW upgrade
Replies: 5
Views: 3163

Re: Reclaiming disk space after PAW upgrade

gtonkin wrote: Tue Jul 23, 2019 7:34 am The only way I have cleaned up stubborn containers in the past has been a sledge-hammer approach i.e. docker-ci-zap
Unfortunately this removes ALL containers in the WindowsFilters folder but is useful when you have broken your PAW beyond repair.
Oh nice, thx i try it!
by Drg
Tue Jul 23, 2019 7:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reclaiming disk space after PAW upgrade
Replies: 5
Views: 3163

Re: Reclaiming disk space after PAW upgrade

We are faced with such a situation that the docker does not see containers that have remained a rudiment from previous versions. The only solution that I found is to completely delete the folder manually using utilities. docker creates files that cannot be deleted using standard windows methods. Any...
by Drg
Fri Jul 19, 2019 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX has blank task pane
Replies: 5
Views: 6601

Re: PAX has blank task pane

Hi, show us screenshot and config connection PAX :shock:
by Drg
Thu Jul 18, 2019 9:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 13861

Re: Slow Login in Architect

Some time ago, we also noticed the problem of the slow work of Architect (but here I’m not only talking about logging) that was caused by the failure of several processes creating subsets and the views of ~ 100 views for each cube.

maybe at some point you have a lot of unnecessary subsets or views?
by Drg
Thu Jul 18, 2019 8:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Occasionally stuck making ODBC connection
Replies: 5
Views: 3476

Re: Occasionally stuck making ODBC connection

I think you need more information from tm1 logs: TM1.ODBC TM1.Sql TM1.SQLAPI TM1.Lock TM1.Lock.Exception see more here: https://www.tm1forum.com/viewtopic.php?t=12170 This example how create extended logs to different file: #tm1s-log.properties log4j.logger.TM1.Lock.Exception=DEBUG, LOCKS log4j.appe...
by Drg
Wed Jul 17, 2019 1:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 WEB context area
Replies: 3
Views: 2296

Re: TM1 WEB context area

you can change class

Code: Select all

.tm1webHidden {
display: none !important; <--change this 
}
In flat.css on default themes(flat)

BUT i do not find how show horizontal scroll tab. Maybe some one skilled find the solution.
by Drg
Wed Jul 17, 2019 8:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create temp view and open them by returnviewhandle
Replies: 3
Views: 2717

Create temp view and open them by returnviewhandle

At someone it turned out to create a temporary view and subsets and return them in }dril process by returnviewhandlel? Or is it impossible? My research resulted in the fact that if you use temporary subsets or views, the view is deleted before the is actually returned. But In fact, the returnviewhan...
by Drg
Wed Jul 17, 2019 7:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 3520

Re: PowerShell issue

but it also brings a little pain with quotes and double quotes Indeed, don't you close the double quotes in the code ? Oh Yes, I hurried with the answer so I missed them [corrected] But I thought the essence of the question is that you don’t know how to execute the scripts. However, I was talking a...
by Drg
Tue Jul 16, 2019 6:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PowerShell issue
Replies: 5
Views: 3520

Re: PowerShell issue

Hi all i use next construction tu run powershell comands. powershell -command "& { <write your script here> } PSscript='powershell -command "& {set-content -path '|Filepath|' -value '|exportstring|' }"'; EXECUTECOMMAND( PSscript , 1 ); this saves us situations when the script ...
by Drg
Thu Jul 04, 2019 6:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Any risk to copy Cell Annotation values ?
Replies: 2
Views: 2022

Re: Any risk to copy Cell Annotation values ?

from experience I will say that CELLPUTS uses the Trim function for Value, so if your comments start / end with separator characters, then there is a big chance to get something that you did not expect.
Otherwise, this is a regular cube with strings.
by Drg
Thu Jul 04, 2019 6:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Programmatically Update Websheets to TM1 Web
Replies: 15
Views: 10861

Re: Programmatically Update Websheets to TM1 Web

We use the following strategy to change the destination server: We unpack the excel file and use the powershell scripts to change the server name in all files. We also use similar logic for the BI contentstore exel. There is one thing, but namely if you have active buttons in the forms of prospects,...
by Drg
Thu Jul 04, 2019 5:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW: subset MDX works in one cube view, not in another
Replies: 3
Views: 1945

Re: PAW: subset MDX works in one cube view, not in another

Hi
Perhaps the problem is that the PAW does not know how to currentmeber?
As far as I remember for the operation of this filter, the [Accounts Master] element should be in the context of the view.
by Drg
Wed Jul 03, 2019 5:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM License Metric Tool?
Replies: 17
Views: 9358

Re: IBM License Metric Tool?

from his memory came across once. The installation consists of ~ 42 steps. In principle, everything is not difficult but depends on your infrastructure.
by Drg
Wed May 29, 2019 10:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 5110

Re: Getting all the children of an element

To add to my previous question how to use this MDX from TI to iterate through all the elements in the subset {TM1DRILLDOWNMEMBER( {[Dimension].[Element]}, ALL, RECURSIVE )} Thanks Best solution to create dynamic subset: MDX='your mdx'; vLastDim='DimensionName'; vSubset='randomName'; SubsetCreate(vL...
by Drg
Mon May 27, 2019 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: File is open in IBM Cognos TM1 Server
Replies: 3
Views: 2148

Re: File is open in IBM Cognos TM1 Server

Yes, this problem is also found at 10.2.2 fp 7, there is still no solution except restarting.
by Drg
Fri May 17, 2019 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RulesOverwriteCellsOnLoad is NOT working
Replies: 10
Views: 4685

Re: RulesOverwriteCellsOnLoad is NOT working

Yes today we update to 2.0.7 Other configs. [TM1S] ServerLogging=F SecurityPackageName=Kerberos IntegratedSecurityMode=1 UseSSL=T ServerName=HauptAbu1 DataBaseDirectory=D:\PAModels\HauptAbu1 AdminHost= PortNumber= ClientMessagePortNumber= Savetime= Downtime= LicenseMetricTime= ProgressMessage=True A...
by Drg
Fri May 17, 2019 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RulesOverwriteCellsOnLoad is NOT working
Replies: 10
Views: 4685

Re: RulesOverwriteCellsOnLoad is NOT working

I have read the documentation and I understand its name as shown in the picture below. Another question that I found an interesting feature is that it is marked with the third option. I suppose this is updated with the update of the cube and in combat situations it will lead you according to the doc...
by Drg
Wed May 08, 2019 6:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 21
Views: 19339

Re: RunProcess and threads

Why having both? To make support more intellectually stimulating? :-) How do you do check for task completion via cubes, do a runTI that reads the cube contents? What happens if this 'check' process itself fails, would you be able to differentiate between it running successfully or failing silently...