Search found 145 matches

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: 246

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: 246

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: 428

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: 709

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: 867

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: 867

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: 867

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: 867

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
by Elessar
Wed Aug 29, 2018 8:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Creating a }Picklist cube in a TI process
Replies: 3
Views: 165

Re: Creating a }Picklist cube in a TI process

Hi,

Try to call SaveDataAll in epilog
by Elessar
Tue Jul 24, 2018 3:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 9.5 to PA
Replies: 3
Views: 233

Re: TM1 9.5 to PA

Hi, Upgrading from 10.2 to PA would not be a problem. The real challenge will be upgrading from 9.5 to 10.2 The most difficult tasks will be: 1) Upgrading the contributor applications: Application types (Approval, Responsibility, Central) are added, as well as "Enforce Rights" and another new parame...
by Elessar
Fri Jul 20, 2018 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calling DBRW function without mentioning instance name in the first argument
Replies: 6
Views: 335

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

Hi, If you are on PAL 2, you can use "TM1PRIMARYDBNAME()" worksheet function to get the instance name: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_wrk_primarydbnamefunction.html If this is for migrating purpose, another method is disc...
by Elessar
Thu Jul 19, 2018 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 perspective to send mails automatically
Replies: 4
Views: 291

Re: TM1 perspective to send mails automatically

Hello,

TM1 itself cannot send e-mails. You need to launch a TI-process launching a PS script sending the e-mail

This was discussed here:
http://www.tm1forum.com/viewtopic.php?t=11815
http://www.tm1forum.com/viewtopic.php?t=12453
by Elessar
Wed Jul 18, 2018 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to refresh all Contributor Views of all users globally?
Replies: 7
Views: 331

Re: Is there a way to refresh all Contributor Views of all users globally?

Hi, There is a little (0,1%) chance TM1 App Maintenance utility can do this, I didn't check: https://www.ibm.com/support/knowledgecenter/en/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.prfmdl_ug.10.2.2.doc/c_tm1_app_automatingtaskstool.html If not: 1) Kick all the users (or stop the server) 2) Delete the use...
by Elessar
Tue Jul 17, 2018 6:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drop Down Calendar Selection
Replies: 21
Views: 6709

Re: Drop Down Calendar Selection

Hi Elessar, haven’t had a chance to check this but I know I’ve had it working in tm1 websheets - do you mean it doesn’t work in the cube viewer in TM1 web or do you mean websheets? Or both? If so what fp are you on. Hi, I had tested this only in a cube viewer. Now i've tested the websheet: it does ...
by Elessar
Mon Jul 16, 2018 9:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drop Down Calendar Selection
Replies: 21
Views: 6709

Re: Drop Down Calendar Selection

UPD: The calendar picker works by default (for "date" number format) in PA 2.0, but only in PAW :(
In TM1web, you still need to use picklists
by Elessar
Fri Jun 29, 2018 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web does not show any TM1 Service
Replies: 6
Views: 424

Re: TM1 Web does not show any TM1 Service

Which link are you using? "localhost:port/tm1web" or "FQDN:port/tm1web"?
by Elessar
Fri Jun 22, 2018 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }Stats by Rule Cube
Replies: 2
Views: 248

Re: }Stats by Rule Cube

Hello,

You should turn ON the performance monitor:
  1. PerformanceMonitorOn=T in tm1s.cfg (needs restart in TM1 10.2.2, don't need in PA 2.0)
  2. Right-click on a server in Architect, launch the performance monitor
Do not forget to turn it OFF after you finish.
by Elessar
Wed Jun 20, 2018 1:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To get the element name in dimension using the attributes name in tm1
Replies: 1
Views: 165

Re: To get the element name in dimension using the attributes name in tm1

Hi,

If the attribute is alias, you can just use "{[Dimension].[AliasValue]}" and switch alias OFF in subset.
If it is not, there can be several elements with this attribute, so you can filter by this attribute: {FILTER( {TM1SUBSETALL( [Dimension] )}, [Dimension].[AttributeName] = "AttributeValue")}
by Elessar
Wed Jun 13, 2018 7:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 applications not available in Cognos Analytics
Replies: 2
Views: 249

Re: TM1 applications not available in Cognos Analytics

Hello, The "Applications" folder name is set in pmpsvc_config.xml file (<tm1 install>/webapps/pmpsvc/WEB-INF/configuration/). Is it correct here? Is it a completely new blank server, or you have migrated from another instance? If so, from which version? Did you migrate Content Store database? Try to...