TM1 Forum

Whumy do you have a semicolon at the end ? Fantastic question, took it out and it applied the subset no problems! Guess I just assumed I had to terminate it like the other statements found on dimensional calcs and the like. Now to work out why I don't get my expected members to display. Im sure ill...

Try hardcoding: [2 WIP Hierarchy].CurrentMember to a valid element and see what happens. Also, hardcode the [2 Active Projects].CurrentMember to a valid element and test again. Hi Wim, have given the following code blocks a shot. { FILTER ( {TM1SUBSETALL([2 Active Projects])}, [WIP Access - WIP Act...

Hi Wim!

Yes, the cube I am applying the subset on contains the following dimensions:
'2 WIP Hierarchy'
'2 Active Projects'
'1 WIP Active Calc'
'4 Period'

Mark.

Hi again all, Facing a challenge re-creating a guide available online for mimicking access tables in EP. I am wanting to suppress invalid intersections from the display. Im using the following IBM guide: http://www-01.ibm.com/support/docview.wss?uid=swg21700080&aid=1 Specifically im referring to...

Hi all, So great news, I got things working - however im confused as to the mechanics. (the Ascii output was also very helpful- thanks). In short I am able to create me process in architect and get it working. Specifically because it seems I need a column to indicate the 'element' im working with on...

Thank you, I’ll try this next. I tried validating the logic with a simple if criteria manually defining strings and what not to no success.

I’m also going to strip the example right back and use some simple dummy data of a few manually created elements.

I’ll report back !

Hi Mike Thanks for the well thought out response and detailed examples. This gives me a fantastic amount of information to begin trying some of the techniques and also helps me understand good practice. As it happens I think I managed to implement option 3 or something similarish. I havnt populated ...

Hi all, I have another query concerning a technique used in EP that I can not seem to replicate in TM1. In EP, we've used a technique of flagging certain sets of data that allow for subsequent calculations based on these flags, or Lookup D-links. An example of this is as follows. - I have a calculat...

Hi David, Unfortunately this seems to return the same result. I have given the code below a shot as written. IF (DimIx ('2 Major Project PL List', Planning_Project_Code) > 0); CellPutS(Planning_Project_Code, 'Major Project Assumption', job_unique_id, 'Major Project Number'); ELSE; itemskip; ENDIF; T...

Thanks David! I’m back in my office Thursday and will be trying this First thing!

I’m gonna guess the item skip function is exactly what I wanted as I was trying to ignore bringing the data in.

Thanks again I’m really excited to see if this works and will report back!

In TM1 picklists are purely a user interface restriction, TI and/or rules can ignore them. The only way around it is to place logic in the TI that performs the same function, so as its a dimension picklist you have mentioned you would have an If Dimix in the TI. Hi Declan, Im looking at this now, I...

Awesome thanks for the pointer. I will try this and report back.

Thank you!

Hi all, A quick bit of background. I am an experienced EP modeler and new to TM1, yet to get the IBM training. I am in the process of self teaching on our 10.2.2 installation currently using TM1 Performance Modeler. I want to replicate a technique quite often used in EP. I have a 2 dimensional cube....