Search found 36 matches

by michaelc99
Tue May 24, 2022 7:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Maintenance in PAW or TI?
Replies: 5
Views: 200

Re: Hierarchy Maintenance in PAW or TI?

Hello gtonkin, Thank you for the quick response. I exported the entire dimension to CSV, then used Notepad++ to add the new periods/hierarchies. I'm not sure it mattered or not, but I positioned the new members at the top of the file. I used PAW to rebuild the entire dimension, but after re-building...
by michaelc99
Tue May 24, 2022 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Maintenance in PAW or TI?
Replies: 5
Views: 200

Hierarchy Maintenance in PAW or TI?

Hello Everyone, My normal approach for adding elements and attributes has been to edit the dimension and manually add them. This works for one-off, minor modifications; however, in lieu of a future-state MDM approach. I am looking to either use PAW or a TI script to add future years to multiple PERI...
by michaelc99
Wed May 04, 2022 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Rule to Block users from running the process on select accounts
Replies: 3
Views: 186

Re: Drill Rule to Block users from running the process on select accounts

Good Morning Paul, Yes, the intent of the rule is to prevent all users from being able to access salary-related information. However, if the business decides to change course and only allow a select number of users (I.e. HR and Finance) to be able to drill into those transaction-level details then y...
by michaelc99
Tue May 03, 2022 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Rule to Block users from running the process on select accounts
Replies: 3
Views: 186

Drill Rule to Block users from running the process on select accounts

I am in the process of implementing drill through functionality; however, I want to prevent end-users from selecting any leaf level or consolidated level accounts under the "Total Compensation and Benefits" hierarchy and executing the drill through process. So, I set-up a Drill Through rul...
by michaelc99
Tue Apr 19, 2022 12:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Calculation - Catch All Rule?
Replies: 4
Views: 237

Re: TI Process Calculation - Catch All Rule?

Hello Declanr, With your theory in mind, I reviewed the process again and it looks like I was indeed running the "Other" category twice. The initial run was as a subset that ran during the WHILE clause and the second run was during the " IF(category=OTHER) then 1 minus OTHERPCT "...
by michaelc99
Tue Apr 19, 2022 2:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Calculation - Catch All Rule?
Replies: 4
Views: 237

Re: TI Process Calculation - Catch All Rule?

Struggling a little bit to follow exactly, but can you share a bit about where this code is in the TI process? One theory is that if your code is on the data tab and being triggered more than once AND if "Other" is a child of "Control Total" - then on its first run it could put ...
by michaelc99
Mon Apr 18, 2022 8:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Calculation - Catch All Rule?
Replies: 4
Views: 237

Re: TI Process Calculation - Catch All Rule?

Actually, looking at the results closer, it appears to be putting in a -0 value under OTHER. I am looking at my syntax to see if I put too many parenthesis or if my logic is written incorrectly somewhere else.
by michaelc99
Mon Apr 18, 2022 8:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process Calculation - Catch All Rule?
Replies: 4
Views: 237

TI Process Calculation - Catch All Rule?

Good Afternoon Everyone, I am in the process of writing one or (potentially) multiple TI processes to replace an Allocation Spreadsheet. The spreadsheet performs A divided by B calculations for specific channels and pushes the results into a separate cube. I am able to complete those calculations wi...
by michaelc99
Mon Apr 18, 2022 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Handling within a TI process?
Replies: 10
Views: 1109

Re: Error Handling within a TI process?

Thank you everyone for your help! I was able to get the output that I was looking to achieve!
by michaelc99
Tue Apr 05, 2022 2:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Handling within a TI process?
Replies: 10
Views: 1109

Re: Error Handling within a TI process?

