Search found 101 matches

by tosca1978
Thu Jul 28, 2016 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule derived element level security
Replies: 1
Views: 2119

Rule derived element level security

First of all apologies if my question has already been answered on another thread - I did check but couldn't find what I was looking for. I have also read the article: Changes to TM1 Application deployment and rights-saving in TM1 10.2. I'm on v 10.2.2 with fix pack 5. The issue: I have a TM1 Web ap...
by tosca1978
Wed Apr 03, 2013 9:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a TI only if the data has changed
Replies: 10
Views: 6780

Re: Running a TI only if the data has changed

Thanks very much to everyone for your replies - it's really appreciated. My suggestion would be to use RunTI.exe which is included with 10.1 The solution would be to segregate the VALIDATION of the parameters for clearing data in the reporting cube and loading of new data from the actual EXECUTION. ...
by tosca1978
Tue Apr 02, 2013 7:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Running a TI only if the data has changed
Replies: 10
Views: 6780

Running a TI only if the data has changed

Hi all. I am on v10.1... Apologies for the long e-mail. If you haven't got time to read it all skip to the question right at the bottom! If you have got time you might be able to point out if I'm asking the wrong question - like a design fault perhaps. Setting the scene: I have 2 cubes - an input cu...
by tosca1978
Tue Jan 08, 2013 2:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PMT supported function in TM1 web
Replies: 5
Views: 5346

Re: PMT supported function in TM1 web

From the reference documentation This is a TM1® rules function, valid in both TM1 rules and TurboIntegrator processes. PAYMT returns the payment amount of an annuity based on a given initial value or principal, an interest rate, and a number of periods. An annuity is a series of payments made at eq...
by tosca1978
Tue Jan 08, 2013 10:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PMT supported function in TM1 web
Replies: 5
Views: 5346

Re: PMT supported function in TM1 web

AnthonyT wrote:Is this the same as PAYMT ?

I'm not sure what PAYMT is - is it an excel function or TM1 function? I can't find it in either. PMT calcuates the monthly payment on a loan...
by tosca1978
Mon Jan 07, 2013 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PMT supported function in TM1 web
Replies: 5
Views: 5346

PMT supported function in TM1 web

Hi all, I am using TM1 v10.1 and excel 2007. In the cognos TM1 Developer Guide\Supported Excel Functions - TM1 Web - Finance Functions: it states that the PMT function is supported. However it doesn't seem to be working for me. I have created a TM1 worksheet containing the following: Loan Value Loan...
by tosca1978
Fri Oct 19, 2012 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing text box in parameter of TI/Action Button
Replies: 2
Views: 2527

Re: Referencing text box in parameter of TI/Action Button

Hi Lotsaram,

thanks for your reply. That makes perfect sense. I'll stick with the cell/named range for the commentary input.

Cheers
by tosca1978
Fri Oct 19, 2012 8:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing text box in parameter of TI/Action Button
Replies: 2
Views: 2527

Referencing text box in parameter of TI/Action Button

Hi all, I have an excel worksheet which the end user will access via TM1 Web. It shows variances between actual and forecast and has a cell for the end user to add a comment before submitting his work. The cell containing the comment is a named range called "Comment". There is an action bu...
by tosca1978
Fri Oct 12, 2012 8:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Building workflow
Replies: 1
Views: 2038

Building workflow

Hi all, I am attempting to buid submission/approval workflow into a model that I have built. I have a plan but would welcome any tips from others that have done this before. A brief overview of the model: Prodcution model that holds actuals and budget units produced by month. Every month end users w...
by tosca1978
Thu Oct 11, 2012 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: C level rule to calculate average
Replies: 3
Views: 3323

Re: C level rule to calculate average

No it's not. There must be some other reason. A numeric attribute is held in the attribute cube as if it were a string. You can try using it in a rule in the attribute cube to check this. This means that a numeric attribute value can be held against a consolidated item of the corresponding dimensio...
by tosca1978
Thu Oct 11, 2012 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: C level rule to calculate average
Replies: 3
Views: 3323

C level rule to calculate average

