Search found 60 matches

by AnonimusMax
Tue Apr 18, 2017 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Problem ( Range )
Replies: 6
Views: 3922

Re: Feeders Problem ( Range )

ok,

Thank you for fast reply :) i will do that
by AnonimusMax
Tue Apr 18, 2017 8:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Problem ( Range )
Replies: 6
Views: 3922

Re: Feeders Problem ( Range )

Thank you for the fast reply. I already did it with the consolidated element. But let s say i don t want to feed all the years that i have, and i only want 2015,2016. in the all element i have all the years. So it s not possible to select only a range? or only 2-3 values like in the left side? Thank...
by AnonimusMax
Tue Apr 18, 2017 8:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Problem ( Range )
Replies: 6
Views: 3922

Feeders Problem ( Range )

Hi, I have 2 cubes with the following structure: Cube 1: Dimensions: Year, Month, BusinessLine, ProductType, Stage, Measures Cube2: Dimensions: Year, YearTo, Month, MonthTo, BusinessLine, ProductType, Stage, Measures Rules in Cube 2: SKIPCHECK; ['Measure']=N:DB('Cube 1',!Year,!Month,!BusinessLine,!P...
by AnonimusMax
Thu Mar 23, 2017 8:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 as DataSource
Replies: 7
Views: 5465

Re: TM1 as DataSource

David Usherwood wrote:You don't have to create an FM package - BI can consume a TM1 cube as a data source.
How can i consume a cube as data source withoupackage? I want to create reports in report studio
by AnonimusMax
Tue Mar 21, 2017 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 as DataSource
Replies: 7
Views: 5465

Re: TM1 as DataSource

Ok, Thank you. So my last question! I have the security for dimesnions set in TM1. So when an user logs into TM1WEB he can only see the elements that he has access on. If i use Report Studio, the behavior will be same? An user can only see the 'countries' that he has access set on TM1? Or should i d...
by AnonimusMax
Tue Mar 21, 2017 1:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 as DataSource
Replies: 7
Views: 5465

Re: TM1 as DataSource

Hi Thank you for fast reply, I want to use Data in the report, data coming from TM1. I want to use report studio to create reports. Can you tell me what you meant by "if you literally just want to have TM1 cube viewers in BI you can use the URL API." cube viewers? Another question. Now we ...
by AnonimusMax
Tue Mar 21, 2017 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 as DataSource
Replies: 7
Views: 5465

TM1 as DataSource

Hi, I have to do a report using Cognos BI and having cubes from TM1 as a data source. I know i can import the cubes into BI using Framework manager and creating a package and publish this package. Is there another way to do this without using Framework Manager? Can I somehow use the cubes by doing s...
by AnonimusMax
Fri Mar 10, 2017 1:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Command problem
Replies: 3
Views: 3117

Re: Execute Command problem

Reopen Topic. I did what was suggest on the link that you sent me. So for my DEV environment everything is running in parallel. I have 3 processes that update the same cube with data from DB. On my dev environment they run in parallel, on my INT environment they don t. They put each other on HOLD. I...
by AnonimusMax
Wed Mar 08, 2017 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Command problem
Replies: 3
Views: 3117

Re: Execute Command problem

I already did what he suggested in the post.
It works. Thank you for the reply :)
by AnonimusMax
Wed Mar 08, 2017 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bat to execture a process
Replies: 2
Views: 2555

Re: Bat to execture a process

thank you, solved it :D
by AnonimusMax
Tue Mar 07, 2017 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bat to execture a process
Replies: 2
Views: 2555

Bat to execture a process

Hi, I have the following problem. I am trying to create e .bat file that can run a process when i run the bat. so this is the text that i palced in the bat. pls tell me where I did wrong. @Echo on "C:\Program Files\ibm\cognos\tm1_64\bin64\TM1RunTI.exe" -server servername -process "pro...
by AnonimusMax
Tue Mar 07, 2017 12:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Execute Command problem
Replies: 3
Views: 3117

Execute Command problem

Hi, I have the following problem. The server has 16 cores of 2.5. I have a process that has 6 Execute Command in it. The code is placed in prolog Tab. The problem is that this 6 processes that run from ExecuteCommand, don t start in parallel. They run 2 at once, after this 2 end another one start an...
by AnonimusMax
Tue Feb 07, 2017 8:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flag is not updated
Replies: 8
Views: 4788

Re: Flag is not updated

So i placed like this in the code:

IF(ViewExists(Cube,View)>0);
CELLPUTS('The view already exists', 'ErrorCubeName', 'TI_Error_Msg', 'string');
ENDIF;

and in the process fail message with DBR.
Maybe I am doing something wrong. But like this, is not working.
by AnonimusMax
Mon Feb 06, 2017 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Flag is not updated
Replies: 8
Views: 4788

Re: Flag is not updated

Hi Tomok,

I know the solution you have pointed out. I tryed it. The problem is that the flag is not updated on that moment.
It updated the message after a few minutes...Not on that exact moment. So if 2 users press the button 1 after another, the message will be wrong..

Thank you
by AnonimusMax
Fri Feb 03, 2017 10:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load Problem
Replies: 6
Views: 3762

Re: Load Problem

I have hundreds of thousands of rows, so i don t think that can be an option. The execution time will increase a lot right?
Is there another way to import new data into dimensions?
by AnonimusMax
Fri Feb 03, 2017 10:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Chrased
Replies: 7
Views: 5034

Re: Tm1 Chrased

No, i do not turn it off...We are able to see the files in the log folder.
by AnonimusMax
Fri Feb 03, 2017 10:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load Problem
Replies: 6
Views: 3762

Re: Load Problem

No i didn t test with the regular... Can that cause some problems?
by AnonimusMax
Fri Feb 03, 2017 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: To use or not to use persistent feeders?
Replies: 20
Views: 20247

Re: To use or not to use persistent feeders?

Can PersistentFeeders=T cause a TM1 Crash?

yes from Cognos TM1 version 10.1.1 the PersistentFeeders were turned to T
by AnonimusMax
Fri Feb 03, 2017 9:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Chrased
Replies: 7
Views: 5034

Re: Tm1 Chrased

I have manually started the Master process that run before the server crashed ( with same input parameters) and it finished with no error. The processQuit was part of a process that was started by the Master Load Process. what do you mean by "have you tried starting the server without running t...
by AnonimusMax
Fri Feb 03, 2017 9:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Chrased
Replies: 7
Views: 5034

Re: Tm1 Chrased

Thank you for the fast response. They don t exist. There is a Master Load Process that first runs Dimension update, then updates the cubes , then it does some calculation and after that is exporting a CSV that is bulk load into a Oracle DB ( the csv ). The Information in coming from ORACLE with an S...