Search found 144 matches

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

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

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

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

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

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

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

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

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

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

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

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??
by kavitha2002
Thu Apr 04, 2019 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 640

Re: Tm1 - mdx query for cube cellset

Yes, for updateable its return different values for the one which can be updateable and non-updateable
by kavitha2002
Thu Apr 04, 2019 8:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 640

Re: Tm1 - mdx query for cube cellset

Thanks for your reply.. It works:)

Do have another question, Is there any MDX statement to know whether the cube cells are readable or writable?

Can I use "Updateable"? but it returns "Updateable": 258 ??

?Cells($select=Ordinal, Value,RuleDerived,Updateable)
by kavitha2002
Wed Apr 03, 2019 1:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 640

Re: Tm1 - mdx query for cube cellset

Can you give me some example query on that?
by kavitha2002
Wed Apr 03, 2019 1:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM SSO not working in Tm1web on Client machine
Replies: 2
Views: 374

IBM SSO not working in Tm1web on Client machine

Hello Everyone,

One of the customer installed Tm1 with CA for Single Sign On with IntegratedSecurityMode=5, SSO works only in the Server machine for tm1web but in client machine tm1web always shows the login screen.

Any reason why?? and what could be the fix?? any help is apperciated
by kavitha2002
Fri Mar 29, 2019 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 640

Tm1 - mdx query for cube cellset

Hello everyone,

Is there a way to know that cube's cell has feeders/rules in the cellset retrieved by Mdx statement.

Usually it returns the below:
"Cells": [
{
"Ordinal": 0,
"Value": 82.10000000000001,
"FormattedValue": "82,10"
},