Search found 114 matches

by dan.kelleher
Mon Apr 09, 2018 9:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA API Certificate Issue
Replies: 0
Views: 190

VBA API Certificate Issue

Hi guys, We're experiencing an issue with an older client version connecting to PA 2.0.4. We have a set of certificates that works perfectly when using perspectives or architect however we are using the VBA API to connect: TM1SystemServerConnectWithCAMNamespace and this is not working. Is there a wa...
by dan.kelleher
Mon Aug 08, 2016 1:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: startup chore behaiviour
Replies: 14
Views: 1299

Re: startup chore behaiviour

My guess is that the stats cubes only start to get populated after the server has loaded and the startup chore has run, which makes sense to me. I would try running a nested TI process from the chore via tm1runti.exe and have the nested process do the waiting. TI process that's part of startup chore...
by dan.kelleher
Fri Jan 23, 2015 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel keep refreshing screen when flew view contain formula
Replies: 3
Views: 1804

Re: Excel keep refreshing screen when flew view contain form

Try turning your calculations to manual in Excel:

Formulas -> Calculation Options -> Manual.

You can then manually calculate your spreadsheet by pressing F9
by dan.kelleher
Fri Jan 16, 2015 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Write the feeders for this special Rules
Replies: 3
Views: 1841

Re: How to Write the feeders for this special Rules

Did you read through the article? You should read it and make sure you understand it otherwise you're going to get stuck when trying to write rules with any kind of complexity. Your rule is a very simple one, something like: SKIPCHECK; [‘Sal_Company’:’OutSale’] = N: ['Pro_Company':'Total_Company’]; ...
by dan.kelleher
Wed Jan 14, 2015 2:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Write the feeders for this special Rules
Replies: 3
Views: 1841

Re: How to Write the feeders for this special Rules

You don't necessarily need to write your rule using a DB function as it's not an inter-cube rule and you're not using any functions within the DB. You can feed from a consolidation (i.e. Total_Company), which is the same as writing individual feeders for each of the node level children of the consol...
by dan.kelleher
Mon Jan 05, 2015 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Average of last 12 months excluding months which dont have d
Replies: 4
Views: 1083

Re: Average of last 12 months excluding months which dont ha

There are a few considerations here. If you keep track of how many months you've loaded for each year in a separate cube, you can reference this denominator using a DB() function in place of your hard-coded 12. Alternatively you can create a new measure to keep track of whether Revenue_meas1 is non-...
by dan.kelleher
Fri Dec 12, 2014 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 10.2.2 RunTI.exe with SSO
Replies: 3
Views: 2200

Re: 10.2.2 RunTI.exe with SSO

HI, We have it working in 10.2 FP2: "D:\Program Files\ibm\cognos\TM1_10_2_64_DEV\bin64\tm1runti" -i "D:\xxx\tiprocess.config" -connect instance_label -process cube_clear_view psCube="xxx" psMonth="2014_01" tiprocess.config contains the following information: [TM1RunTi] [Connect - instance_label] adm...
by dan.kelleher
Fri Dec 12, 2014 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using TM1 numeric attribute in a BI Report calculation
Replies: 3
Views: 1257

Re: Using TM1 numeric attribute in a BI Report calculation

Would it not be better to calculate the measure in TM1 via a rule? BI is generally not very good (poor performance) when accessing dimension attributes directly.
by dan.kelleher
Fri Dec 12, 2014 11:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security Issue. User can view data in "Properties Window"
Replies: 6
Views: 1472

Re: Security Issue. User can view data in "Properties Window

I am assuming you still want the user to access the element? One possible solution is to store the attribute in a separate cube and utilise the tm1user() function in a rule to populate dynamically.
by dan.kelleher
Fri Dec 12, 2014 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot access the Operations Console
Replies: 9
Views: 4205

Re: Cannot access the Operations Console

