Search found 594 matches

by macsir
Wed Apr 24, 2019 12:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to calculate up to Millisecond
Replies: 9
Views: 4157

Re: How to calculate up to Millisecond

Just want to share, now it is possible in Planning Analytics with function HierarchyTimeLastUpdated. It is not perfect as you have to create a dummy hierarchy to get millisecond. It would be nice to have a native function with millisecond format. HierarchyTimeLastUpdated This function indicates when...
by macsir
Tue Apr 23, 2019 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bedrock 4 for IBM Planning Analytics is available
Replies: 10
Views: 252

Re: Bedrock 4 for IBM Planning Analytics is available

Thanks for great work! Will check that out later. :D
by macsir
Tue Apr 16, 2019 9:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

I am planning to implement in the code, based on the last dimension. condition 1) If the last dim is in Title, depends on the type of the element chosen, will decide entire cube hold the string value or numeric value. condition 2) LastDim is in row, then row level evaluation should be done conditio...
by macsir
Mon Apr 15, 2019 9:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

Can't figure out why and couldn't reproduce your errors. I always got consistent results regardless of using updateable or not. It might be a bug in some versions. Have you contacted IBM about this? For cell level type, you still can use the the very original logic to check, i.e., if the value only ...
by macsir
Mon Apr 15, 2019 1:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

Hi, I still couldn't see your original problem from your snapshots? return response "Rulederived" all as true. When I give "Updateable" then response is correct in all the versions. Is there something wrong am doing here? which version are you using? But for your next question, Do have another quest...
by macsir
Sun Apr 14, 2019 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API - using Cellsets return Error 505 HTTP Version Not Supported
Replies: 1
Views: 85

Re: REST API - using Cellsets return Error 505 HTTP Version Not Supported

Google this error 505 HTTP Version Not Supported should give you some ideas but off the top of my head, you probably should use latest httpclienthttp://hc.apache.org/httpcomponents-client-ga/ component with your Java code rather than in-built one. That one is out-of-date.
by macsir
Thu Apr 11, 2019 8:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

I am using 2.0.6 too but with Postman to check rest api.
The first query shouldn't use expand operator and it is purely for executing MDX to get cellset id.

Code: Select all

http://localhost:8000/api/v1/ExecuteMDX
and then use this id in your second query.
If you can post some snapshots, that would be good.
by macsir
Wed Apr 10, 2019 8:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

Not sure, I always use the first query and got right answers. Which version of PAL are your using? Maybe it is a bug?
by macsir
Mon Apr 08, 2019 8:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Subset Disappears?
Replies: 3
Views: 124

Re: TM1 Subset Disappears?

I often use alt+space keys to show the little "move" menu, and then use arrow keys to bring it back to the center of the screen. :lol:
by macsir
Thu Apr 04, 2019 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

You probably can but can't guarantee if IBM change this code further or not.
I will stick to rulederived key to determine if updateable or not.
by macsir
Wed Apr 03, 2019 8:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

Code: Select all

https://SERVERNAME:PORTNUMBER/api/v1/Cellsets('YOURCELLSETID')?$expand=Cells($select=Ordinal, Value,RuleDerived)
Get your cellset id from your MDX query and replace it here.
And then you will get result like this.
Capture.PNG
Capture.PNG (18.51 KiB) Viewed 379 times
by macsir
Mon Apr 01, 2019 8:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

To your question, MDX can't do that. Only the above method can do it.
by macsir
Mon Apr 01, 2019 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 - mdx query for cube cellset
Replies: 20
Views: 541

Re: Tm1 - mdx query for cube cellset

?$expand=Cells($select=Ordinal, Value, RuleDerived)

The RuleDerived field will give you boolean value based on rule-based or not.
by macsir
Mon Apr 01, 2019 5:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to schedule chore job monthly
Replies: 8
Views: 1684

Re: How to schedule chore job monthly

In newer TM1 version, tm1runti command can execute chores now.
https://www-01.ibm.com/support/docview. ... wg27048305
by macsir
Fri Mar 29, 2019 5:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest api - MDX query for zero suppression
Replies: 5
Views: 210

Re: TM1 Rest api - MDX query for zero suppression

I don't quite get your point of getting only the row elements which is non-zero???
by macsir
Mon Mar 25, 2019 8:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest api - MDX query for zero suppression
Replies: 5
Views: 210

Re: TM1 Rest api - MDX query for zero suppression

SELECT
NON EMPTY {[DimCP_Population].[Dr Key].[Dr Key]}
ON rows,
{
[Measures].[PatientCnt] ,[Measures].[TotalPatientCnt]
,[Measures].[PrevalencePercent]

}
ON columns
FROM [StrategyCompanionDWCube]
by macsir
Thu Mar 07, 2019 8:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX REST API
Replies: 5
Views: 337

Re: PAX REST API

Hi,
Good to know. Yes, I suspect that you can't use double quotes to escape double quotes in json string. I didn't test but reading from google, you could try to use chr(34) to replace it.
e.g,
String = "This is the Test only." & chr(34) & "double ok" & chr(34) & "."
by macsir
Mon Mar 04, 2019 3:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw installation: issue to open the admintool
Replies: 3
Views: 438

Re: Paw installation: issue to open the admintool

turn off all your proxy settings in IE
by macsir
Thu Feb 28, 2019 12:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX REST API
Replies: 5
Views: 337

Re: PAX REST API

Hi Gurus! Struggling a bit to get the PAX REST API to work. Below is the syntax for the GET request, but I can't find any references (in the documentation, or on the web) to JSONObjectWrapper or JSONParser . Where can I find these, do you know? Public Function oDataGet(path As String) As JSONObject...