Search found 24 matches

by kugors
Fri Dec 06, 2013 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: BedrockTM1 Processes for Create Security Group
Replies: 4
Views: 5254

Re: BedrockTM1 Processes for Create Security Group

The AddGroup command in TI simply adds a group within the TM1 server. This is not validated against any external security provider the group is just for TM1. Any groups created in this way will not be visible in Cognos Security Administration as they are not CAM groups. Actually, when you provide C...
by kugors
Fri Nov 15, 2013 1:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem in Running Processes from Tm1Web While any applicati
Replies: 1
Views: 1970

Re: Problem in Running Processes from Tm1Web While any appli

I think your problem might be related to data reservation http://www.tm1forum.com/viewtopic.php?p=35520#p35493
But it is lucky guess, because of lack of information (TI logs for example)

*EDITED - wrong link
by kugors
Wed Aug 21, 2013 8:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI SQL performance issue
Replies: 14
Views: 10024

Re: TI SQL performance issue

Hi, I had similar issue while loading result data to TM1. I used workaround to deal with it. I created table in SQL with columns from select and function that's populate this table with data. I placed this function in prolog of TI and put simple select * from table in query. In My case it worked. HTH
by kugors
Tue Apr 16, 2013 10:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access tables based on elist in TM1
Replies: 12
Views: 9739

Re: Access tables based on elist in TM1

I don't think that is what he wants to achieve. I want the bahaviour: When I enter the hierarchy in A I want to only see cube AA if I enter in B only see BB and in the case of C I would only see CC In my case, users had functionality, that when they entering different nodes, they had different view...
by kugors
Tue Apr 16, 2013 9:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access tables based on elist in TM1
Replies: 12
Views: 9739

Re: Access tables based on elist in TM1

I don't think that is what he wants to achieve. I want the bahaviour: When I enter the hierarchy in A I want to only see cube AA if I enter in B only see BB and in the case of C I would only see CC In my case, users had functionality, that when they entering different nodes, they had different views...
by kugors
Tue Apr 16, 2013 7:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Access tables based on elist in TM1
Replies: 12
Views: 9739

Re: Access tables based on elist in TM1

Jorge, I have just finished "migration" my client from Planning to TM1, and know what you want to achieve. The answer is simple - you can't do it. In Planning you could show different data (cubes, elements, views) in different nodes. In TM1 you apply security to cubes, dimensions and eleme...
by kugors
Wed Apr 03, 2013 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a TI only if the data has changed
Replies: 10
Views: 6815

Re: Running a TI only if the data has changed

Maybe leave decision of processing current intersection to operators. You could add new measure (for example "Process"), and tell users that they have to put 1 in it, when they want to update reporting cube. Then yours TI could work only for intersections with 1 (or <>0), send data to repo...
by kugors
Fri Jul 13, 2012 9:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder best practice question
Replies: 7
Views: 5018

Re: Feeder best practice question

Thank you,

That's want i wanted to know.
by kugors
Fri Jul 13, 2012 9:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder best practice question
Replies: 7
Views: 5018

Feeder best practice question

Hi all, I have a theoretical question about best practice to write feeders. Let's assume that i have three cubes with rules: Cube A - filled manual Cube B - some measures taked from A, some filled manual Cube C - all taken from B Now I can write fedders in to ways: 1. A => B, B => C 2. A => B;C, B =...
by kugors
Wed Jul 11, 2012 11:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with creating subset via TI
Replies: 4
Views: 3221

Re: Issue with creating subset via TI

Thanks you all for replies. I have read more about MDX and manage to do what I want in two MDX based querys.
by kugors
Wed Jul 11, 2012 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No hierarchy in contributor view
Replies: 2
Views: 1934

Re: No hierarchy in contributor view

As i know this is how contributor works. It will show you only nodes from approval hierarchy, and only nodes can be opened in contributor. You can open consolidations in reviewer only, and only in rewiever you have hierarchy. IBM integrated contributor and reviwer in CE 10.1, and in this version you...
by kugors
Wed Jul 11, 2012 8:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with creating subset via TI
Replies: 4
Views: 3221

Re: Issue with creating subset via TI

Thank you Steve. I suspected that I'm missing something simple... --Edited-- I have checked this, and it's working but it's not enough for me. I want to make few steps, and Prolog and Epilog gives me only two. I tried to create nested processes (executing it from for example Prolog) hoping that data...
by kugors
Tue Jul 10, 2012 1:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Contributor data commit and remains blue
Replies: 9
Views: 8002

Re: TM1 Contributor data commit and remains blue

I had similiar problem. In my case it was coused when there was two ways to enter value - manual and from calculation. ['NetSales']=N:IF(['Price'] <> 0 & ['QTY']<>0,['Price'] * ['QTY'],STET); When you enter NetSales manual, then Price and Qty, Contibutor tries to save data over rule calculated v...
by kugors
Tue Jul 10, 2012 1:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with creating subset via TI
Replies: 4
Views: 3221

Issue with creating subset via TI

Hi All, I want to create Drill process to another cube. One of destinations cube elements have MDX subset, that's pointing another subset, to walkaround problem with deleteing subsets when they are useb by view (found on this forum). {[Dim].[Subset_for_recreation]} Now i can delete Subset_for_recrea...
by kugors
Mon Jun 18, 2012 2:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill process question
Replies: 6
Views: 3954

Re: Drill process question

@tomok - mapping was a bad word, passing is what I'm trying to achieve

@qml - next time I wil describe my problem better.

@Steve - Thanks, that's exactly what I was looking for.
by kugors
Fri Jun 15, 2012 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill process question
Replies: 6
Views: 3954

Re: Drill process question

I have done TI process and rule, and it is working, but it doesn't map these two dimensions. Lets say I have two cubes: C1 - dimensions: Version, Department C2 - Version, Department_1 When i drill from C1 to C2, Version dimension is mapped correctly, and Department not. It is showing default Deprtme...
by kugors
Fri Jun 15, 2012 12:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill process question
Replies: 6
Views: 3954

Drill process question

Hi all, I'm trying to drill from one cube to another. I have two different named dimensions in this cubes, but with exactly the same elements. I did this because these dimensions are in aproval hierarchy in different Planner aplications. If there is a way to map them in drill process? I tried to map...
by kugors
Thu Dec 15, 2011 10:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with Feeder
Replies: 21
Views: 14680

Re: Problem with Feeder

FEEDSTRINGS;

I tried this after and before SKIPCHECK;

I let you all know what will IBM say to my service request.
by kugors
Tue Dec 13, 2011 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with Feeder
Replies: 21
Views: 14680

Re: Problem with Feeder

I have done few more tests. I read about ReevaluateConditionalFeeders parameter, and i don't think that's my situation, but checked it and it doesn't work. Changing order of SKIPCHECK and FEEDSTRING also doesn't work. I'm on Cognos Express 9.5 and maybe that's the point. After looking at IBM example...
by kugors
Wed Dec 07, 2011 6:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem with Feeder
Replies: 21
Views: 14680

Re: Problem with Feeder

Isn't this one a simple case of needing to include a FEEDSTRINGS command in the source cube? As I understand FEEDSTRING, this command is used when you want fed element that is a string. I want to fire feeder when string element change and feed simple element. Also I tried put FEEDSTRING in rule in ...