TM1 Forum

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...

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...

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.

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...

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 ...

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

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...

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")} ,...

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"
)}

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...

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...

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 ...

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('...

Never mind, I found it myself:

http://blog.tm1tutorials.com/tag/vbscript/

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...

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 o...

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...

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...

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

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...