We are still strugging to get this to work with custom CAM authentication, however the attached provided by IBM may be of use to you. Have you specified a group in the OpsConfig.xml you are using to control access? I am assuming this can just be the ADMIN group, although it might be worth trying a s...
by dan.kelleher
Wed Dec 03, 2014 5:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI DataSourceType variable
Replies: 6
Views: 1705

Re: TI DataSourceType variable

Have a look at the below: http://www-01.ibm.com/support/knowledgecenter/SS9RXT_10.2.0/com.ibm.swg.ba.cognos.tm1_ref.10.2.0.doc/c_turbointegratorlocalvariables_n80019.html%23TurboIntegratorLocalVariables_N80019?lang=en You may want to change the datasourcetype if you want a single process to handle t...
by dan.kelleher
Mon Dec 01, 2014 2:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problems with performance monitor
Replies: 2
Views: 1037

Re: Problems with performance monitor

http://www-01.ibm.com/support/docview.w ... wg21457087

Also have you tried running from Server Explorer? Right-click on the server -> start performance monitor

Try running from CMD.exe running as an admin.

Is your server name definitely correct?
by dan.kelleher
Wed Oct 29, 2014 5:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Compare Rules/TI processes for Production and Development
Replies: 6
Views: 1557

Re: Compare Rules/TI processes for Production and Developmen

This sounds like a source-code control issue. I'd suggest adopting a version control system such as the open-source Apache Subversion: https://subversion.apache.org/ I use a freeware client available here: http://tortoisesvn.net/ This also allows you to compare differences between versions of your c...
by dan.kelleher
Tue Sep 16, 2014 1:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic columns/variables for CSV import
Replies: 7
Views: 1909

Re: Dynamic columns/variables for CSV import

Yes, just tested my code and it works with a csv file with only 4 dimension columns, the other 'unused' variables (vsDimension_5 to vsDimension_12) are treated as empty strings at run-time.
by dan.kelleher
Mon Sep 15, 2014 8:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic columns/variables for CSV import
Replies: 7
Views: 1909

Re: Dynamic columns/variables for CSV import

Hi Wim,

The variables always exist, however where they are not needed, they are empty strings, which is why I use:

Code: Select all

If( vsDimension_X @<> '');
To determine how may dimensions the cube has.

Thanks,

Dan
by dan.kelleher
Fri Sep 12, 2014 10:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 CAM Security Issue
Replies: 2
Views: 1564

Re: TM1 CAM Security Issue

Hi Kangkc,

Thanks for the advice.

I can confirm that the issue was due to having SSL enabled on the Cognos BI dispatcher URI.

We disabled it and it now works.

Thanks,

Dan
by dan.kelleher
Fri Sep 12, 2014 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic columns/variables for CSV import
Replies: 7
Views: 1909

Re: Dynamic columns/variables for CSV import

Hi Fleaster, I have a process that loads data from csv into multiple cubes with varying dimensions - you can load data to different cubes within the same source file. The source file fields are as follows: Cube - string - name of the cube to be loaded Type - string - either 'string' or 'numeric' dep...
by dan.kelleher
Thu Sep 11, 2014 8:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to see ODBC sources when running TM1 as an applicatio
Replies: 4
Views: 791

Re: Unable to see ODBC sources when running TM1 as an applic

Are you running the application as 32-bit and the service as 64-bit? I think you may need to check which ODBC data sources you have created. It might also be to do with the account running the service/ application. If you're on Windows Server 2008, try right-clicking and running as administrator for...
by dan.kelleher
Tue Sep 09, 2014 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 CAM Security Issue
Replies: 2
Views: 1564

TM1 CAM Security Issue

Hi guys, We're having an issue using CAM authentication with TM1. We have 2 separate geographical instances (dedicated TM1 and BI servers in both locations) and it's working fine on one, but failing to log in on the other. I have highlighted the notable variables in the tm1s.cfg file: IntegratedSecu...