Search found 180 matches

by kavitha2002
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: 1494

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...
by kavitha2002
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: 2641

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 ...
by kavitha2002
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: 2641

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....
by kavitha2002
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: 2641

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...
by kavitha2002
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: 2641

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...
by kavitha2002
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: 1277

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...
by kavitha2002
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: 1277

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...
by kavitha2002
Fri Oct 09, 2020 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Https for Tm1 Rest api
Replies: 1
Views: 1981

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...
by kavitha2002
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: 4006

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...
by kavitha2002
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: 4006

Re: Connect to Power BI using TM1 Rest api

I have tried "application/json" as well, but end up with the same error.
by kavitha2002
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: 4006

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.
by kavitha2002
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: 4006

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...
by kavitha2002
Mon Jan 13, 2020 8:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Datasource for Power BI
Replies: 9
Views: 8185

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...
by kavitha2002
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: 2855

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...
by kavitha2002
Fri Jan 10, 2020 2:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Datasource for Power BI
Replies: 9
Views: 8185

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.
by kavitha2002
Fri Jan 10, 2020 11:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Datasource for Power BI
Replies: 9
Views: 8185

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 ...
by kavitha2002
Fri Jan 10, 2020 8:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Datasource for Power BI
Replies: 9
Views: 8185

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...
by kavitha2002
Wed Dec 04, 2019 10:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics Installation
Replies: 2
Views: 2618

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.
by kavitha2002
Thu Nov 28, 2019 3:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics Installation
Replies: 2
Views: 2618

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...