Search found 157 matches

by Elessar
Wed Mar 20, 2019 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 CubeUnload
Replies: 5
Views: 127

Re: TM1 CubeUnload

If you turn on Performance Monitor and open }Statsbycube cube, you'll see measures: Memory Used Memory In Garbage When you use CubeUnload, the memory used by cube will moved from "Used" to "Garbage". As David said, it will never be released to OS, but it can be used inside TM1 for creating stargates...
by Elessar
Thu Feb 28, 2019 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 8
Views: 245

Re: Manage Rights when a big chunk of elements are deleted

Cellsecurity cubes are calculated each time when user reads data, they do not affect SecurityRefresh. 1,5h is really long for SecurityRefresh. Do you have rules in ElementSecurity cubes for large dimensions? There is a good practice to update ElementSecurity cubes for dimensions with >500 elements u...
by Elessar
Thu Feb 28, 2019 6:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to get the Data Directory Location in TI?
Replies: 21
Views: 3202

Re: Is there a way to get the Data Directory Location in TI?

Hi, On a related note: does anyone use multiple data directories for 1 model ? We can specify multiple folders in the crg file but I have never been a fan of it. There was a very interesting idea in tm1forum (I couldn't find the thread) to separate DATA to 2 folders: CODE (.rux and .pro files) and ...
by Elessar
Wed Feb 27, 2019 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 8
Views: 245

Re: Manage Rights when a big chunk of elements are deleted

Hi,

How long does it take to do a SecurityRefresh on your server?
by Elessar
Tue Feb 05, 2019 5:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking for Underfed cells
Replies: 10
Views: 714

Re: Checking for Underfed cells

Thanks Wim,

I meant "Please post your investigation's results there: https://www.tm1forum.com/viewtopic.php?f=3&t=10475", so that all the known DebugUtility commands would be in one topic

Sorry for misleading you :)
by Elessar
Mon Feb 04, 2019 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking for Underfed cells
Replies: 10
Views: 714

Re: Checking for Underfed cells

Hi,

I think DebugUtility is for IBM's internal use, and I doubt it's documented well. So they unlikely will share it with the TM1 Society.

There is a topic for collecting known codes: https://www.tm1forum.com/viewtopic.php?f=3&t=10475
@Wim, kindly ask you to post you investigation there
by Elessar
Mon Feb 04, 2019 10:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Information on DebugUtility
Replies: 4
Views: 1742

Re: Information on DebugUtility

Other commands:
  • DebugUtilityEx ('SetMTQ','24') – change MTQ parameter tm1s.cfg
by Elessar
Tue Jan 15, 2019 11:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 applications and uncommitted sandbox data
Replies: 2
Views: 155

Re: TM1 applications and uncommitted sandbox data

Hi, Application reset also removes sandboxes: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.prfmdl_ug.2.0.0.doc/t_prfml_resetting_application_in_contributor.html This can also be done automatically using TM1 app maintenance utility: https://www.ibm.com/support/kno...
by Elessar
Wed Jan 09, 2019 9:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action button: eliminate borders
Replies: 7
Views: 367

Re: Action button: eliminate borders

Hi,

You can change the default action button appearance to any picture you want:
https://www.ibm.com/support/knowledgece ... ppear.html
(Show Background Image)
by Elessar
Fri Oct 26, 2018 10:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule file mismatch in architect and .rux file
Replies: 9
Views: 489

Re: Rule file mismatch in architect and .rux file

Hi,

It can be your temporary *.rux file stored in "C:\Users\<user>\AppData\Roaming\Applix\TM1" folder.
by Elessar
Fri Oct 19, 2018 3:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Convert Tm1p Reports with Active buttons to Tm1 pax
Replies: 2
Views: 301

Re: Convert Tm1p Reports with Active buttons to Tm1 pax

Hi,

In which TM1 version was the tm1p report created? If it's 10.1.1 or lower, you will need to convert it to OpenXML format first: https://www.ibm.com/support/knowledgece ... heets.html
by Elessar
Wed Oct 17, 2018 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing user when using CAM security
Replies: 4
Views: 482

Re: Removing user when using CAM security

Hi, The user-groups information is stored in Cognos Content Store database. This article says that your table name is CMOBJPROPS1 or CMOBJPROPS33 You can connect to this table via ODBC and check in TM1. BUT , if you use active directory: I'm almost sure that when the user is deleted from AD, he will...
by Elessar
Tue Oct 16, 2018 10:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 10
Views: 707

Re: When is a "hierarchy" not a hierarchy

I think it would be a good topic for the new monthly poll :)
by Elessar
Mon Oct 15, 2018 3:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: When is a "hierarchy" not a hierarchy
Replies: 10
Views: 707

Re: When is a "hierarchy" not a hierarchy

Hi,

I disagree with the term "Consolidation", because this will lead to disambiguation with financial consolidation
by Elessar
Mon Sep 17, 2018 8:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Question of the day
Replies: 9
Views: 846

Re: TM1 Question of the day

Thanks, Wim!

For me, the fact that it is not described in documentation and we need to observe this through experiments like physicists or chemists, sounds really weird..
by Elessar
Thu Sep 13, 2018 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Save the rights of a Contributor Application via TI
Replies: 12
Views: 1127

Re: Save the rights of a Contributor Application via TI

Hi, You are lucky, because TM1 Applications Maintenance utility was introduced in 10.2 =) https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.prfmdl_ug.10.2.2.doc/c_tm1_whatsnew_tm1_10_2_tm1_perf_mod_automation.html The 3rd point can be performed by creating a file wit...
by Elessar
Fri Aug 31, 2018 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: export an Application via Script (TM1 Api)
Replies: 13
Views: 1512

Re: export an Application via Script (TM1 Api)

Do not delete files: just copy with replace them from source server. Note: application's information is stored both on application server (security, views list, application properties), and on TM1 server (approval states, owners, etc): application GUID is a key to TM1server-AppServer interaction. TM...
by Elessar
Thu Aug 30, 2018 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: export an Application via Script (TM1 Api)
Replies: 13
Views: 1512

Re: export an Application via Script (TM1 Api)

"TM1 applications" are based on the application server (Tomcat/Websphere), not on the TM1 server. So TM1 API will not help here TM1 app maintenance tool can export/import only rights I think the only way to automate this is to write a batch/powershell script which: 1. Stops target application server...
by Elessar
Thu Aug 30, 2018 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: export an Application via Script (TM1 Api)
Replies: 13
Views: 1512

Re: export an Application via Script (TM1 Api)

Stop, what do you mean by "application"? :)

It's a worksheet application made by Perspectives/PAX, or it's a "TM1 Applications" application with approval hierarchy and CubeViews/Websheets in it?
by Elessar
Thu Aug 30, 2018 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: export an Application via Script (TM1 Api)
Replies: 13
Views: 1512

Re: export an Application via Script (TM1 Api)

Hi,

I assume that server name is used in your worksheet formulas, and that's why the application does not work on another server