Search found 172 matches

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: 488

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"": ""SELECT {[}zPBI_Account].Members} on 0, {[}zPBI_...
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: 488

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: 488

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: 488

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: 6
Views: 994

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: 816

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: 6
Views: 994

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: 6
Views: 994

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: 6
Views: 994

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: 813

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: 813

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 licensed version...
by kavitha2002
Wed Nov 27, 2019 3:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Datasource for Longview Analytics
Replies: 0
Views: 894

Tm1 Datasource for Longview Analytics

Hello Everyone, I am trying to set SSO for Longview analytics. Longview webserver - IIS. To make it more clear on Longview Analytics, there a 2 clients 1. Long view Analytics Designer 2. Long view Web Client. Till now I did the below steps: Installed Cognos Analytics Architect/Perspectives working w...
by kavitha2002
Wed Nov 20, 2019 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: kinit error - Tm1web SSO with Kerberos authentication
Replies: 1
Views: 272

kinit error - Tm1web SSO with Kerberos authentication

Hello Everyone, One of our customer would like to have SSO for tm1web on mode 3. I am working on setting up the Kerberos authentication for tm1web for SSO in my local. Followed the below link for reference: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2....
by kavitha2002
Wed Nov 20, 2019 12:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom SSL cert for Tm1 web
Replies: 5
Views: 10699

Re: Custom SSL cert for Tm1 web

Thanks for your reply Elessar. In my case 3rd Party Company has already Issued the Certificate for 'TM1Web'. I can skip the CSR request to CA. Because, currently I have the issued certificate which are .pfx file and related Certs + Key + root files. I have to replace the old Certificate with new Cer...
by kavitha2002
Mon Oct 28, 2019 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom SSL cert for Tm1 web
Replies: 5
Views: 10699

Re: Custom SSL cert for Tm1 web

Yes, exactly. Good catch @Elessar TM1 Version - 2.0.7 I have also referred the same link. Of course in step 4, dont have any idea of how to proceed. Do I really need to submit to CA? Because client has 3rd party Certificates and files as below: .pfx file - Personal Information Exchange xxx_cachain -...
by kavitha2002
Thu Oct 17, 2019 11:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Custom SSL cert for Tm1 web
Replies: 5
Views: 10699

Custom SSL cert for Tm1 web

Hello Everyone, I have a quick question on which files to import into the IKeyMan tool after the CSR request been made under the Personal Certificate. Because customer is having below files. Certificate is about to expire and have to change it to work for TM1Web. .key, pkcs#7 certificates, .pem file...
by kavitha2002
Fri Oct 11, 2019 11:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Action button - call Macro
Replies: 10
Views: 4903

Re: Tm1 Action button - call Macro

Thanks for reply and suggestion.
by kavitha2002
Wed Oct 02, 2019 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unique identity to identify elements in TM1 subsetEditor
Replies: 1
Views: 1389

Unique identity to identify elements in TM1 subsetEditor

Hello Everyone, we have our own web application in which we have reports, views etc. In addition to that we also have subset editor almost similar to TM1 subsetEditor where user can pick the elements. Having huge number of elements in dimension/subset there is a performance issue in fetching the dat...
by kavitha2002
Fri Sep 27, 2019 6:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Action button - call Macro
Replies: 10
Views: 4903

Re: Tm1 Action button - call Macro

It should work in excel (TM1 Perspectives).
by kavitha2002
Thu Sep 26, 2019 3:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Action button - call Macro
Replies: 10
Views: 4903

Re: Tm1 Action button - call Macro

What do you want to do ? Using a shape or textbox instead of an action button, and then the consequence is that you can't easily run TI processes ? yes, exactly. I would like to make a report with shapes or textboxes and call the TI process via macros. Above I have attached the sample report for re...