List of Contributions

Trevor Mills

This individual is no longer active. Application functionality related to this individual is limited.

Contact Details

My Content

1 to 15 of 15 total

RE: User right - Workspace to run process

Posted By Trevor Mills Mon December 16, 2019 03:24 AM
Found In Egroup: Planning Analytics \ view thread
I agree with Ryan that this is an option. Somewhat similar, here is some boilerplate from our process template that may help you # ------------------------------- # Assign CSV file datasource # ------------------------------- cDataSourceFolder = '\\sdx0007.....com\..data\sapexpimp\all\'; pFileName ...

RE: TM1 null values show as (no value) in cognos, causing summarization issues

Posted By Trevor Mills Tue September 24, 2019 03:51 AM
Found In Egroup: Planning Analytics \ view thread
Hi Shubho, a scatter plot requires two axes. i.e. an X value and a Y value​ so where a value is not calculated for either of the two axes it would make sense that the data point would not display. I suggest that you post your script for creating the calc. There is no "is null" function in TI. Try ...

RE: PAW - How to remove set editor it from default setting

Posted By Trevor Mills Thu September 05, 2019 07:49 AM
Found In Egroup: Planning Analytics \ view thread
​Hi Dhwani - sorry I didn't see the image that had posted, this doesn't display in the email. But I think your challenge is the same as we experienced. If you follow our approach then it seems that the set editor then defaults to All Roots not All Members. Stuart - I would also be keen to know how ...

RE: PAW - How to remove set editor it from default setting

Posted By Trevor Mills Thu September 05, 2019 07:38 AM
Found In Egroup: Planning Analytics \ view thread
​Hi Stuart, thanks for setting out the specified behavior, it is a good idea for this question. The limitation of this approach, specifically in the set editor, is the following. By way of example: The "default" subset for our Financial Period dimension is defined as 2019Q4&Prior. However when the ...

RE: PAW - How to remove set editor it from default setting

Posted By Trevor Mills Thu September 05, 2019 04:58 AM
Found In Egroup: Planning Analytics \ view thread
​Hi Dhwani, I assume from your question that you want to override the default when the set editor is opened in PAW. Firstly, you need to delete any subset on the dimension that is named 'Default'. TM1 will then use 'All Roots' as the default set in the set editor. This will however have the ...

RE: Customize PAW Welcome Page

Posted By Trevor Mills Thu August 29, 2019 04:33 AM
Found In Egroup: Planning Analytics \ view thread
Our external consultants developed ​two "web parts" that we have on a "home" page to report the status. Obviously we would prefer to insert these directly on to the Welcome page in PAW but we couldn't do this. The compromise was to develop our own "home" page with links to commonly used reports, the ...

RE: Customize PAW Welcome Page

Posted By Trevor Mills Thu August 29, 2019 04:32 AM
Found In Library: Planning Analytics
#PlanningAnalyticswithWatson

Deactivate sorting option in PAW

Posted By Trevor Mills Wed August 21, 2019 03:49 AM
Found In Egroup: Planning Analytics \ view thread
​Is it possible to switch off the sort option in the default menu in PAW for selected cubes? We have some cubes with particularly large dimensions (1m+ elements). We have built hierarchies to group the elements but when our users try to sort these hierarchy elements the memory requirement causes the ...

RE: Default set for hierarchy (PAW)

Posted By Trevor Mills Tue June 11, 2019 04:24 AM
Found In Egroup: Planning Analytics \ view thread
For info, here is a script that works in my environment. I only use PAW editor (ver 2.0.41) no Architect anymore. sDim = 'ActuarialSegment:CalculationSegment'; sMDX = '[' | sDim | ']'; sMDX = '(TM1SUBSETALL( ' | sMDX | ' ))'; sMDX = '(TM1FILTERBYLEVEL( ' | sMDX | ', 1))'; If (SubsetExists(sDim, ...

RE: Set Editor: Default option different from version 2.0.37 to 2.0.41

Posted By Trevor Mills Fri June 07, 2019 03:46 AM
Found In Egroup: Planning Analytics \ view thread
I found a workaround, described here https://community.ibm.com/community/user/businessanalytics/communities/community-home/digestviewer/viewthread?GroupId=3067&MessageKey=2a94417f-0126-4fa5-9175-fd112e912479&CommunityKey=8fde0600-e22b-4178-acf5-bf4eda43146b&tab=digestviewer&ReturnUrl=%2fcommunity%2f ...

RE: PAW View Subsets: All Roots

Posted By Trevor Mills Thu June 06, 2019 10:54 AM
Found In Egroup: Planning Analytics \ view thread
I found that this workaround works: 1. Create the subsets with a name other than Default. I chose 'Standard' since this is also the German translation and still works in German language browser. 2. Create the View called 'Default' so that this is recognised by PAW as the default view but with 'Standard' ...

RE: PAW View Subsets: All Roots

Posted By Trevor Mills Thu June 06, 2019 09:08 AM
Found In Egroup: Planning Analytics \ view thread
"I found a good work around that works perfectly. If I just delete the default subset, then it will default to "All Roots"." Do you create a default view for the cube? Or do create the default view using a subset name name other than "Default" to select the default elements? ------------------------------ ...

RE: Default set for hierarchy (PAW)

Posted By Trevor Mills Thu June 06, 2019 09:08 AM
Found In Egroup: Planning Analytics \ view thread
Hi Anssi, I create default subsets in hierarchies with a TI. E.g. SubsetCreatebyMDX('DimensionName:HierarchyName', sMDX); regards Trevor ------------------------------ Trevor Mills ------------------------------

Set Editor: Default option different from version 2.0.37 to 2.0.41

Posted By Trevor Mills Thu June 06, 2019 09:08 AM
Found In Egroup: Planning Analytics \ view thread
It seems that the user interface in the set editor has been changed between ver 2.0.37 and ver 2.0.41. In ver 2.0.37 the 'All roots' subset is automatically selected when opening the set editor. In ver 2.0.41 the 'Default' subset is selected. This however has the effect of causing the search functionality ...

Set Editor: Default option different from version 2.0.37 to 2.0.41

Posted By Trevor Mills Thu June 06, 2019 08:34 AM
Found In Library: Planning Analytics
#PlanningAnalyticswithWatson