Search found 13 matches

by a1m80t
Thu Jul 23, 2020 7:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBCOutput Insertion to HANA Performance
Replies: 5
Views: 3317

Re: ODBCOutput Insertion to HANA Performance

Thank you!!! I just implemented this and it will definitely increase our efficiently of using file dumps
by a1m80t
Wed Apr 29, 2020 11:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException
Replies: 16
Views: 7169

Re: No Data Tree in PAW 2.0.49 with error 500 javax.crypto.BadPaddingException

If PAW/PA are installed on the same server, then you need to specify the IP4 or IP6 in TM1s.cfg IPAddressV4="10.109.241.121" https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_ipaddressv4_tm1cfg.html IPAddressV6="0ff1:aa00:4125:2:a05:f7...
by a1m80t
Thu Mar 26, 2020 9:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DatasourceUsername and DatasourcePassword
Replies: 2
Views: 1801

Re: DatasourceUsername and DatasourcePassword

1. The service id used to start TM1 can be use for Windows Authentication to your ODBC data source. This is automatically done if you do not put a username and password in the TI Process and if your ODBC Data Source has Windows Authentication enabled for your TM1 service ID. BTW, by setting the serv...
by a1m80t
Wed Nov 20, 2019 7:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: kinit error - Tm1web SSO with Kerberos authentication
Replies: 1
Views: 2119

Re: kinit error - Tm1web SSO with Kerberos authentication

This can be a lot of things but I can vaguely rememeber two things that did: 1. On the Account tab in Active Directory, I believe the user name should be something like HTTP/username.domain When you create the SPN this is automatically done, but sometime it doesn't work right for whatever reason. 2....
by a1m80t
Thu Nov 14, 2019 4:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Quick Reports and MDX
Replies: 6
Views: 3606

Re: Quick Reports and MDX

While I 100% agree this should be done in the GUI, you can still make an Quick Report to function as an Active Report with minimal VBA 1. Create a dynamic MDX generator in Excel. You can use Exploration Report to give you an idea on how to create the MDX 2. Create a Quick Report where it needs to be...
by a1m80t
Thu Nov 07, 2019 3:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx Issue
Replies: 5
Views: 3597

Re: PAx Issue

I noticed that on custom and dynamic reports, excel circular references from any open workbook will break refreshes.
by a1m80t
Sat Nov 02, 2019 5:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX Dynamic Report is not rendering to TM1 Web
Replies: 3
Views: 5384

Re: PAX Dynamic Report is not rendering to TM1 Web

Wim Gielis wrote: Fri Nov 01, 2019 9:10 pm Thanks. Is it fixed in a later version ?
I don't have this problem in PA 2.0.8 and I'm pretty sure it wasn't in 2.0.6 either
by a1m80t
Tue Oct 29, 2019 10:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 20
Views: 20899

Re: Drill-through to a cube view

Not exactly sure what it means that a Drill-Through is not actually a saved view. Are you saying it is not creating a view and assigning subsets to it? There isn't a view name listed in any of the TM1 user interfaces. However, you basically have full control of the Drill-Through "view" th...
by a1m80t
Tue Oct 29, 2019 3:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 20
Views: 20899

Re: Drill-through to a cube view

I normally copy the ReturnViewHandle below the generated section then go to the data source and set to none. I generally only need the parameters so that I can build and assign the view in Prolog. No need for Metadata and data. YMMV Bingo, this did it. The view name will name will show up as "...
by a1m80t
Tue Oct 29, 2019 3:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 20
Views: 20899

Re: Drill-through to a cube view

I normally copy the ReturnViewHandle below the generated section then go to the data source and set to none. I generally only need the parameters so that I can build and assign the view in Prolog. No need for Metadata and data. YMMV Bingo, this did it. The view name will name will show up as "...
by a1m80t
Fri Aug 16, 2019 9:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW is not creating any containers in windows after installing 2.0.44
Replies: 7
Views: 11267

Re: PAW is not creating any containers in windows after installing 2.0.44

From my experience, PAW 2.0.44 upgrade failed on two different servers while the previous 5 or so releases worked fine. However, PAW 2.0.44 did work on a fresh install of Windows with default docker configuration. I think there is an issue with the PAW 2.0.44 installer which will probably be fixed i...
by a1m80t
Mon Apr 22, 2019 6:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 and SAP HANA Integration
Replies: 5
Views: 7804

Re: TM1 and SAP HANA Integration

TM1 to HANA integration isn't really different and works as expected. I have connected TM1 to HANA with and without SSO/SSL

1. Download and Install ODBC Drivers as mention by Moby91 on the TM1 Server
2. Configure "Windows ODBC Data Sources" as with any other ODBC driver
by a1m80t
Tue Mar 10, 2015 12:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Urgent, Collapse / Expand in Websheet moves data!!!!!!!!
Replies: 11
Views: 8103

Re: Urgent, Collapse / Expand in Websheet moves data!!!!!!!!

I'm pretty sure I ran into this issue last year on TM1 10.2 FP2 but it was "fixed" in the following interim fix pack. My memory may not be perfect, but I can confirm this isn't a problem in TM1 10.2.2 FP2 (TM1 10.2.2.2). IBM "fixed" it by simply undoing the data change (green fon...