Search found 32 matches

by jydell
Wed Feb 28, 2024 3:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Throughs not accepting left Joins SQL- but accept where joins
Replies: 3
Views: 526

Re: Drill Throughs not accepting left Joins SQL- but accept where joins

Solved - Thanks @gtonkin Joins now work with the full path.

and @Elessar, I think the approach keeping complex SQL out of TM1 is a good idea too, I will work towards this.
by jydell
Tue Feb 27, 2024 12:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill Throughs not accepting left Joins SQL- but accept where joins
Replies: 3
Views: 526

Drill Throughs not accepting left Joins SQL- but accept where joins

Hi Issue : TM1 Drill through SQL does not allow me to write "left joins" to a relational database. (there are other inconsistencies but left join is easiest to use as an example) But TM1 does allow me to Join in the where clause. Example : Per the below both queries work in SSMS. But only ...
by jydell
Sat Aug 17, 2019 12:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel DisableWritebackOnTM1Formula? cannot write back TM1p.ini file
Replies: 1
Views: 3270

Re: Excel DisableWritebackOnTM1Formula? cannot write back TM1p.ini file

After further testing this and think I am on the wrong track. As DBRW formulas are allowing writeback to the database (and entry does not remove TM1 formula), it is probably not "DisableWritebackOnTM1Formulas" causing my issue. My problem appears limited to DBRA or DBSA formulas not sendin...
by jydell
Thu Aug 15, 2019 12:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel DisableWritebackOnTM1Formula? cannot write back TM1p.ini file
Replies: 1
Views: 3270

Excel DisableWritebackOnTM1Formula? cannot write back TM1p.ini file

