Search found 42 matches

by bgregs
Mon Dec 10, 2018 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server crash
Replies: 4
Views: 218

Re: TM1 server crash

Do you have a backup that was taken before the server migration you could test? This line: The TM1 service may not have been shut down completely prior to copying the model really sounds like it could be the cause. If you don't have a backup to test with, then calling IBM may be your best bet (unles...
by bgregs
Mon Dec 10, 2018 12:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 server crash
Replies: 4
Views: 218

Re: TM1 server crash

Not entirely sure, but sounds like this *could be* related:

https://www-01.ibm.com/support/docview. ... wg21654717
by bgregs
Fri Dec 07, 2018 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 9
Views: 338

Re: issues with moving TI processes

What if you create a new process while the server is running? Right click the "Processes" node and create a new one with a random name. Is that process visible? I'm out of ideas at this point, so just trying to isolate what works and what doesn't.
by bgregs
Thu Dec 06, 2018 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: issues with moving TI processes
Replies: 9
Views: 338

Re: issues with moving TI processes

Are you admin on the dev server? If not, login with an admin account and update your }ProcessSecurity cube to provide READ access to the new processes.
by bgregs
Wed Dec 05, 2018 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to Kill Thread in TM1 TOP
Replies: 2
Views: 328

Re: Unable to Kill Thread in TM1 TOP

You will probably need to kill the process on the SAP side. In my experience, 9 times out of 10 this is a hang up on the SAP side (especially with HANA... :roll: ).
by bgregs
Tue Nov 20, 2018 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives on Network vs Stand-Alone
Replies: 9
Views: 528

Re: TM1 Perspectives on Network vs Stand-Alone

I really think you may want to involve an "IT person" in this particular case. Can you clarify what exactly you are trying to accomplish? You mentioned hosting Perspectives on a shared drive, which you definitely should not do. Perspectives creates configuration files per user... If you want to acco...
by bgregs
Thu Nov 08, 2018 3:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Top does not cancel process while waiting Database - Batch Process
Replies: 3
Views: 346

Re: TM1Top does not cancel process while waiting Database - Batch Process

My preferred way of working around this during the development phase is the following: Write your SQL query outside of the ODBC connection (i.e. SQL Developer for Oracle, pgAdmin III for PostgreSQL, etc.) When you're positive the data coming out of your DB is correct, export it from the database to ...
by bgregs
Wed Nov 07, 2018 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: [Citrix - TM1 Perspective] No admin server
Replies: 2
Views: 571

Re: [Citrix - TM1 Perspective] No admin server

Try to ensure that the tm1p.ini file (their personal configuration file for the tm1p.xla) is not getting wiped. This sounds like a fairly common issue with the Citrix profiles being "reset". You can confirm that this is happening by comparing the contents of the tm1p.ini before and after the potenti...
by bgregs
Tue Nov 06, 2018 1:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to programmatically open files from Application folder
Replies: 9
Views: 1038

Re: How to programmatically open files from Application folder

Hi Ashleigh, Try this one out: Sub open_files() Dim path As String Dim file As String path = "\\(your_server)\(admin_host_name)\(path_to)\}Externals\" file = Dir(path & "\*.xlsx") Do While file <> "" Workbooks.Open Filename:=path & "\" & file ' Add workbook processing logic here file = Dir Loop End ...
by bgregs
Mon Nov 05, 2018 2:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Display the current date
Replies: 3
Views: 424

Re: Display the current date

I'm sorry, but I'm really having a hard time understanding what you're trying to accomplish here. Firstly, (as per Jim's comment) you should have your "CurrentDate" attribute created as an alias, in your screenshot you have it listed as "Text". My second question would be regarding your "Num" attrib...
by bgregs
Mon Nov 05, 2018 12:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrading from 10.2.2 to PA
Replies: 6
Views: 546

Re: Upgrading from 10.2.2 to PA

A few things to watch out for from my experience: Do you have different versions of Perspectives that will be used? If so, SupportPreTLSv12Clients=T If you have VBA worksheets and want to use them in PAW, be prepared to gut them and start over with the logic Docker is nothing to be afraid of, but if...
by bgregs
Mon Nov 05, 2018 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to programmatically open files from Application folder
Replies: 9
Views: 1038

Re: How to programmatically open files from Application folder

'excel crashes here... what name / string do i pass here for strBlobName You pass in the blob file name (i.e. Test/Budget_Sampe.blob) to your excel report. As Paul stated above, you can get these names from the }ApplicationEntries dimension. If you want to work off of the }Externals folder, pass in...
by bgregs
Tue Oct 30, 2018 11:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: subnm with variable overriden
Replies: 7
Views: 392

Re: subnm with variable overriden

I have also noticed this same issue in Excel only. Another option (dare I say :shock: ) is to use the E_PICK macro. This would ultimately make it incompatible with web, more of a pain to update, and obfuscated for no real benefit, BUT it will work. :D Just don't blame it on me if you decide to go th...
by bgregs
Tue Oct 30, 2018 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rules - Request your guidance please!
Replies: 4
Views: 291

Re: TM1 Rules - Request your guidance please!

In regards to the question: Please i request your help in starting with the change in Rules, i do not know how and where to begin. Start here: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_rul.2.0.0.doc/c_componentsofacalculationstatement_n91157.html#Component...
by bgregs
Tue Oct 30, 2018 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Help making copy of existing cube in TM1
Replies: 4
Views: 446

Re: Need Help making copy of existing cube in TM1

I agree with Mark for the most part with one small exception: the Measures dimension SHOULD be renamed. The only time I could ever see reusing a measures dimension from another cube is if the cube is strictly for testing (and even then I never like that approach i.e. test becomes permanent ;) ). Bes...
by bgregs
Wed Oct 24, 2018 12:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 5
Views: 316

Re: TM1 REST API

Hi Wim, Unfortunately my PS version is too outdated to run any fancy Rest calls :( , but from what I can tell your output looks like a typical return except for the fact that it is getting truncated for some reason. I'm not sure if this is an issue with writing to a .txt, but could you maybe pass it...
by bgregs
Wed Oct 24, 2018 11:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User Details in tm1server.log
Replies: 1
Views: 143

Re: User Details in tm1server.log

Hi Mayank, By default, the tm1server.log file shows only the user ID (AFAIK there is not a way to make it show anything else). There is a file called tm1s-log.properties that configures the logging details for the TM1 server. You can set the level of detail and include different properties to log to...
by bgregs
Fri Oct 19, 2018 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 rule using DB IF and Stet
Replies: 3
Views: 308

Re: TM1 rule using DB IF and Stet

This goes for most languages (mostly c based, but will apply here as well), try to avoid extra conditionals when possible. Depending on the case, this is sometimes unavoidable, but in your situation the extra calls in option 2 would be considered more "expensive" than the first (i.e. more "cycles" t...
by bgregs
Thu Oct 18, 2018 8:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to find Leaf Level of all dimensions in cube
Replies: 3
Views: 164

Re: Rule to find Leaf Level of all dimensions in cube

Both ELLEV and ISLEAF will work. The key is how you structure the left side of your rule. Use the open brackets ( [] ) to test every cell.
by bgregs
Mon Oct 15, 2018 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuring PAx on https
Replies: 3
Views: 215

Re: Configuring PAx on https

If the question is "has anyone configured PAX to use https", I can assure you the answer is yes. ;) If there is something you're having difficulty with and would like help, you would need to provide some more details about what you have tried, current environment, etc., as per Steve's comment below.