Search found 3503 matches

by lotsaram
Wed Jul 20, 2022 3:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Stargate View is Not Caching
Replies: 9
Views: 1700

Re: Stargate View is Not Caching

If VMT = 0 then the default value will be used which I believe is 5 seconds. So if the view construct takes less than 5 seconds then nothing will be cached.
by lotsaram
Thu Jul 14, 2022 9:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hide TM1 Servers in Architect/Perspectives/PAW/PAX
Replies: 4
Views: 1096

Re: Hide TM1 Servers in Architect/Perspectives/PAW/PAX

This has been discussed many times before. If the client interface is Architect/Perspectives then the only way for servers to not be visible is for them to be registered with a different admin server than the one the client is retrieving the list of instances from.
by lotsaram
Fri Jul 01, 2022 7:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DimensionElementComponentAdd does not work aliases
Replies: 1
Views: 692

Re: DimensionElementComponentAdd does not work aliases

This has always been the case. You need to use element principal names when using DimensionElementComponentAdd
by lotsaram
Mon Jun 27, 2022 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API
Replies: 3
Views: 1391

Re: TM1 Rest API

For this requirement I suggest you have a look at Arc . It does exactly what you describe (click on a chore and see everything about the chore in a separate pane). Of course it does a whole lot of other stuff as well. But the price per user is very small compared to what I imagine the cost of your t...
by lotsaram
Wed Jun 22, 2022 6:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.09 Code function negative number
Replies: 5
Views: 989

Re: PA 2.09 Code function negative number

Just replicated this and yes CodeW produces the correct result. But what the hell is CodeW? It's undocumented. Why does this exist as opposed to the Code function actually producing the correct result?
by lotsaram
Thu Jun 16, 2022 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API as a specific user
Replies: 2
Views: 1008

Re: TM1 Rest API as a specific user

Yes of course it's possible you just need to develop it.

But what you are proposing sounds like a direct contravention of licensing requirements as this would in effect be a live query of TM1 using a fixed account rather than a personal account.
by lotsaram
Thu Jun 09, 2022 1:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Java TI set up on brand new installation
Replies: 5
Views: 1279

Re: Java TI set up on brand new installation

If you are using GetJavaN to calculate IRR and other financial type iterative functions which are difficult to do natively in TM1 I suggest you have a look at TM1Py CubeCalc
by lotsaram
Thu Jun 09, 2022 8:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Java TI set up on brand new installation
Replies: 5
Views: 1279

Re: Java TI set up on brand new installation

You may also wish to consider alternative options to replace the function long term as it was nearly removed entirely, and I suspect it won't be supported in the next major release. Here's the link: Yes the in process java support is removed entirely in v12 a.k.a next gen server a.k.a planning anal...
by lotsaram
Thu Jun 02, 2022 8:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sharing Private Views and Subsets from one to another user
Replies: 1
Views: 1351

Re: Sharing Private Views and Subsets from one to another user

There's not a delay. Private objects are registered when the user logs on. All that is required is that the target user logs out and logs back in.
by lotsaram
Mon May 30, 2022 7:41 am
Forum: Useful code, tips and tricks
Topic: MDX - Intrinsic Members
Replies: 12
Views: 16049

Re: MDX - Intrinsic Members

Very useful stuff. Especially ELEMENT_TYPE and MEMBER_WEIGHT.

Can you see any advantage using MEMBER_ORDINAL to sort on versus wrapping a set expression wiuth HIERARCHIZE? Seems to me this would produce the same result.
by lotsaram
Fri May 27, 2022 8:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Maintenance in PAW or TI?
Replies: 9
Views: 1770

Re: Hierarchy Maintenance in PAW or TI?

Is there a way to export a dimension to a CSV file in Hierarchy Sort order? Yes there is. But only in the old C API based thick clients (Architect and Perspectives). Just right-click the dimension and select "export dimension". This will produce a CMA file (which is just a CSV) which is a...
by lotsaram
Wed May 25, 2022 7:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Hierarchy Maintenance in PAW or TI?
Replies: 9
Views: 1770

Re: Hierarchy Maintenance in PAW or TI?

I set the elements to String during the rebuild dimension process, so I am scratching my head on this one. As Declan has pointed out this is your problem. The data type of the field that holds the element name may be a string, but the element itself when added to the dimension should be either N fo...
by lotsaram
Wed May 11, 2022 7:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The AWS Cloud no good, very bad performance
Replies: 13
Views: 3210

Re: The AWS Cloud no good, very bad performance

PavoGa wrote: Tue May 10, 2022 3:54 pm I am not conversant on AWS instance types, but does x1e.2xlarge answer your question?
Yes that's what I meant.
by lotsaram
Tue May 10, 2022 7:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: The AWS Cloud no good, very bad performance
Replies: 13
Views: 3210

Re: The AWS Cloud no good, very bad performance

What type of AWS instance are you using?
by lotsaram
Mon May 09, 2022 7:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load time - ODBC vs text file
Replies: 3
Views: 1128

Re: Load time - ODBC vs text file

As a general rule should we expect ODBC sourced loads to be so much slower? If so, any suggestion as to why? Yes, almost always. It is stating the obvious but when the data source is ODBC rather than flat file you have 2 additional potential bottlenecks - the database itself - the ODBC driver In th...
by lotsaram
Wed Apr 27, 2022 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RETURNVIEWHANDLE using a MDX view
Replies: 5
Views: 1301

Re: RETURNVIEWHANDLE using a MDX view

MDX views are not currently supported for drill-through.
If enough people vote for this RFE then maybe it might get delivered.
https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-393
by lotsaram
Wed Apr 20, 2022 1:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect Cognos TM1 to MS Power BI
Replies: 17
Views: 4956

Re: Connect Cognos TM1 to MS Power BI

Would there be an elegant solution for transferring the roll-up structure from TM1 to Power BI? You can certainly roll your own with tm1py but have you looked at TM1Connect? If you don't want to come up with your own logic of converting TM1 hierarchies into tabular star schema then this is the clos...
by lotsaram
Wed Apr 13, 2022 8:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Learning TM1 / Planning Analytics
Replies: 10
Views: 3261

Re: Learning TM1 / Planning Analytics

This has turned into a good and valuable discussion
+1 also for what Declan said
by lotsaram
Tue Apr 12, 2022 11:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DIMIX check for element in a Hierarchy enabled dimension
Replies: 4
Views: 1405

Re: DIMIX check for element in a Hierarchy enabled dimension

my assumption is DIMIX will scan entire dimension and all hierarchies within that dimension since DIMIX is not a hierarchy aware function and it will see the entire dimension. Is my assumption wrong? Yes your assumption is wrong. The old functions see only the "same named hierarchy". They...