Search found 3513 matches
- Wed Nov 09, 2022 5:17 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX view dimension order when used as a source to a TI
- Replies: 11
- Views: 2181
Re: MDX view dimension order when used as a source to a TI
Well it was discussed at length here https://www.tm1forum.com/viewtopic.php?p=73332&sid=ba5cbd3e85205d0af84de89c32557426#p73332 But I wouldn't call that recently. Well yeah this is my APAR https://www.ibm.com/support/pages/apar/PH24729 ... and according to IBM yes this was closed as "fixed&...
- Mon Nov 07, 2022 9:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: how to make a drillthough on a virtual hierarchy element?
- Replies: 10
- Views: 1442
Re: how to make a drillthough on a virtual hierarchy element?
You can only access alternate hierarchies through MDX views not traditional views. At this time drill-through only supports traditional views as the target and not MDX views. You can vote for the RFE to support MDX views in drill-through here https://ibm-data-and-ai.ideas.ibm.com/ideas/PAOC-I-393 No...
- Thu Nov 03, 2022 1:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset Filter Elements By List of Attributes From Another Dimension
- Replies: 8
- Views: 1072
Re: Subset Filter Elements By List of Attributes From Another Dimension
Ah, I got it! I should be looping through the second dimension like such... GENERATE(FILTER(TM1FILTERBYLEVEL(TM1SUBSETALL([MMAP Versions]) , 0) , [MMAP Versions].CURRENTMEMBER.PROPERTIES("Vintage") <> "") , {STRTOMEMBER("[MMAP Vintages].[" + [MMAP Versions].CURRENTMEMB...
- Thu Nov 03, 2022 9:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Subset Filter Elements By List of Attributes From Another Dimension
- Replies: 8
- Views: 1072
Re: Subset Filter Elements By List of Attributes From Another Dimension
Should be possible. But you would need to use the Generate function.
- Tue Oct 18, 2022 10:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: rule line error runtime error :circular reference, evaluation stack
- Replies: 11
- Views: 1743
Re: rule line error runtime error :circular reference, evaluation stack
People usually pay me to fix that kind of problem. I feel like every time you have an issue, you post on this forum. Yeah dude seriously no one is going to read through that much code and provide you with a free answer (not even Declan). A circular reference is exactly what the error says it is. Fi...
- Wed Oct 12, 2022 1:06 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cases where MDX is a better alternative to cube rules
- Replies: 9
- Views: 2427
Re: Cases where MDX is a better alternative to cube rules
There are functions which MDX can deliver quite easily which TM1 rules either can't deliver unless you go back to 1st principles algebra (e.g. standard deviation) or where it simply isn't worth writing a separate rule for or for things like min/max/count/average where the relevance of the analysis i...
- Mon Oct 10, 2022 7:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cognos Disclosure Management
- Replies: 5
- Views: 1762
Re: Cognos Disclosure Management
CDM still works very well with TM1 as a data source. If you think it would be a good solution then suggest it to the client. Whether to accept the extra cost and licensing versus the benefits of the software is their decision not yours.
- Tue Aug 30, 2022 6:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Blank Rollup for Non-Admin user
- Replies: 3
- Views: 2245
Re: Blank Rollup for Non-Admin user
This looks like you have both element security on the Projects dimension where the users have at least READ access and cell security rules on the cube in question which are giving NONE access to the consolidations in the Projects dimension.
- Tue Aug 02, 2022 2:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculation inconsistency after using a DB
- Replies: 16
- Views: 2725
Re: Calculation inconsistency after using a DB
Hi Jorge, I think at some point you hgave transposed some 9s to 6s. Originally you say 4.769999999996 (but from the screenshot it is 4.7700000000999996). But then in a later post you quote 4.7666666669. This number can't be correct and if this is the case the difference (althoug as Wim says only 0.0...
- Tue Aug 02, 2022 7:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculation inconsistency after using a DB
- Replies: 16
- Views: 2725
Re: Calculation inconsistency after using a DB
This is simply a floating point issue which doesn't need to be solved, or can be easily "solved" by simply adjusting the precision of the display to 2dp. The difference between 4.77 and 4.769999999996 is at the 12th decimal place, 0.000000000004 or 4E-12. That is the difference is effectiv...
- Wed Jul 20, 2022 3:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Stargate View is Not Caching
- Replies: 9
- Views: 1791
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.
- 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: 1162
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.
- Fri Jul 01, 2022 7:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DimensionElementComponentAdd does not work aliases
- Replies: 1
- Views: 715
Re: DimensionElementComponentAdd does not work aliases
This has always been the case. You need to use element principal names when using DimensionElementComponentAdd
- Mon Jun 27, 2022 2:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Rest API
- Replies: 3
- Views: 1442
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...
- 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: 1104
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?
- 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: 1062
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.
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.
- 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: 1353
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
- 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: 1353
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...
- Thu Jun 02, 2022 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Feeder issue... Can someone help
- Replies: 9
- Views: 3723
Re: Feeder issue... Can someone help
What Tom said.
- 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: 1377
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.