Search found 149 matches

by kavitha2002
Thu Jul 04, 2019 11:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange behaviour when value set to MaximumPorts in }clientProperties
Replies: 4
Views: 286

Re: Strange behaviour when value set to MaximumPorts in }clientProperties

Excellent explanation. Thanks for your time and detailed reply.

I will leave the setting empty(=0)

what is the role of 'HTTPSessionTimeoutMinutes' here. My understanding is this variable is for REST api session timeout. Am I right??
by kavitha2002
Wed Jul 03, 2019 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange behaviour when value set to MaximumPorts in }clientProperties
Replies: 4
Views: 286

Re: Strange behaviour when value set to MaximumPorts in }clientProperties

Maybe several actions from the user require several logins, therefore exceeding the maximum ? May be true but when I set 3 in MaximumPorts in }clientProperties and oped the architect once and again open the architect sometimes working and sometimes showing ClientMaximumPortExceeded. Same happening ...
by kavitha2002
Tue Jul 02, 2019 8:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 MDX Select Query
Replies: 0
Views: 115

Tm1 MDX Select Query

Hello Everyone, I want to clarify a doubt related to MDX Select query. I have a Cube in which the same elements in Row dimension has recursively represented many times in .xdi file. To read the cube values, below query am using, it returns the wrong value of the cube because of the recursiveness I t...
by kavitha2002
Fri Jun 28, 2019 12:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Strange behaviour when value set to MaximumPorts in }clientProperties
Replies: 4
Views: 286

Strange behaviour when value set to MaximumPorts in }clientProperties

Hello Everyone, In my application I am using the REST Api to login to TM1 which is 'http://localhost:8000/api/v1/ActiveSession/User' its working fine when MaximumPorts set to zero in }clientProperties cube. When I set 3 or more value to MaximumPorts, then REST Api request returns 401 unauthorized er...
by kavitha2002
Fri Jun 14, 2019 1:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 rest api - to read the info from tm1s.cfg
Replies: 0
Views: 195

Tm1 rest api - to read the info from tm1s.cfg

Hello Everyone, Is there a possibility of reading the 'HTTPSessionTimeoutMinutes' parameter from tm1s.cfg using TM1 rest api? I have tried http://localhost:8000/api/v1/Server and http://localhost:8000/api/v1/Configuration, that gives the Tm1 server info but doesnt give this parameter. Is there a way...
by kavitha2002
Tue May 14, 2019 12:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The TM1Web service parameter was not specified or is not one of the configured locations
Replies: 2
Views: 237

The TM1Web service parameter was not specified or is not one of the configured locations

Hi, For CAM Security, configured the url in planning.html, pmhub.html and tm1web.html but then its showing as "The TM1Web service parameter was not specified or is not one of the configured locations". In tm1s.cfg file, specified CAMPortalVariableFile=templates\ps\portal\variables_TM1.xml Am I misse...
by kavitha2002
Mon May 06, 2019 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 1109

Re: Cognos Analytics 11.0.13

Hope you are workless :lol: :lol: :lol:
by kavitha2002
Fri May 03, 2019 2:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - CAMPassport and CAMNamespace
Replies: 1
Views: 303

TM1 - CAMPassport and CAMNamespace

Hello Everyone, I would like to know the difference between the CAMPassport and CAMNamespace. In TM1 REST Api, authentication header for IntergratedSecurityMode 5 could be either 'CAMPassport ' or 'CAMNamespace'. What the difference and when situation to use either of these? Another question is: In ...
by kavitha2002
Fri May 03, 2019 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Analytics 11.0.13
Replies: 12
Views: 1109

Cognos Analytics 11.0.13

Hi Everyone,

I would like to install the CA 11.0.13. Is there any step by step
installation guide for this version or later.

Thanks in advance.
by kavitha2002
Wed Apr 17, 2019 6:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 933

Re: Tm1 - mdx query for cube cellset

In my application, I have to display the cube beforehand I will have list of dimension in order. I know row dimension and column dimension, based on that I have to show the cells readable or writable, and ofcourse if writable I should know the type of the cell. No such query returning the type of th...
by kavitha2002
Tue Apr 16, 2019 7:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 933

Re: Tm1 - mdx query for cube cellset

ok I will reach to IBM. Thanks for your time and guidance:) For cell level type, you still can use the the very original logic to check, i.e., if the value only has numbers then it is numeric, otherwise it is string or null. Sometimes values are empty, in such a case, below is the response with valu...
by kavitha2002
Mon Apr 15, 2019 6:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 933

Re: Tm1 - mdx query for cube cellset

I have attached two text file of the same query, but one with Updateable and other not. In mdx_withoutUpdateable.txt, you can find the response "RuleDerived": false' for all the cells. But in mdx_withUpdateable.txt, response is correct and expected one. For editable or non-editable, with false in "R...
by kavitha2002
Fri Apr 12, 2019 8:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 933

Re: Tm1 - mdx query for cube cellset

I dont want the entire cube cellset, based on the query I would like to filter the cellset. Herewith I have attached the screenshots for both the query. Do have another question, Is there a possibility of saying which cell is editable, non-editable and type of the cell(String, Number, Consolidated).
by kavitha2002
Thu Apr 11, 2019 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 933

Re: Tm1 - mdx query for cube cellset

I am using PA 2.0.6 version. I have tried in 2.0.4 and 2.0.2 version all gives the same response. I have tried in ARC for the rest api First request: http://localhost:8000/api/v1/ExecuteMDX?$expand=Cells for mdx query Second request: http://host:8000/api/v1/Cellsets('-first request cellset ID')?$exp...
by kavitha2002
Wed Apr 10, 2019 2:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 933

Re: Tm1 - mdx query for cube cellset

Hi @macsir, I have a quick clarification on RuleDerived, I have made MDX request on REST api first then with the help of the ID I have made another request for http://host:8000/api/v1/Cellsets('ID')?$expand=Cells($select=Ordinal,Value,RuleDerived) This above returns all RuleDerived as "True", though...
by kavitha2002
Fri Apr 05, 2019 10:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM SSO not working in Tm1web on Client machine
Replies: 2
Views: 409

Re: IBM SSO not working in Tm1web on Client machine

The problem is, SSO is working for tm1web in Server Machine but for the same user in Client Machine tm1web prompting with the login Screen, SSO not working. Anybody is having any suggestion on how to narrow down the issue to fix??