Search found 226 matches

by Edward Stuart
Mon Sep 18, 2017 7:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect
Replies: 8
Views: 1481

Re: How to Create Ragged/Unbalanced Hierarchy in TM1 Architect

When you open the subset editor to view your dimension. It is good practice to select All elements and then to select Hierarchy Sort. This ensures you are viewing the dimension in it's entirety and in the defined order. To resolve the initial view of the dimension you can employ DIMENSIONSORTORDER i...
by Edward Stuart
Fri Sep 08, 2017 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to pull views in TM1 Cafe
Replies: 4
Views: 1136

Re: Unable to pull views in TM1 Cafe

What is listed in the logs?
by Edward Stuart
Fri Sep 08, 2017 6:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Application name not listed in TM1 web URL
Replies: 9
Views: 2570

Re: Application name not listed in TM1 web URL

For reference and to assist other users searching the forum, multiple network adapters can cause issues:

Unable to login to TM1 Server when TM1 Admin Server has multiple network adapters (NICs)
by Edward Stuart
Tue Sep 05, 2017 11:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Application name not listed in TM1 web URL
Replies: 9
Views: 2570

Re: Application name not listed in TM1 web URL

Have you checked that all of the firewall ports are open? Unable to log in to Architect/Perspectives/TM1 Web: TM1 server is not showing and just to be sure on the tm1web side of things: TM1Web does not show any TM1 Servers in the server dropdown Can you confirm if you are able to login via Architect...
by Edward Stuart
Fri Sep 01, 2017 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 'OldCubeLogChanges'
Replies: 4
Views: 1582

Re: 'OldCubeLogChanges'

OldCubeLogChanges is a variable generated by TM1 as part of the wizard, this is why you see it in the generated statements section. The wider context is around what needs to be logged and when, it is worth reading through the Operations Guide >System and Performance Monitoring > Logging Transactions...
by Edward Stuart
Tue Aug 29, 2017 1:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 1722

Re: Error: Prolog procedure line (0): Unable to open data source

I would advise that you talk to someone with knowledge of your implementation as to what the process is. Do you have an administrator/ project manager/ developer you can access to discuss this issue with? It would appear that the data source/ locations for your processes have been removed/ moved/ am...
by Edward Stuart
Tue Aug 29, 2017 1:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 1722

Re: Error: Prolog procedure line (0): Unable to open data source

What other file types exist in the folder:

"s:\prod\dfv_proforma\data\"
by Edward Stuart
Wed Aug 23, 2017 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Instance crash after turning on Performance Monitor
Replies: 4
Views: 903

Re: Instance crash after turning on Performance Monitor

Most importantly, are there a set of steps that cause the fault to repeat?
Does Performance Monitor crash the server every time it is run? If so, then it could well be a hardware issue than a Cognos TM1 issue
by Edward Stuart
Wed Aug 23, 2017 1:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Instance crash after turning on Performance Monitor
Replies: 4
Views: 903

Re: Instance crash after turning on Performance Monitor

I'd check the Event Log first to see if anything of interest occurred around the time of the crash and if anything is in the application error Then I'd check the tm1server.log file for anything of interest around the crash time Then tm1s.log at the time of the crash If these turn up nothing then I'd...
by Edward Stuart
Wed Aug 23, 2017 11:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 1722

Re: Error: Prolog procedure line (0): Unable to open data source

What is the requirement of the process?

Is it to load data? If it is to load data what is the data source the data is to be loaded from?
by Edward Stuart
Wed Aug 23, 2017 9:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error: Prolog procedure line (0): Unable to open data source
Replies: 10
Views: 1722

Re: Error: Prolog procedure line (0): Unable to open data source

Are you sure you want to be loading from a .blb file? The typical checks I follow to diagnose a "Unable to open data source error" are: - Check user account running TM1 Service account has access to the folder/ file in question - Check file is not already open by a user - Check file exists There are...
by Edward Stuart
Mon Aug 21, 2017 2:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OVERFEEDING issue
Replies: 4
Views: 1395

Re: OVERFEEDING issue

Read the Request for assistance guidelines 3) Try to make the question as specific as possible. A general question like "How do I write a rule?" is difficult to answer without copying out the whole of the user manual. A question like "I have a payroll cube which contains the following dimensions {d...
by Edward Stuart
Wed Aug 09, 2017 10:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Size
Replies: 11
Views: 2594

Re: Cube Size

Cube performance may not always be to do with Feeders and as Jim suggests, context is useful. Without context I'd advise you reduce the number of dimensions to improve performance... Some reading that may or may not be of use https://www.google.co.uk/search?q=cognos+tm1+performance+improvements&oq=c...
by Edward Stuart
Mon Aug 07, 2017 9:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Process does not update updateable cell
Replies: 5
Views: 1158

Re: Process does not update updateable cell

Is this a last values wins scenario? If you know there are target cells that are not updating, then you can ASCIIOUTPUT/ TEXTOUTPUT for those cells only and check if they are being written/ overwritten/ being targeted as required Has the code in the processes changed? Does the data source change? Ha...
by Edward Stuart
Fri Aug 04, 2017 8:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Help in coding
Replies: 5
Views: 1199

Re: Need Help in coding

Suggest you read the Request for Assistance Guidelines

http://www.tm1forum.com/viewtopic.php?f=3&t=1037

I've read your question several times and I am still none the wiser as to your issue
by Edward Stuart
Thu Aug 03, 2017 9:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create a cube with a separate administrator
Replies: 11
Views: 2252

Re: Create a cube with a separate administrator

My interpretation would be that each instance 'requires' an administrator license. The model could be developed on instance A and run in instance B but I would be very surprised if IBM did not have issues with an instance being run without an administrator account. However, as you rightly say, as lo...
by Edward Stuart
Thu Aug 03, 2017 9:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create a cube with a separate administrator
Replies: 11
Views: 2252

Re: Create a cube with a separate administrator

We need to create a cube where a fourth person is the administrator for a single cube (payroll), and none of the three administrators can see or do anything with the cube after it has been set up The Local Server looks to be a good option but is still very much a grey area as discussed above. This ...