Hi all, I have the following rule to caluclate the average cost per day: ['Product a','Average Final Value'] = C: IF( ATTRS('Time_Day',!Time_Day,'Act For')@='Actual', DB('Production Actuals',!Production Hierarchy,'Oil','mmscfd',!Time_Day,'Final Value')\31, CONTINUE ) ; The results are correct as per...
by tosca1978
Thu Oct 11, 2012 7:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ATTRS/N or DB}ElementAttributes for rule?
Replies: 3
Views: 3369

ATTRS/N or DB}ElementAttributes for rule?

Hi all, I was just wondering what the best practice is for referencing an attribute from within a rule. For example I could write the following 2 pieces of code within a rule to achieve the same result: ATTRS('Time_Day',!Time_Day,'Act For')@='Actual', or DB('}ElementAttributes_Time_Day',!Time_Day,'A...
by tosca1978
Thu Sep 27, 2012 9:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing alias in MDX Subset for active form
Replies: 6
Views: 6393

Re: Referencing alias in MDX Subset for active form

Lotsaram,

I can't thank you enough...you're a star!
by tosca1978
Thu Sep 27, 2012 8:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Referencing alias in MDX Subset for active form
Replies: 6
Views: 6393

Referencing alias in MDX Subset for active form

Hi all, I am using TM1 v10.1 and excel 2007. I have an active form with the following MDX statement incell B9: FILTER({TM1DRILLDOWNMEMBER( {[LP Hierarchy].[BD7041170]}, ALL, RECURSIVE )}, [LP Hierarchy].[Status] = 'ACTIVE') This is a concatenation of three other cells, one of which is bringing back ...
by tosca1978
Thu Sep 13, 2012 7:45 am
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 73764

Re: Copying Data from 1 Element to Another via TI

Before diving into the code, a few words on the benefits of this process. The process allows you to copy text data.Wim Wim, first of all, many thanks your post has saved me a lot of time and effort trying to write a generic TI to copy from one version to another. I have set up a TI using your code ...
by tosca1978
Wed Jul 25, 2012 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Qualifying string for ODBC Output
Replies: 4
Views: 5187

Re: Qualifying string for ODBC Output

This is a very common problem in SQL since the apostrophe is a reserved character. I should know since my last name has an apostrophe in it and I can't tell you how many times a web site won't work for me because the numb-nuts programmer didn't take it into consideration. It's easy, just replace th...
by tosca1978
Wed Jul 25, 2012 11:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Qualifying string for ODBC Output
Replies: 4
Views: 5187

Qualifying string for ODBC Output

Hi, I have a TI with an ODBCOutput command line to export cube data to a SQL table. The code on the advanced data tab looks like: IF(vMeasure@='Manager); ODBCOutput('COLUMBUS_TM1_PUBLISH', Expand( 'update [COLUMBUS_TM1_PUBLISH].[dbo].[VENTURES] SET [Manager] = ''%vValue%'' where [NV Versions]=''%vNV...
by tosca1978
Thu Jul 19, 2012 8:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web Error
Replies: 12
Views: 7328

Re: TM1 Web Error

Hi All, I'm working in TM1 v10.1.0 I have a TM1 worksheet with an active form published to TM1 web. I have been testing data entry - I enter data, then hit an action button that runs a ti to save data across versions and send data from input cube to reporting cube. 9 times out of 10 it works flawles...
by tosca1978
Wed Jul 11, 2012 7:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to remove contributor application
Replies: 8
Views: 10423

Re: Unable to remove contributor application

Charbel/Jennifer, thanks to you both for your posts. Hi you are usin CAM security you might also find you need to remove the link to the application by logging into localhost/ibmcognos and choosing Cognos Content. You can then get to a list of tm1 applications and if your old application still shows...
by tosca1978
Wed Jul 04, 2012 9:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput TI error
Replies: 5
Views: 4767

ODBCOutput TI error

Hi, I have the following TI set up to export the cell annotation to a sql table: Data source: Cube view of }CellAnnotations cube Variables: as per the cube plus 4 extra that scan the value to find the creator name, timestamp and comment etc. All variables set to other. Advanced Prologue: ODBCOpen('C...