Search found 206 matches

by PavoGa
Fri Aug 17, 2018 9:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text File TI reads is retained in memory...?
Replies: 3
Views: 44

Re: Text File TI reads is retained in memory...?

Your profile shows both 10.2.2.7 and PA2, but you haven't indicated which one this is in. Unless it's PA2 and the server team has done something funky relating to this in PA2 (which I doubt), I don't think that what you suspect is in fact happening. You need to disregard the preview window. It will...
by PavoGa
Fri Aug 17, 2018 9:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text File TI reads is retained in memory...?
Replies: 3
Views: 44

Re: Text File TI reads is retained in memory...?

Okay, never mind. Problem was this was a one off and running this in PA2.0. I started the process off in PAW, selected the datasource there originally. The Data Source name for Server was model_upload\filename.csv instead of the path and file name in the first data source entry block. Current taking...
by PavoGa
Fri Aug 17, 2018 8:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Text File TI reads is retained in memory...?
Replies: 3
Views: 44

Text File TI reads is retained in memory...?

Has anyone seen this problem? It is the first time I've ever seen it. We have a TI that reads a text file and updates a cube. Just updating a calendar dimension with American and TM1 formatted dates with an integer as the primary element name. Text file has the key, the American date and TM1 date in...
by PavoGa
Thu Aug 09, 2018 12:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 28
Views: 1364

Re: Planning Analytics using twice the memory of 10.1

Big thanks to Lotsa, Paul and others for this-- has been a really interesting thread. If anyone needs a pre-REST API method of counting MUNs, just create an MDX subset like this and count/SUBSIZ the elements in that dynamic subset: GENERATE( TM1SUBSETALL( [Your Dimension Name] ), DESCENDANTS( [Your...
by PavoGa
Mon Jul 23, 2018 12:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Journal validation - account combinations
Replies: 7
Views: 257

Re: Journal validation - account combinations

Here is another approach, taking Steve and Tomok's advice: NOTE: this only works 100% if the keys for B, C and D are and always will be mutually exclusive. One dimension: Three consolidation AB, AC, AD. For every valid combination of AB, add that component to consolidation AB, etc for AC and AD. The...
by PavoGa
Thu Jul 05, 2018 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Merging of multiple elements
Replies: 3
Views: 298

Re: Merging of multiple elements

I suggest desired outcome may be better served by rethinking your cube structure. It seems that the Dept dim is nothing more than a place holder to collect the numeric measures for the various combinations of X, Y, P & Q and not a real part of an organization structure? Regardless, my thought is thi...
by PavoGa
Tue Jul 03, 2018 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing a process while the Drill through process Execution
Replies: 2
Views: 160

Re: Executing a process while the Drill through process Execution

You can create any custom view you want within the drill-through process. You can even create and populate a custom cube, build a view on it and open it. Unless it has changed in PA2.0, I do not believe you can use ReturnViewHandle in anything but a drill process. For using TM1RunTI and passing para...
by PavoGa
Fri Jun 29, 2018 12:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Not Expanding Properly
Replies: 3
Views: 181

Re: MDX Not Expanding Properly

Would you put your solution up?
by PavoGa
Fri Jun 29, 2018 12:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create Dynamic Subset with User Input
Replies: 3
Views: 265

Re: Create Dynamic Subset with User Input

Hi- I am trying to export the YTD results from a cube with Periods defined as "2018-01", "2018-02", etc. with a input from the user of the Year desired. For example, the user would input "2018", and the export would be for all months of 2018. As a part of my TI code, I know that the following works...
by PavoGa
Thu Jun 28, 2018 12:28 pm
Forum: Commercial and Events
Topic: TM1 Bytes And Nybbles Series on The TM1 Channel
Replies: 7
Views: 955

Re: TM1 Bytes And Nybbles Series on The TM1 Channel

I plead ignorance, but what is "Farm Manager?"
by PavoGa
Wed Jun 27, 2018 4:51 pm
Forum: Useful code, tips and tricks
Topic: Listing of all numerical TI process property values in .pro
Replies: 11
Views: 2906

Re: Listing of all numerical TI process property values in .pro

For what it is worth, I used Beyond Compare 4.0 and have a script that does exactly what you are wanting to do it seems. Only TIs with significant (i.e. ignores the white noise) variances show up in the results window.

If interested, hit me up.
by PavoGa
Tue Jun 26, 2018 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process taking too much time to create a subset
Replies: 18
Views: 1629

Re: TI process taking too much time to create a subset

Hello ty, Reading this topic, I think that the OP already does this. Your SubsetCreateByMDX is missing the dimension name as 3rd parameter, though. May have missed it, but do not see where the OP was using the UNION statement. This was a tip for going forward, not a specific response to the initial...
by PavoGa
Fri Jun 22, 2018 3:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: I’m new to Tm1
Replies: 8
Views: 460

Re: I’m new to Tm1

Sorry, I have no advice on that, although I believe one can use JAVA with it.

It has its own language. Google TM1 Reference Guide (10.2.2 or PA2.0) and you should find documents to review.

Best is to work with someone who knows the product really well.
by PavoGa
Fri Jun 22, 2018 1:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: I’m new to Tm1
Replies: 8
Views: 460

Re: I’m new to Tm1

Yes, it is to be any good at it. :D

Also, a good understanding of dimensional data structures is very helpful. I run into people all the time whose primary or only experience is with relational/flat data and they struggle getting the most out of TM1.

Good luck!
by PavoGa
Fri Jun 22, 2018 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process taking too much time to create a subset
Replies: 18
Views: 1629

Re: TI process taking too much time to create a subset

Here is a possible helpful hint for dealing with MDX subsets going forward: if an MDX statement with filters does not return any members, then SubsetCreateByMDX will fail. One thing to do in order to guarantee the MDX statement will compile (assuming of course the statement is syntactically correct...
by PavoGa
Fri Jun 22, 2018 12:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1002

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

You might want to add ASCIIOUTPUT or LOGOUTPUT in the ELSE block and output the values being tested and results. For example: ASCIIOUTPUT(sErrorFileName, EXPAND('--> %job_unique_id% %Planning_Project_Code%')); or LOGOUTPUT('ERROR', EXPAND('--> %job_unique_id% %Planning_Project_Code%')); I only use t...
by PavoGa
Fri Jun 22, 2018 11:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Scanning ' in TM1
Replies: 2
Views: 205

Re: Scanning ' in TM1

Try storing the ASCII character for that in a variable and then SCAN for the variable.
by PavoGa
Tue Jun 12, 2018 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Applications Custom Views
Replies: 4
Views: 492

Re: TM1 Applications Custom Views

Yes there is. 1) Build static views for each user (not optimum :D ) 2) if you define the relationship between the approval hierarchy nodes/user/whatever and the elements in the other dimension, you can use an MDX subset to provide the desired elements. For example, a lot of our views will default th...
by PavoGa
Tue Jun 12, 2018 2:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to reference data lines as variables in TI?
Replies: 10
Views: 569

Re: How to reference data lines as variables in TI?

I think you want to look at NumberToStringEx().
by PavoGa
Mon Jun 11, 2018 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process taking too much time to create a subset
Replies: 18
Views: 1629

Re: TI process taking too much time to create a subset

Here is a possible helpful hint for dealing with MDX subsets going forward: if an MDX statement with filters does not return any members, then SubsetCreateByMDX will fail. One thing to do in order to guarantee the MDX statement will compile (assuming of course the statement is syntactically correct)...