Search found 136 matches

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

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

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

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

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

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

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

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

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

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

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...
by Elessar
Thu May 31, 2018 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Empty rules file and sparsity alogrithm
Replies: 3
Views: 342

Re: Empty rules file and sparsity alogrithm

This was removed in one of the (TM1 10.2.2 - PA 2.0) versions (I don't remember in which one). In PA 2.0, the empty rule does not turn off the sparsity algorithm
by Elessar
Thu May 24, 2018 9:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX has blank task pane
Replies: 1
Views: 261

Re: PAX has blank task pane

Hello,

When you create connection in PAX, what port do you use? Tm1 app's (default 9510) or PAW's (default 9580)? Should be PAW's
by Elessar
Wed May 23, 2018 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0 - IE Browser issues
Replies: 5
Views: 545

Re: Planning Analytics 2.0 - IE Browser issues

Also, check the compatibility view settings: The site should not be added to the list, and (if it is added to local intranet) the "Display local intranet sites in Comp. view" option should be unchecked
by Elessar
Wed May 23, 2018 12:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0 - IE Browser issues
Replies: 5
Views: 545

Re: Planning Analytics 2.0 - IE Browser issues

Hi,
Is your server added to "local intranet" in IE security settings?
by Elessar
Fri May 18, 2018 8:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DataAdmin is not working properly
Replies: 2
Views: 275

Re: DataAdmin is not working properly

Hello,

What version do you use?
Are there any differences in tm1s.cfg's of working and non-working instances?
by Elessar
Tue Apr 17, 2018 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX dependent drop down lists
Replies: 3
Views: 413

Re: PAX dependent drop down lists

Hello,

In PAX, you can use the new "TM1ELLIST" function with your MDX in it:
https://www.ibm.com/support/knowledgece ... llist.html
by Elessar
Wed Apr 04, 2018 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Interesting findings in rules
Replies: 4
Views: 767

Re: Interesting findings in rules

(Was long ago in 9.5.2)
This broke my brain, when I tried to analyze a rule with 3 (!) SKIPCHECKS

The rule begins to be evaluated from the last SKIPCHECK statement
by Elessar
Wed Mar 21, 2018 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Server Name reference in workbook
Replies: 11
Views: 2613

Re: Dynamic Server Name reference in workbook

This work only in PAX,
But you can use it in Perspectives (with error displayed) and upload workbook to websheet: this will work without PAX (but will be difficult to debug).
by Elessar
Fri Mar 16, 2018 7:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }CellSecurity
Replies: 8
Views: 911

Re: }CellSecurity

Hello!

You can create cubes and dimensions with forbidden "}" using TI (CubeCreate and DimensionCreate functions)