Search found 232 matches

by Edward Stuart
Sat Nov 25, 2017 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos TM1 Active Directory
Replies: 1
Views: 814

Re: Cognos TM1 Active Directory

Are you looking to hook directly into active directory or to utilise LDAP? There are many guides online for setting up security in TM1 and this is a useful starting point: http://www-01.ibm.com/support/docview.wss?uid=swg21456988 Looking at your existing configuration is your AD/ LDAP server called ...
by Edward Stuart
Mon Oct 16, 2017 5:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Date Display Using Attribute Format
Replies: 7
Views: 2775

Re: TM1 Date Display Using Attribute Format

A good starting point is this comprehensive post on Dates and Times in the Useful Code section of the forum:

Working with Dates and Times
by Edward Stuart
Sat Sep 30, 2017 7:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Drill down help
Replies: 9
Views: 2384

Re: Active Form Drill down help

My interpretation was that users have access to all levels of dimension through perspectives but the requirement was to restrict access in active forms. If it is across the model then element security as per Tomok's suggestion would work. However I'm still not convinced this isn't a question relatin...
by Edward Stuart
Sat Sep 30, 2017 6:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Form Drill down help
Replies: 9
Views: 2384

Re: Active Form Drill down help

AFAIK it is only possible to restrict dimension security between TM1 front ends via contributor applications I would question why? (Performance? Usability? Asthetic?) But it could be achieved by generating a replica dimension to the required level. This obviously brings a level of additional mainten...
by Edward Stuart
Wed Sep 20, 2017 6:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Feed this Rule ??? pls help!!!
Replies: 3
Views: 943

Re: How to Feed this Rule ??? pls help!!!

If you haven't already then check the rules guide which contains examples that match your query:

https://www.ibm.com/support/knowledgece ... -gen5.html
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: 1672

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: 1299

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: 2951

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: 2951

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: 1797

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: 2041

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: 2041

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: 1007

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: 1007

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: 2041

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: 2041

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: 1561

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...