Search found 1845 matches

by Steve Rowe
Fri Jun 24, 2022 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange behaviour with ODBC query on 2.0.9.12
Replies: 3
Views: 1414

Re: Strange behaviour with ODBC query on 2.0.9.12

Tested in 2.0.9.14 and get the same failure.
Rolled all the way back to 2.0.5 and working again....
by Steve Rowe
Fri Jun 24, 2022 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange behaviour with ODBC query on 2.0.9.12
Replies: 3
Views: 1414

Re: Strange behaviour with ODBC query on 2.0.9.12

Unicode is checked.
I've not updated the ODBC drivers, customer is doing some analysis in that space to understand what the versioning is across the Ledger estate.
The messaging I am getting from IBM is to move to 2.0.9.14 as there are multiple fixes in the ODBC space in .13 and .14
by Steve Rowe
Thu Jun 23, 2022 7:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange behaviour with ODBC query on 2.0.9.12
Replies: 3
Views: 1414

Strange behaviour with ODBC query on 2.0.9.12

This is in the same space is in this thread . Upgraded a customer to 2.0.9.12. (One release behind the move to ODBC 3.0) The main dataload is a TI looping over a list of ledgers, calling TIs that run queries against various ODBC connections. This has worked happily for many years without issue. The ...
by Steve Rowe
Wed Jun 15, 2022 10:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.9.14 and changed behaviour with ODBC!
Replies: 8
Views: 2932

Re: PA 2.0.9.14 and changed behaviour with ODBC!

Hi John, It seems like ODBC 3.0 has been around since 1995. (https://en.wikipedia.org/wiki/Open_Database_Connectivity#Version_history) I'm struggling to find much reference material relating to common ODBC drivers and the ODBC version they are built against. Out of interest what is the source applic...
by Steve Rowe
Tue Jun 14, 2022 2:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.9.14 and changed behaviour with ODBC!
Replies: 8
Views: 2932

Re: PA 2.0.9.14 and changed behaviour with ODBC!

Thanks for raising JohnO.

Have IBM come back with detail on the required config changes to make this happen?

I assume "use Unicode" must be checked on the face of the TI and if opening the ODBC connection manually using ODBCOpen you need to use ODBCOpenEx instead?

Cheers,
Steve
by Steve Rowe
Mon Jun 13, 2022 12:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW
Replies: 9
Views: 1991

Re: Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW

Thanks for the cross link Mark, Rebecca H states Hi all, Active forms in Perspectives zero suppress on what would be the the symmetric view created from the elements referenced ... so if you have a stacked column axis ... even if you’ve removed some combinations, the symmetric view will still contai...
by Steve Rowe
Fri Jun 10, 2022 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW
Replies: 9
Views: 1991

Dynamic Reports, Asymmetric Column Headers, Excel and TM1 Web / PAW

One of those Fridays..... So I am seeing a difference in behaviour in Dynamic Reports in Exel and PAW. My underlying data looks like this. Data.png In Excel if I create a Dynamic Report versus this data consisting of only columns 2 and 3 in yellow, I correctly only get back Acc 0003. Once I publish ...
by Steve Rowe
Fri Jun 10, 2022 12:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Application Folder Security in PAW (only)
Replies: 0
Views: 1665

Application Folder Security in PAW (only)

Hi, Is anyone aware of any way of interacting with the Application folder security in the PAW / PAfE GUI? From what I can see there doesn't seem to be a method and so you can't get the cube created to hold the security. The good news is that you can create the cube manually and the security kicks in...
by Steve Rowe
Wed Jun 08, 2022 3:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Numeric parameter in TI MDX
Replies: 7
Views: 1654

Re: Numeric parameter in TI MDX

Don't you just need to drop the double quotes ?

(VAL([Year for Payroll Total].CURRENTMEMBER.PROPERTIES("Number")) <= '|pPayrollPeriodNumber|' )

Your testing vs a number so no need for the quotes
by Steve Rowe
Thu May 12, 2022 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The AWS Cloud no good, very bad performance
Replies: 13
Views: 3212

Re: The AWS Cloud no good, very bad performance

The AWS server must have slower cores in it then or being throttled in some way?
by Steve Rowe
Tue May 10, 2022 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Members versus Elements
Replies: 0
Views: 1669

Members versus Elements

Hi, Been meaning to post on this topic for a while and this thread has triggered me to write it. tl:dr. Members instead of elements, why do / should we care? Members and Elements have a technical definition many may be unaware of An element is the specific element within a hierarchy of a dimension, ...
by Steve Rowe
Tue May 10, 2022 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMNM performance in PAfE
Replies: 2
Views: 854

Re: DIMNM performance in PAfE

Wow, that's a big change in response times, I've voted and commented.

Any view on why their method takes so long to evaluate?
by Steve Rowe
Fri Apr 22, 2022 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Element Security gets wiped - how to debug
Replies: 5
Views: 2795

Re: Element Security gets wiped - how to debug

Is it possible the elements are getting deleted and then added back? I would expect you to be losing data against these elements as well if this is what is happening too.
by Steve Rowe
Thu Mar 31, 2022 8:28 am
Forum: Useful code, tips and tricks
Topic: Formatting of dynamic slices / active forms in TM1 Web or PAW versus Excel
Replies: 0
Views: 9065

Formatting of dynamic slices / active forms in TM1 Web or PAW versus Excel

Hi, Just hit this issue that had me scratching my head, pretty sure I've had it before so just writing it down here so if I search for it I can find the answer... If the formating of a Dynamic Report is working correctly in Excel but not in TM1 Web / PAW check the the named range TM1RPTFMTRNG"N...
by Steve Rowe
Wed Mar 30, 2022 7:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent Data Spread for ADMIN
Replies: 12
Views: 2744

Re: Prevent Data Spread for ADMIN

If you are going to use locking extensively and are combining that with TIs then you are probably also going to want to use CubeLockOverride(), a lightly documented TI function. To turn all locking off in the whole DB use CubeLockOverride(1); To turn it back on again use CubeLockOverride(0); Turning...
by Steve Rowe
Tue Mar 29, 2022 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SubsetElementExists, Aliases and Principal Names
Replies: 3
Views: 1246

Re: SubsetElementExists, Aliases and Principal Names

On the basis the Member ID / EPN and their respective aliases are always totally interchangable 100% of the time, this is a bug.

It is probably behaving as deisgned however....
by Steve Rowe
Tue Mar 29, 2022 9:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prevent Data Spread for ADMIN
Replies: 12
Views: 2744

Re: Prevent Data Spread for ADMIN

Thanks for the good idea! I did not think about "lock" (or "reserve") - but I checked the security: Members of ADMIN-Group do automatically always have ADMIN-rights to all Dimensions and Elements and this cannot be changed. Setting to LOCK will also stop admins from changing the...
by Steve Rowe
Tue Mar 15, 2022 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processes that load a reporting cube loads to incorrect server
Replies: 3
Views: 765

Re: TI processes that load a reporting cube loads to incorrect server

You've not mentioned the source for the TI processes. I'm guessing it is a SQL query. Have you checked that any ODBC connections in the production environment are not pointing at a Dev environment or a cube of reference information has not been promoted with the Dev information in it? It is far more...
by Steve Rowe
Mon Mar 14, 2022 5:00 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Approaching project complexity
Replies: 15
Views: 3380

Re: Approaching project complexity

I've been following this thread with interest. 20TS, my reading of the issues you are raising is that they were process and project management issues rather than a technology problem? Any project against any technology is going to look a mess if the initial scope is not correct and then there are si...