Search found 180 matches
- Mon May 16, 2022 7:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect TM1 Perspectives(IntegratedSecurityMode 5) with CAMPassport in vba
- Replies: 0
- Views: 1590
Connect TM1 Perspectives(IntegratedSecurityMode 5) with CAMPassport in vba
Hello Everyone, I have tried to connect to TM1 Perspectives in IntegratedSecurityMode 5 with CAMPassport in excel vba automatically. Previously with 'N_CONNECT_CAM' with n_connect_cam_bridge.dll worked well in excel 32 bit. In the current latest vesion of TM1 Pespective will support only 64 bit. Sam...
- Mon Mar 21, 2022 7:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
- Replies: 8
- Views: 2713
Re: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
Followed the instructions suggested by you. Got the below in the lock file under logs, there is no such error stated about the 'Certification Validation error' 2022-03-18 15:40:27 local Shared memory reader PID 12960 started, for shmem "tm1s.exe-1880_2" So no idea where the actual problem ...
- Tue Mar 15, 2022 8:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
- Replies: 8
- Views: 2713
Re: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
Site addresses are already added under the 'Local Intranet Sites' in browser. Regarding the certificate, for Cognos I have CA root Certificate(from IBM) under which my selfsigned certificate present. Attached the screenshot for the same. The request is via Gataway. url: https://win2016ca.domainname....
- Fri Mar 11, 2022 3:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
- Replies: 8
- Views: 2713
Re: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
I have double checked the bi_interop step. Checked all urls are being set with https. But no luck.
- Thu Mar 10, 2022 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
- Replies: 8
- Views: 2713
Re: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
Hi Burnstripe, Thanks for you response. Yes, both CA + PA installed in same machine. Actually the scenario is, I have already configured CA with PA as protocol 'http and IntegratedSecurityMode 5', its working fine. Now I have changed SSL(self-signed certificate) for CA and PA. For Tm1web and TM1serv...
- Fri Mar 04, 2022 3:15 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
- Replies: 8
- Views: 2713
SSO not working for (SSL) selfsigned cert for Planning Analytics via Cognos Analytics(Mode5)
Hello Everyone, I am configuring the SSL(https) selfsigned certificate for CA and PA. As a initial step, I have configured for PA tm1web and TM1 Server which is working fine. Then I have configured SSL(https) for Cognos Analytics, it is also working fine with https+SSO. Till this point everything we...
- Mon Feb 21, 2022 2:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 web url api mode 5 login page popup all the time
- Replies: 3
- Views: 1295
Re: Tm1 web url api mode 5 login page popup all the time
Thanks for your reply. I have specified the below in tm1web_config.html. Is this do you mean? <!-- When performing CAM authentication, optional redirection url override example http://127.0.0.1:9510/tm1web --> <add key="ExternalUrl" value="http://FQDN:9510/tm1web" /> In url I spe...
- Mon Feb 21, 2022 1:13 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 web url api mode 5 login page popup all the time
- Replies: 3
- Views: 1295
Tm1 web url api mode 5 login page popup all the time
Hello Everyone, I have a quick question, I have embedded the Tm1web url api in my application. Working in IntegratedSecuritymode 5, authenticationMode is CAMNamespace http://fullyqualified-domainname:9510/tm1web/UrlApi.jsp#Action=Open&Type=WebSheet&Workbook=Applications/WebExplorer/xxx/Erfas...
- Fri Oct 09, 2020 6:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Https for Tm1 Rest api
- Replies: 1
- Views: 2015
Https for Tm1 Rest api
Hello Everyone, I would like to have a secure communication between client(Tm1 Restapi) and TM1 Server so I set the UseSSL = True in tm1s.cfg. Then I checked the link 'https://localhost:8000/api/vi/Server' in the chrome browser, it works fine. But its not working in IE and firefox. Its saying insecu...
- Mon Jan 27, 2020 7:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to Power BI using TM1 Rest api
- Replies: 5
- Views: 4055
Re: Connect to Power BI using TM1 Rest api
I have changed the Power BI syntax for the MDX query. Now query working well. For the future reference, I am leaving the working query below. let url = "http://localhost:8000/api/v1/ExecuteMDX?$expand=Cells($select=Ordinal,Value)", body = "{ ""MDX"": ""SE...
- Sun Jan 19, 2020 3:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to Power BI using TM1 Rest api
- Replies: 5
- Views: 4055
Re: Connect to Power BI using TM1 Rest api
I have tried "application/json" as well, but end up with the same error.
- Fri Jan 17, 2020 9:41 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to Power BI using TM1 Rest api
- Replies: 5
- Views: 4055
Re: Connect to Power BI using TM1 Rest api
Yes true, I agree. But I am trying with TM1 Rest api with Web Connector. Just as a POC.
- Fri Jan 17, 2020 8:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Connect to Power BI using TM1 Rest api
- Replies: 5
- Views: 4055
Connect to Power BI using TM1 Rest api
Hello Everyone, In Power BI, I have tried the with Rest api MDx query. In GetData -> web-> in Advancced option, gave RestapiUrl to fetch the Dimension Element. It Worked well and pull the elemnts from TM1 with the 'GET' Request. Now am trying with MDX POST request to fetch the cube data. AS I am new...
- Mon Jan 13, 2020 8:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Datasource for Power BI
- Replies: 9
- Views: 8277
Re: Tm1 Datasource for Power BI
@MariusWirtz Thanks for your confirmation and reply. Based on your reply, my understanding is there is a possibility of implementing via TM1PY. Via Python scripts in PBI, data will be live or do we need to refresh the data by writing some scheduling. As I said am completely new on this area, so will...
- Mon Jan 13, 2020 8:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creation of Tm1 windows ODBC Datasource
- Replies: 0
- Views: 2865
Creation of Tm1 windows ODBC Datasource
Hello Everyone, This is the first time I am creating, so need some minimal support. I have come across the link https://it.toolbox.com/question/how-to-configure-cognos-datasource-via-odbc-connection-012710 which explain how to create a ODBC connection for TM1. But I need llittle more clarity on this...
- Fri Jan 10, 2020 2:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Datasource for Power BI
- Replies: 9
- Views: 8277
Re: Tm1 Datasource for Power BI
In Python, I can use TM1PY library, and I can access the TM1 Data. In Power BI I can use Python, so that via Python Scripts I can access TM1.
Is my understanding correct? if not kindly correct me.
Is my understanding correct? if not kindly correct me.
- Fri Jan 10, 2020 11:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Datasource for Power BI
- Replies: 9
- Views: 8277
Re: Tm1 Datasource for Power BI
Thanks for the post.. I have gone through link. As I am very new to all these PowerBI, TM1PY etc, can you provide me some link or steps on how to proceed further. It would be a great help for me:) I would like to create an own connecto to connect Power BI with TM1. I dont know python, how long will ...
- Fri Jan 10, 2020 8:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Datasource for Power BI
- Replies: 9
- Views: 8277
Tm1 Datasource for Power BI
Hello Everyone, I am currently looking forward for an option to connect TM1 to Power BI tool without using any third party connector. I read in some forum that, creating ODBC datasource using Cognos Connection Framework Manager and using ODBC connecting to Power BI. I am not sure, I have to try this...
- Wed Dec 04, 2019 10:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos Analytics Installation
- Replies: 2
- Views: 2646
Re: Cognos Analytics Installation
@Bakkone thanks for your reply.
I have checked with IBM support too. They suggested me to go with Licensed MS SQL Server instead of DB2.
I have checked with IBM support too. They suggested me to go with Licensed MS SQL Server instead of DB2.
- Thu Nov 28, 2019 3:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos Analytics Installation
- Replies: 2
- Views: 2646
Cognos Analytics Installation
Hello Everyone, I need some clarity or suggestion on the below question. Customer would like to have SSO for tm1web. For installation at customer end, can I have "MS SQL Server Express Free Edition" installed for content Store Database? Is it ok for long run or I have to install the licens...