List of Contributions

Chris Courim

Contact Details

My Content

1 to 20 of 20 total

RE: New TM1Val function

Posted By Chris Courim Wed December 20, 2023 12:07 PM
Found In Egroup: Planning Analytics \ view thread
Wim- You'll have to request IBM update the SW on the BP Servers when available as they aren't updated to the latest version automatically. Chris ------------------------------ Chris Courim ------------------------------

RE: PAW Cube Viewer - Show Attributes

Posted By Chris Courim Fri May 13, 2022 05:04 PM
Found In Egroup: Planning Analytics \ view thread
I just submitted a support request for the same issue. i'll let you know how it goes. ------------------------------ Chris Courim ------------------------------

RE: Absolute value function in MDX queries

Posted By Chris Courim Tue April 26, 2022 11:08 AM
Found In Egroup: Planning Analytics \ view thread
Thank you Wim and George! It's extremely difficult to tell when the only error message you get is "invalid MDX expression". I must have a syntax error somewhere. Thanks again. ------------------------------ Chris Courim ------------------------------

RE: Absolute value function in MDX queries

Posted By Chris Courim Tue April 26, 2022 10:37 AM
Found In Egroup: Planning Analytics \ view thread
Hubert- Unfortunately, it is really hard to determine what VBA style functions are supported within TM1 MDX as they are not listed in the online documentation. Support for Microsoft-defined MDX Expressions and Functions – IBM Documentation It probably should be updated to include the functions ...

RE: Absolute value function in MDX queries

Posted By Chris Courim Fri April 22, 2022 09:18 AM
Found In Egroup: Planning Analytics \ view thread
Hubert – I know you're very busy man working on the next generation TM1 server but what would it take to get these functions added into MDX? Here's another a simple and quite useful real world example where the addition of these functions would be very helpful.. This works STRTOMEMBER('[Date].[ ...

RE: Ask Me Anything: Planning Analytics - February Edition

Posted By Chris Courim Wed February 09, 2022 10:17 AM
Found In Egroup: Planning Analytics \ view thread
Another question for the AMA. One of the more useful features of the old cube viewer was the ability to drag an element from the rows or columns to the filter area and that element would be set as the filter for the dimension. It appears that that functionality does not exist in the new cube viewer. ...

RE: PAW - How to make the selection widget show user-specific selections stored in a parameter cube

Posted By Chris Courim Thu June 17, 2021 12:07 PM
Found In Egroup: Planning Analytics \ view thread
Mario- I love your solution, yet there may be a simpler way utilizing alternate hierarchies. In the following screen shot, the Item dimension (on the rows) is set to show the leaves and a Total (using an aggregation calculation). The alternate hierarchy, called Category1 shows only the all ...

RE: PAW Summary Totals for data in the current view

Posted By Chris Courim Mon March 29, 2021 11:18 AM
Found In Egroup: Planning Analytics \ view thread
Mark- We do something quite similar in our Workforce application utilizing very similar MDX. We use "Aggregate" and the dynamic MDX works. I wonder if you could be experiencing an order of operation problem. Have you tried putting your MDX into a public subset then using something like the following ...

Size of name drop-down in PAW TI editor.

Posted By Chris Courim Thu March 04, 2021 12:04 PM
Found In Egroup: Planning Analytics \ view thread
Is there any way to increase the size of the drop-down in PAW TI editor? If you have any process names over 30 characters long the name is truncated. In order to see the full name, you have to hover over the name for a moment which is ridiculous. I realize it is a simple problem, and I'm whining, ...

RE: Workspace dashboard filtering

Posted By Chris Courim Wed January 20, 2021 07:49 AM
Found In Egroup: Planning Analytics \ view thread
Sounds like a great enhancement request. We have the same need. ------------------------------ Chris Courim ------------------------------

Load More Size in PAW V60

Posted By Chris Courim Fri January 15, 2021 12:49 PM
Found In Egroup: Planning Analytics \ view thread
Can this be changed to something more reasonable like my suggestion in red? Maybe an "All" option? It is very frustrating on large models. ------------------------------ Chris Courim ------------------------------ #PlanningAnalyticswithWatson

RE: Multiple Selection in PAW

Posted By Chris Courim Wed July 01, 2020 05:13 PM
Found In Egroup: Planning Analytics \ view thread
Unfortunately, there is not an exact match for the pivot table functionality of multi-select (using check boxes) in PAW when you're working with title elements. What you can do is put the hierarchy in question on the rows or columns. Do your multi-select then create an aggregate calculation which ...

RE: Multiple Selection in PAW

Posted By Chris Courim Wed July 01, 2020 10:06 AM
Found In Egroup: Planning Analytics \ view thread
Tarissa- I not sure but this may help. https://community.ibm.com/community/user/businessanalytics/blogs/paul-glennon/2020/01/20/use-aggregate-to-create-a-custom-consolidation-in Chris ------------------------------ Chris Courim ------------------------------

RE: How to add local image to PAW?

Posted By Chris Courim Thu February 20, 2020 09:58 AM
Found In Egroup: Planning Analytics \ view thread
For small images, you can convert to Base64 and it will be stored in the content store. Steps Find a site that converts images to base64 code like https://www.base64-image.de/ Convert you image Paste the resulting code into an image object in PAW. Chris ------------------------------ ...

RE: Hierarchy Creation Results in OutofMemory Exception

Posted By Chris Courim Mon February 17, 2020 01:51 PM
Found In Egroup: Planning Analytics \ view thread
We've experienced several issues maintaining alternate over the last year that have resulted in bug fixes. Some of the issues were related to using the function HierarchyDeleteAllElements. As a test, I would suggest deleting and recreating the hierarchies using HierarchyDestroy and HierarchyCreate and ...

RE: Turbo Integrator - Read multiple file at once

Posted By Chris Courim Thu January 16, 2020 11:05 AM
Found In Egroup: Planning Analytics \ view thread
Hello Ida- I'm not sure from your question if you want to multi-thread the loads but if you do here's a simple set of steps you could follow. 1. Create a "wrapper" TI process 2. Use the TI function Execute Command function (in the Prolog) to create the list of the files you want to load. 2. Use ...

RE: Planning Analytics for Microsoft Excel & Workspace questions

Posted By Chris Courim Tue December 03, 2019 11:20 AM
Found In Egroup: Planning Analytics \ view thread
Re: #4 Use the )HierarchyProperties cube element defaultMember. That's the only one I can answer.​ ------------------------------ Chris Courim ------------------------------

RE: TI Data Source using MDX View on )ElementAttributes with Hierarchy

Posted By Chris Courim Wed September 11, 2019 10:44 AM
Found In Egroup: Planning Analytics \ view thread
Paul- Another option (although ugly) is to use the REST API to create a TI process using Postman. That way you have control over the source MDX and the datasource variables. I've attached a very rough sample. Chris ------------------------------ Chris Courim ------------------------------

RE: TI Data Source using MDX View on )ElementAttributes with Hierarchy

Posted By Chris Courim Wed September 11, 2019 10:43 AM
Found In Library: Planning Analytics
#PlanningAnalyticswithWatson

RE: PAW Slowdown monitor

Posted By Chris Courim Tue August 27, 2019 04:03 PM
Found In Egroup: Planning Analytics \ view thread
Scott- I've noticed the same performance issues. Interestingly, it seems to get worse the longer the server is up. I don't understand why but it seems things run faster after a reboot (dropdowns and page refreshes). I will say that we are in development and running TM1 and PAW(V43) on the same box. ...