Search found 13 matches
- 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: 4667
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...
- 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: 4667
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...
- 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: 4667
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.
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.
- 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: 4667
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...
- 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: 5402
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...
- 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: 5402
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 !
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 !
- 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: 2290
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 ...
- 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: 2290
"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...
- 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: 5402
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...
- 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: 5402
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!
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!
- 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: 5402
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...
- 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: 5402
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!
Thank you!
- 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: 5402
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....