Search found 120 matches

by Elessar
Tue Apr 17, 2018 1:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX dependent drop down lists
Replies: 2
Views: 163

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

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

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

Re: }CellSecurity

Hello!

You can create cubes and dimensions with forbidden "}" using TI (CubeCreate and DimensionCreate functions)
by Elessar
Mon Mar 12, 2018 12:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tool to detect overfeeding?
Replies: 16
Views: 6169

Re: Tool to detect overfeeding?

Hi,

Overfeeding "from the Left" can also affect data input (and data load) time (It can be a few seconds, but this can already annoy users)
by Elessar
Wed Mar 07, 2018 8:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Server Name reference in workbook
Replies: 11
Views: 2191

Re: Dynamic Server Name reference in workbook

Hello, In PA 2.0 there is the "TM1PRIMARYDB" function: Returns the primary TM1 server name that the user is authenticated through, even if the user is implicitly logged in to multiple TM1 servers.: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_nfg.2.0.0.doc/c_...
by Elessar
Mon Mar 05, 2018 11:00 am
Forum: Useful code, tips and tricks
Topic: Recovering when an N element has been made a consol
Replies: 5
Views: 493

Re: Recovering when an N element has been made a consol

Hello and thanks,

I think "RulesOverwriteCellsOnLoad" can affect this: like deleting data by a rule. Is it turn ON on your server?
by Elessar
Tue Feb 20, 2018 3:50 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 10
Views: 1000

Re: Using old clients with new planning analytics server

What do you mean by "could not login"? The login window did not appear? Are there any errors?
by Elessar
Tue Feb 20, 2018 2:57 pm
Forum: Useful code, tips and tricks
Topic: Using old clients with new planning analytics server
Replies: 10
Views: 1000

Re: Using old clients with new planning analytics server

Hello! What do you mean by "client"? Architect, Perspectives, CAFE, Perf. Modeler, Cognos Insight?

Usually, you can connect using old clients to new server, but you should turn ON supportpretlsv12clients parameter in tm1s.cfg: http://www-01.ibm.com/support/docview.w ... wg27048181
by Elessar
Thu Feb 15, 2018 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count the number of children and store it as an attribute for the parent
Replies: 5
Views: 410

Re: Count the number of children and store it as an attribute for the parent

Note that this works only if all element weights are "1" (which is true in your case). Otherwise you should create a clone dimension with "1" weights for all elements
by Elessar
Fri Feb 09, 2018 2:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder
Replies: 6
Views: 548

Re: String Feeder

Never put any feeder info into Security Cubes as they get evaluated top down anyway. So macsir's suggestion would work. How you feed a constant has always been a bit of a gripe for me, since constants are not derived, and I believe there should be syntax in TM1 feeders along the lines of FeedByDefa...
by Elessar
Fri Feb 09, 2018 7:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: String Feeder
Replies: 6
Views: 548

Re: String Feeder

You should write feeders from fed or input cells. Do you have any in your cube?

Please read the Feeders proven practices: https://www.ibm.com/developerworks/data ... ge620.html
by Elessar
Tue Feb 06, 2018 2:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot right click to create dimension, cube, ..etc
Replies: 6
Views: 294

Re: Cannot right click to create dimension, cube, ..etc

1. What integratedsecuritymode do you use? (the parameter is in tm1s.cfg file. Path to tm1s.cfg is set in Cognos Configuration)
2. Which user has admin privileges? Only Admin user? (in }clientgroups cube)
3. By which user do you login in Architect?
by Elessar
Tue Feb 06, 2018 12:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot right click to create dimension, cube, ..etc
Replies: 6
Views: 294

Re: Cannot right click to create dimension, cube, ..etc

Hello! You do not have admin rights on the server. Check }clientgroups cube
by Elessar
Wed Jan 17, 2018 7:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Alias update and stargate view
Replies: 5
Views: 435

Re: Alias update and stargate view

I think updating an alias (like updating a rule) will purge all the affected stargates: rules use element aliases, so the calculated data may change after the "alias update". You can turn ON the stargate logging and see how "alias changing" affects the stargates. Sachin has described the stargate lo...
by Elessar
Mon Dec 18, 2017 7:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sigle Sign On TM1
Replies: 5
Views: 408

Re: Sigle Sign On TM1

What about the 2nd question? Does this error occur on BI portal (server.domain.com/ibmcognos)?
by Elessar
Thu Dec 14, 2017 1:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sigle Sign On TM1
Replies: 5
Views: 408

Re: Sigle Sign On TM1

Hi,

1. What do you mean by " single sign is not working"? The login window appears? Is there any errors?
2. Does this error occur on BI portal (server.domain.com/ibmcognos)?
by Elessar
Thu Dec 14, 2017 9:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionSecurity Rules not being fired
Replies: 14
Views: 1109

Re: DimensionSecurity Rules not being fired

tony.wijaya,

This is really strange. You can use the audit log to determine the culprit
by Elessar
Tue Dec 12, 2017 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Always Expanded Workflow Approval Hierarchy?
Replies: 1
Views: 414

Re: Always Expanded Workflow Approval Hierarchy?

Hello all!

I need this option also :) As far as I know, we cannot force the approval hierarchy to be shown expanded by default.
But I can create RFE for this. Will it be popular?