Search found 110 matches

by vladino
Wed Apr 06, 2016 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perfromance Modeler lags when editing rule
Replies: 5
Views: 2813

Re: Perfromance Modeler lags when editing rule

jim wood wrote: It shouldn't be, but I wouldn't ignore it. A rule is, as I mentioned, just text at the end of the day, but PM builds link and all that kind of good stuff so it may handle the rule differently
Is there anything else that might cause this issue?
by vladino
Wed Apr 06, 2016 1:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perfromance Modeler lags when editing rule
Replies: 5
Views: 2813

Re: Perfromance Modeler lags when editing rule

Well you wouldn't get it in architect as your'e opening a text document. It'd have to be huge to give you some lag. As PM it kind of makes sense. It needs to refresh the whole file rather than just what's on display. I would check your network connection between the server and your machine. It coul...
by vladino
Wed Apr 06, 2016 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perfromance Modeler lags when editing rule
Replies: 5
Views: 2813

Perfromance Modeler lags when editing rule

Hi guys, I'm experiencing lags when editing a rule in PM. Every single character has a delay of few seconds (i.e. when I type "STET" I need to wait approx 10s to see the result in the rule). The issue appears only on quite large rules (more than 1000 lines). When I try to edit the same rul...
by vladino
Tue Dec 08, 2015 9:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to customize TM1
Replies: 8
Views: 5044

How to customize TM1

Hello all,
I would like to customize the look of TM1, i.e. text on top of application list (default is "IBM Cognos TM1 Applications"), logo in top right corner (currently IBM) etc.

Is there any way how to do this?

BR
Vladino
by vladino
Thu May 28, 2015 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Bedrock.Cube.Data.Export" does not export all measures
Replies: 2
Views: 2510

"Bedrock.Cube.Data.Export" does not export all measures

Hi guys, I'm wondering if anybody has experienced the same strange behavior as I did just few minutes ago... I'm using Bedrock library and in this case I need to export data for specific version. So I used this: ExecuteProcess('Bedrock.Cube.Data.Export', 'pCube','plan', 'pView','', 'pFilter','versio...
by vladino
Fri May 22, 2015 10:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders not working?
Replies: 4
Views: 4137

Feeders not working?

Hi all, I'm a bit depressed with my situation and I hope that someone helps me... :-/ I have two cubes - one with actuals and one for planning purposes. First of all I would like to link actuals from actuals cube to planning cube. Dimensionality is as follows (dimension order applied): actuals (regi...
by vladino
Wed May 13, 2015 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ConsolidateChildren and spreading from nodes
Replies: 1
Views: 2157

ConsolidateChildren and spreading from nodes

Hi all,
I have discovered that when using ConsolidateChildren to consolidate hierarchies I'm unable to spread data from nodes to children.

Is there any way how to combine these two methods?

Thanks in advance!

BR
Vladino
by vladino
Fri May 01, 2015 7:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to filter #NA (i.e. UNDEF) values in TI
Replies: 10
Views: 8680

Re: How to filter #NA (i.e. UNDEF) values in TI

It's getting more and more weird... I have traced the calculation up to the source and it should be zero (it is consolidated year value, months are linked to another cube with no data in months -> but months in target cube contain 4,9e-324, therefore yearly consolidated value also has non-zero value...
by vladino
Thu Apr 30, 2015 10:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to filter #NA (i.e. UNDEF) values in TI
Replies: 10
Views: 8680

Re: How to filter #NA (i.e. UNDEF) values in TI

Hmmm, still not solved... :-/ I have replaced slash with backslash to avoid dividing by zero. But I have discovered that TM1 uses #NA also for infinity, for example dividing by number which is almost zero (3e-323 in my case). Does anyone know how to deal with this? I need to copy this cell from one ...
by vladino
Wed Apr 22, 2015 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to filter #NA (i.e. UNDEF) values in TI
Replies: 10
Views: 8680

Re: How to filter #NA (i.e. UNDEF) values in TI

If you make sure you use \ rather than / in your rules it solves the division by zero problem you're experiencing in that the rule engine will give 0 rather than then cell error.
That's it! Thanks a lot!
by vladino
Wed Apr 22, 2015 6:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to filter #NA (i.e. UNDEF) values in TI
Replies: 10
Views: 8680

Re: How to filter #NA (i.e. UNDEF) values in TI

I'm talking about division by zero etc. This gives you "NaN" values (which I translate as #NA).
by vladino
Tue Apr 21, 2015 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to filter #NA (i.e. UNDEF) values in TI
Replies: 10
Views: 8680

How to filter #NA (i.e. UNDEF) values in TI

Hi guys,
I'm trying to filter out #NA values in TI process - I don't want them to be copied from one cube to another one.

I have tried this:
IF (NVALUE <> UNDEF)
...

But this is not working. :-/

Could anyone help me with this issue?

BR
Vladino
by vladino
Wed Feb 11, 2015 6:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Disable rules in cube
Replies: 1
Views: 2220

Disable rules in cube

Hi all, I need to disable rules in a cube. The situation is following: I have measures dimension where some members have N-level expression. This dimension is shared in two cubes. So in both cubes the rules are generated automatically according to N-level expressions in the measures dim. I would lik...
by vladino
Fri Dec 03, 2010 8:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: }ElementSecurity cube missing
Replies: 1
Views: 1979

}ElementSecurity cube missing

Hi all, I don't know why bud I'm missing element security cube for one of my dimensions. I was trying to create it manually but it doesn't allow me to create cube starting with "}". How to create this cube? That dimension is very large and I want to assign security for some nodes only. Tha...
by vladino
Tue Nov 30, 2010 1:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Import security from file
Replies: 3
Views: 2796

Re: Import security from file

Security in TM1 is stored in cubes with the names }CubeSecurity, }DimensionSecurity and }ElementSecurity_NameOfDimension. You can update the data in these cubes with a TI process the same as you can update any other cube. Just make sure you do a SecurityRefresh command afterwards, as well as design...
by vladino
Tue Nov 30, 2010 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Import security from file
Replies: 3
Views: 2796

Import security from file

Hi all, we are using Cognos 8 security in our TM1 environment. There are tens of user classes in CAM which are updated on daily base. It will be time consuming to create and update security assignments manually, therefore we want to load security assignments to TM1 automatically from file instead. I...
by vladino
Tue Nov 16, 2010 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fixed point-of-view in all cube views
Replies: 3
Views: 2181

Fixed point-of-view in all cube views

Hi all, we have created an application for web client with multiple views. These views are built upon multiple cubes with nearly the same dimensionality. Is it somehow possible to fix context dimensions to use the same member for all of these views? Ie. when I select specific product in first view I...
by vladino
Tue Nov 16, 2010 11:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: *SOLVED* TM1 Workflow client not visible in Web
Replies: 0
Views: 1197

*SOLVED* TM1 Workflow client not visible in Web

Hi all, I have installed TM1 workflow client onto my machine. It is working correctly in Excel (I can select process etc.), but I cannot see workflow panel in web client. Where the problem should be? Thanks, Vladino EDIT Solved - chapter Modifying IBM Cognos TM1 Web Configuration Parameters in TM1 O...
by vladino
Fri Nov 12, 2010 10:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prev and Next attributes not working
Replies: 0
Views: 1285

Prev and Next attributes not working

Hi all, I have following rules to calculate previous and next year values: ['Revenues','Last Year']=N:DB('Cube',ATTRS('Year',!Year,'Prev'),'This Year'); ['Revenues','Next Year']=N:DB('Cube',ATTRS('Year',!Year,'Next'),'This Year'); Attributes are populated properly, but it is not working. Any idea? T...