Search found 13 matches

by Mark
Mon Jul 09, 2018 12:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset Expression - EP Access table replication
Replies: 7
Views: 943

Re: Dynamic Subset Expression - EP Access table replication

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...
by Mark
Sun Jul 08, 2018 11:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset Expression - EP Access table replication
Replies: 7
Views: 943

Re: Dynamic Subset Expression - EP Access table replication

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...
by Mark
Fri Jul 06, 2018 7:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset Expression - EP Access table replication
Replies: 7
Views: 943

Re: Dynamic Subset Expression - EP Access table replication

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.
by Mark
Fri Jul 06, 2018 1:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subset Expression - EP Access table replication
Replies: 7
Views: 943

Dynamic Subset Expression - EP Access table replication

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 the...
by Mark
Mon Jun 25, 2018 8:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1501

Re: Using dimension PickList to filter data on import to cube

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...
by Mark
Sat Jun 23, 2018 12:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1501

Re: Using dimension PickList to filter data on import to cube

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 :)!
by Mark
Thu Jun 21, 2018 10:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "IF Statement" - Returning ELSE output for blank intersections
Replies: 2
Views: 359

Re: "IF Statement" - Returning ELSE output for blank intersections

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 ...
by Mark
Thu Jun 21, 2018 12:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "IF Statement" - Returning ELSE output for blank intersections
Replies: 2
Views: 359

"IF Statement" - Returning ELSE output for blank intersections

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...
by Mark
Wed Jun 20, 2018 11:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1501

Re: Using dimension PickList to filter data on import to cube

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...
by Mark
Tue Jun 19, 2018 9:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1501

Re: Using dimension PickList to filter data on import to cube

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! :)
by Mark
Tue Jun 19, 2018 1:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1501

Re: Using dimension PickList to filter data on import to cube

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...
by Mark
Mon Jun 18, 2018 5:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1501

Re: Using dimension PickList to filter data on import to cube

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

Thank you! :)
by Mark
Mon Jun 18, 2018 4:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1501

Using dimension PickList to filter data on import to cube

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