Hi I am experiencing an issue where typing over a valid DBRA formula does not write back to the database, excel instead overwrites the cell only: Steps * New greenfield installation of Planning analytics (PAX and PAW) * effects all Users (including admin) * Typing over a valid DBRA formula (DBRA for...
by jydell
Mon Nov 05, 2018 1:35 am
Forum: General
Topic: Outsourcing options
Replies: 5
Views: 62763

Outsourcing options

Hi. Interested has anyone had luck outsourcing tm1 development overseas. (I’m thinking full time developer based in low cost country). I have changed roles and looking at implementing tm1 but the budget does not allow for an in house developer (except me as a knowledgeable user). And the business ca...
by jydell
Thu Jul 07, 2016 6:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule worksheet save does not update
Replies: 2
Views: 2529

Re: Rule worksheet save does not update

Hi, yes using rule save functionality.
by jydell
Tue Jul 05, 2016 10:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule worksheet save does not update
Replies: 2
Views: 2529

Rule worksheet save does not update

Hi I have been having an issue for the last couple of months where when I save a TM1 rule worksheet (.xru file) it does not update the Rule (.RUX). There is no error message to indicate the rule did not save. (however I notice the save process runs very quickly and when checking the rule in the .RUX...
by jydell
Sun Jul 27, 2014 10:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Circular reference in my worksheet
Replies: 11
Views: 9884

Re: Circular reference in my worksheet

Hi I have resolved this for this workbook. There was "One" cell in the entire workbook that was actually circular (divided by itself). I found this by process of elimination deleting sheets and recalculating until I found the offending sheet, then found the cell. Unfortunately Excel was no...
by jydell
Fri Jul 25, 2014 2:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Circular reference in my worksheet
Replies: 11
Views: 9884

Re: Circular reference in my worksheet

Hi all Similar problem with me. This may not be TM1 related, but I have only experienced this in spreadsheets with TM1 installed. On all TABs of my worksheet (worksheet has multiple tabs with many TM1 / excel formula's) I am getting a excel circular reference warning pointing to a cell (different ce...
by jydell
Tue Jan 21, 2014 2:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatic spreadsheet update, Cam level security
Replies: 3
Views: 3370

Re: Automatic spreadsheet update, Cam level security

Sorry just noticed the other thread posted today with same issue. (no easy answer)
by jydell
Tue Jan 21, 2014 2:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Automatic spreadsheet update, Cam level security
Replies: 3
Views: 3370

Automatic spreadsheet update, Cam level security

Hi We recently "downgraded" from TM1 9.5.2 to cognos express with xcelerator 10.1. (due to cheaper pricing model) Part of the change was to move to Cam level security. Since moving to CAM level security we have lost the ability to use Excel VBA and "N_Connect" to TM1. I have sear...
by jydell
Thu Jul 11, 2013 6:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel workbook slow "first time" open with TM1 9.5.2
Replies: 2
Views: 3515

Re: Excel workbook slow "first time" open with TM1 9.5.2

Thank Oliver, you saved me I do not have any active forms however the spreadsheet may have had some in the past (later deleted) so the Name "TM1REBUILDOPTION" was still there and set to = 1 as you suspected. When I changed this to = 0 it fixed the issue. Additionally as there are no longer...
by jydell
Wed Jul 10, 2013 11:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel workbook slow "first time" open with TM1 9.5.2
Replies: 2
Views: 3515

Excel workbook slow "first time" open with TM1 9.5.2

Hi I have recently experienced an issue where a particular excel workbook is slow to open the first time opened in the day however is fast to open without loggin onto TM1. Characteristics of the issue include 1: File opens quickly <1 second if I have not logged into TM1. (TM1 addin live just not log...
by jydell
Sun Jan 08, 2012 11:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Trace Security Access Issues
Replies: 2
Views: 3443

Re: How to Trace Security Access Issues

Thanks Alan

You were right, when double checking the dimension secutity (via displaying control objects) I found read access only granted to the specific N elements in the dimension for her profiles. Now its fixed.

Regards
by jydell
Sun Jan 08, 2012 10:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Trace Security Access Issues
Replies: 2
Views: 3443

How to Trace Security Access Issues

Hi I have a user that I need to change her access in order to edit data in a cube. I have tried the below but still the user does not have access to write to the cube (ie greyed out cell in the view). Does anyone know of a way to track which specific part of the security profile is blocking write ac...
by jydell
Wed Jan 04, 2012 9:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help with feeder stmt...
Replies: 13
Views: 8978

Re: Need help with feeder stmt...

I agree with David, I recomend you consider building your GL Actual Balances cube from scratch rather than make it Feeder / rule based. Use a similar method you use to populate the GL Actual Transaction cube (I assume this is populated by TI) Alternatively ASCII export a predefined view of the 'GL t...
by jydell
Wed May 18, 2011 10:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation Hierarchy on the fly ?
Replies: 15
Views: 9245

Re: Calculation Hierarchy on the fly ?

I may have over complicated things. Simpler solution would be to have two hierachies within you dimension structure one for "marketing" one for "all". Use your existing method (either TI or dimension speadsheet etc) you use for the "all" hierachy to create another one f...
by jydell
Mon May 16, 2011 10:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Calculation Hierarchy on the fly ?
Replies: 15
Views: 9245

Re: Calculation Hierarchy on the fly ?

A simple solution for you may be have multiple dimension hierachies. You can have a marketing hierachy that shows A= 10 C = 10 Total Marketing = A+C = 20 This can be a seperate hierachy to your example A + B + C = Total 30 This can be done via TI if you want it produced automatically, 1: Flag the el...
by jydell
Thu Mar 31, 2011 2:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Resolving Hierarchy issue
Replies: 2
Views: 2541

Re: Resolving Hierarchy issue

Hi Not sure of your question but here are some functions that may assist if you require a function to return the parent element try the "ELPAR" function this returns the parent of an element in a specified dimension or "ELLEV" function returns the level of an element within a dim...
by jydell
Mon Mar 07, 2011 9:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Public View with a Private Subset
Replies: 3
Views: 3502

Re: Public View with a Private Subset

Thanks Paul Unfortunately we are still on TM1 9.1 so Active forms are not an option for us. The requirement for the user defined subset is in the header section of the report (so this makes it a bit easier) At this stage it looks like I need to run for all data in a VUSLICE (probably retrieving 60,0...