Search found 24 matches

by jyoung66
Thu Mar 30, 2017 4:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics - PAX DBS function
Replies: 3
Views: 2089

Re: Planning Analytics - PAX DBS function

It didn't work when copying and modifying a DBRW formula with the equals sign in it, BUT copying and modifying without the equals for some reason DID work!?! So copying and modifying =DBRW($A$1,$B$2,$B5,$A5,J$4) to =DBSW(100, $A$1,$B$2,$B5,$A5,J$4) DIDNT work But copying and modifying DBRW($A$1,$B$2...
by jyoung66
Thu Sep 01, 2016 6:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 14701

Re: Dynamic Datasource Path

Did you allow for redundant columns in the text file vs he actual runtime data source? (I normally use an artificial 25 dim cube as a dummy data source for such processes which is there on dev but not prod. You can easily switch from a process defined using a view to text. I would have also thought...
by jyoung66
Mon Sep 29, 2014 12:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New instance client log in problem
Replies: 2
Views: 1205

Re: New instance client log in problem

Hi There

For those who were hoping for an answer i thought i would close the loop:

Problem was that the port number int the config file had to be added to the firewall on the server.
by jyoung66
Fri Sep 26, 2014 6:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New instance client log in problem
Replies: 2
Views: 1205

New instance client log in problem

Hi I have a new instance that I can log into while remoting in to the server, but not while on my client. I have integrated security set to 1 at the moment and (although the prod environment is 5 and works fine) On the client, I can see the instance but when I double click to log on it waits and tim...
by jyoung66
Sun Jun 29, 2014 2:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process re-starting in a chore TM1 10.2.0
Replies: 3
Views: 1610

Re: Process re-starting in a chore TM1 10.2.0

Actually, while this was PART of the problem (although it did go part of the way to fixing so thank you) there seemed also to be a conflict with another chore; the first process in the second chore had to re-start after the first had finalised (about 3.5 hours later!) My suspicion is that the first ...
by jyoung66
Sat Jun 28, 2014 7:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process re-starting in a chore TM1 10.2.0
Replies: 3
Views: 1610

Re: Process re-starting in a chore TM1 10.2.0

Thank you

Yes I see in the logs there are always SaveDataAll happening around the time of the restarts

that looks like it may be the issue
by jyoung66
Sat Jun 28, 2014 6:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process re-starting in a chore TM1 10.2.0
Replies: 3
Views: 1610

Process re-starting in a chore TM1 10.2.0

Hi Hoping someone can help with an issue that I have not come across before A long running chore has processes that seem to be restarting, the chore is only scheduled once at 12:30am local time I have attached an extract from the TM1Server log Note that the process DIM_Build_Business_Unit_Grouping_T...
by jyoung66
Sat May 17, 2014 9:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX filter level by attribute and retain parent
Replies: 8
Views: 7318

Re: TM1 MDX filter level by attribute and retain parent

Ooops spoke too soon I'm afraid Here is the modified query, which now just looks at Total level and N levels {Union( {[Business_Unit].[All_Business_Unit]} , {TM1FILTERBYLEVEL( {FILTER({Descendants({ [Business_Unit].[All_Business_Unit]})},[Business_Unit].[PropertyManager]="Jimi Hendrix")} ,0 )} )} An...
by jyoung66
Sat May 17, 2014 8:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX filter level by attribute and retain parent
Replies: 8
Views: 7318

Re: TM1 MDX filter level by attribute and retain parent

Never mind, solved my own problem...Its simple really:

{TM1FILTERBYPATTERN(
{Union(
{[Business_Unit].[All_Business_Unit]}
,
{FILTER({Descendants({ [Business_Unit].[All_Business_Unit]})},[Business_Unit].[PropertyManager]="Jimi Hendrix")}
)}
,
"All_Business_Unit"
)}
by jyoung66
Sat May 17, 2014 8:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX filter level by attribute and retain parent
Replies: 8
Views: 7318

Re: TM1 MDX filter level by attribute and retain parent

Hi and thanks for the excellent post here, it has helped me greatly What if I JUST want the filtered parent and not the decendants? My example below is based on what has gone before, and to get the just total I filter by level, but I have hard coded this (the 5 below) To get what I want, I would nee...
by jyoung66
Thu Nov 07, 2013 5:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Handling empty dynamic subsets in TI's
Replies: 8
Views: 4017

Re: Handling empty dynamic subsets in TI's

The things I am trying to avoid are: - Inserting a dummy in the subset on top of the dynamically chosen ones - Going through all elements with an extra TI prior to the TI that creates the subset to see if at least one element has the attribute value I am looking for Both options above should work b...
by jyoung66
Wed Nov 06, 2013 9:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advantage of Performance Modeler for TM1 Expert
Replies: 12
Views: 9508

Re: Advantage of Performance Modeler for TM1 Expert

While I agree with all that has been written above, there is the inescapable fact that even the experts will have to get their head around PM and soon. 10.2 is heavily PM centric, and IBM have made it clear that this is the shape of things to come Clients of the experts will be developing in PM and ...
by jyoung66
Mon Oct 21, 2013 12:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using ItemReject in the Prolog of a TI
Replies: 11
Views: 5043

Re: Using ItemReject in the Prolog of a TI

Thanks Jeroen Eynikel That worked for me as well. I too had a strange situation from this that I had not seen before the below code did not quit the process, it seemed to go to the data tab. Any ideas why this might be happening? sIssue = ATTRS('POS_ID',pPOS_ID,'RelIssue'); If(sIssue @= '' % DIMIX('...
by jyoung66
Fri Oct 18, 2013 5:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: running vbscript from TI process
Replies: 1
Views: 818

running vbscript from TI process

Hi I have been trying unsuccessfully to run the following vbscript via an executecommand in a TI process. There is the code: #------------------------------------------------------------------------ vFileToUpdate='D:\TM1\Admin\Code\ListTest.txt'; vLineId='NextLine'; vNewText='3:48'; C_Update='cmd /c...
by jyoung66
Wed Sep 25, 2013 11:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeder - Left and right sides
Replies: 2
Views: 1148

Feeder - Left and right sides

I have been told that with feeders you have to take care to "balance" the left and right sides Take the following example: ['Account1','Version1']=>['Account2']; Here 'Account1','Version1 will feed Account2 for ALL VERSIONS, not just version1, as I haven't specified to only feed Version1 on the righ...
by jyoung66
Fri Aug 30, 2013 12:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Writing to }ElementSecurity cubes - ADMIN
Replies: 2
Views: 1213

Re: Writing to }ElementSecurity cubes - ADMIN

Fair enough re the code, I was offsite when I posted and didnt have access Here is my amended code; it now works thanks to your advice I kept the CellPutS as I had created about 15 of these all based on the control cube as datasource and going back to change all of the processes to use dimension dat...
by jyoung66
Thu Aug 29, 2013 4:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Writing to }ElementSecurity cubes - ADMIN
Replies: 2
Views: 1213

Writing to }ElementSecurity cubes - ADMIN

Hi I was recently replacing cube element security rules with TI processes, this is the first time I have done this. I note that I kept getting errors when writing to ADMIN groups, the errors kept telling me that I was trying to write to a consolidated element (sorry, going off memory), and yet all e...
by jyoung66
Wed Aug 14, 2013 1:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reporting (no metadata) cube load causing waiting - why?
Replies: 7
Views: 1711

Re: Reporting (no metadata) cube load causing waiting - why?

In a PRODUCTION environement rules dont change often, but this was in a UAT or SAT environment and changes were more frequent, this is where I saw the behaviour
by jyoung66
Tue Aug 13, 2013 11:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reporting (no metadata) cube load causing waiting - why?
Replies: 7
Views: 1711

Re: Reporting (no metadata) cube load causing waiting - why?

Unfortunately I can't test this, as this was a problem I had that the start of the year on a project that is now complete Re-establishing at server start up wouldn't do it though would it, as there would need to be a re-run of the AddCubeDependency(BaseCube, DependentCube) function after each change...