Try something like this. Whenever I have to insert a ' I always use char(39) to stop my eyes hurting :D pAccount = '10000'; DimName = 'Account'; SubName = DimName | ' Drill Set'; sAcctSQL = '[Account] IN ('; IF( SUBSETEXISTS(DimName,SubName) = 1 ); SUBSETDESTROY(DimName,SubName); ENDIF; SUBSETCREAT...
by michaelc99
Tue Apr 05, 2022 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Handling within a TI process?
Replies: 10
Views: 1109

Re: Error Handling within a TI process?

Hi Indeed formatting issues can be a pain sometimes. You need to use TextOutput for instance and simply copy paste the resulting query in an ODBC client to see it that one is correct or not. I will add the following and see where my syntax is failing on C-Level data pulls. ASCIIOutput('DW_DrillOutp...
by michaelc99
Tue Apr 05, 2022 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Handling within a TI process?
Replies: 10
Views: 1109

Re: Error Handling within a TI process?

When the user selects a consolidated element, you will typically create a loop over the descendent elements. This will in turn creates an IN( …, …, … ) statement all in the prolog tab. Will this query work or error out ? In the current form, the user will not be able to run the drill through proces...
by michaelc99
Mon Apr 04, 2022 9:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Handling within a TI process?
Replies: 10
Views: 1109

Error Handling within a TI process?

Good Afternoon, I created a Drill-Through process that returns records from an MS-SQL database. In the WHERE clause, I parameterized the ENTITY, PERIOD and ACCOUNT dimensions then used ELLEV and ELISANC in the drill rules against the ACCOUNT dimension to prevent users from executing the query agains...
by michaelc99
Wed Mar 30, 2022 9:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Adding Comments within TM1?
Replies: 0
Views: 225

Adding Comments within TM1?

Good Morning/Afternoon Everyone, I recently deployed dashboards to my leadership team within PAW, which, at the moment, provides KPIs and directional insights from the dataset. What I would like to be able to do is enhance those dashboards by incorporating insights generated by our Finance Business ...
by michaelc99
Tue Nov 30, 2021 9:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opinions and Best Practices for Allocation Model
Replies: 3
Views: 10197

Re: Opinions and Best Practices for Allocation Model

Hi Michael, Could you not create a new cube that includes the 'variable' dimensions, along with a measure dimension to hold an element called something like Allocation Flag? Then base any rules/TI process logic on the flag in this cube? I would personally hold the rates in a separate cube as you ha...
by michaelc99
Mon Nov 29, 2021 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Opinions and Best Practices for Allocation Model
Replies: 3
Views: 10197

Opinions and Best Practices for Allocation Model

Good Afternoon Everyone, I am looking to solicit some advice on creating a TI process to replace an existing allocation model. Currently, Allocation Rates are generated within Excel by pulling data from GL MAIN (cube) then uploading the computed rates into a separate cube called, "Production Al...
by michaelc99
Mon Nov 01, 2021 8:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AX to D365
Replies: 2
Views: 4055

Re: AX to D365

Hi This may be a bit out of date now, but 10 years ago we used TI to extract data directly via ODBC from the SQL Server database underlying MS Dynamics - it was just transitioning from being called Great Plains at the time. Not sure how much it has changed in Dynamics 365. Anyway this is perfectly ...
by michaelc99
Fri Oct 29, 2021 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AX to D365
Replies: 2
Views: 4055

AX to D365

Good Morning Everyone, Currently, we have a process in place to manually extract Excel files from Microsoft AX and load into TM1 via Excel . At one point, I converted the Excel files into CSV and built TI processes to improve performance; however, I am only seeing a marginal performance improvement,...
by michaelc99
Fri Oct 15, 2021 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Preventing Data Spread to Every Intersection Point
Replies: 7
Views: 4858

Re: Preventing Data Spread to Every Intersection Point

Have you considered this parameter in tm1s.cfg ProportionSpreadToZeroCells=F It should still allow data spreading and population of leaves, but won't allow data spreading on consolidations where the leaves are all zero Good catch ! Michael, the downsides are: - it applies to all cubes - new data (c...
by michaelc99
Wed Oct 13, 2021 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Preventing Data Spread to Every Intersection Point
Replies: 7
Views: 4858

Re: Preventing Data Spread to Every Intersection Point

It is basically a training opportunity, as you put it so well. Besides that, one could have options like: - turning off the capability of spreading, however it holds for all cubes and also when the aggragated value is not zero. - cell security. Haven't looked at that option but maybe it's not too b...