Search found 3508 matches
- Tue May 09, 2023 7:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
- Replies: 7
- Views: 2217
Re: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
Noticed this parameter in the TM1S.CFG - may be worthwhile checking/reviewing. Default is True though. SaveFeedersOnRuleAttach When set to False, postpones writing to feeder files until SaveDataAll and CubeDataSave are called, instead of updating the files right after rules are changed and feeders ...
- Wed Mar 29, 2023 7:35 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Displaying 'Value' column in an MDXView
- Replies: 3
- Views: 648
Re: Displaying 'Value' column in an MDXView
I would say it depends on the GUI. If it is architect or perspectives then no, it aint gonna happen since this uses the old API and has no concept of either hierarchies or MDX views. If it's a modern IDE like Arc or Workspace then this shouldn't be a problem.
- Tue Mar 28, 2023 7:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Displaying 'Value' column in an MDXView
- Replies: 3
- Views: 648
Re: Displaying 'Value' column in an MDXView
I guess you are talking about the preview window for TurboIntegrator?
- Thu Mar 23, 2023 11:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: what is difference between TM1 9.1 and TM1 11.6
- Replies: 6
- Views: 1075
Re: what is difference between TM1 9.1 and TM1 11.6
You do realize that TM1 9.1 came out in 2007?
- Thu Mar 16, 2023 11:43 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.Lock.Exception Throwing IXConflict on object }DimensionProperties
- Replies: 3
- Views: 1003
Re: TM1.Lock.Exception Throwing IXConflict on object }DimensionProperties
It might be related to MUN generation or the initial lock the first time a dimension is queried. After startup try looping through all dimensions and just doing a sEle = DIMIX(sDim, 1) within the loop (nothing else) then after the loop run RefreshMdxHierarchy. Doing that before the load process may ...
- Mon Mar 13, 2023 2:57 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1 how to copy private view from one user to another user?
- Replies: 5
- Views: 1144
Re: tm1 how to copy private view from one user to another user?
There is also the TI function PublishView. You could just let the user run the bedrock view publish process
- Thu Mar 02, 2023 4:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules with virtual hierarchies
- Replies: 10
- Views: 2021
Re: Rules with virtual hierarchies
Excellent. Thanks for the update! Glad that you got it to work.
The real code rather than the pseudo code makes it much easier to see.
The real code rather than the pseudo code makes it much easier to see.
- Thu Mar 02, 2023 4:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewSubsetAssign - what am I doing wrong?
- Replies: 15
- Views: 2636
Re: ViewSubsetAssign - what am I doing wrong?
Good points, @Maren - but I was following the conventions set out by our software developer consultant (who we are no longer getting help from) and they haven't thrown up issues before. With all due respect to your former developer. If their advice and "best practice" was to create perman...
- Thu Mar 02, 2023 8:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need Help with a feeder
- Replies: 9
- Views: 1402
Re: Need Help with a feeder
As David Usherwood is now enjoying retirement I can only repeat the point he has made countless times on this forum; the purpose of feeding is for consolidation ergo if a rule calculated measure doesn't need to consolidate then don't feed it. Rates are such a measure, you shouldn't feed rates.
- Tue Feb 28, 2023 11:51 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules with virtual hierarchies
- Replies: 10
- Views: 2021
Re: Rules with virtual hierarchies
RFAG #5 Post the actual code! https://www.tm1forum.com/viewtopic.php?t=1037 Show the actual rule that isn't working, not just a snippet. Show the WHOLE rule, including the left hand side. Show the structure of BOTH cubes. If you want help, put in the required minimum effort that people can actually ...
- Tue Feb 28, 2023 8:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rules with virtual hierarchies
- Replies: 10
- Views: 2021
Re: Rules with virtual hierarchies
Did you create a hierarchy? Becasue from the picture you included it doesn't really look like it. It isn't enough to have an attribute in Product dimension matching an element name in Product_Dashboard dimension - you must have a consolidation which exactly matches the name.
- Mon Feb 27, 2023 8:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating TI Process by running a TI Process
- Replies: 4
- Views: 1105
Re: Creating TI Process by running a TI Process
I don't really have anything to add to Wim's already excellent post except to emphasize that creating a new process each time you want to load data from one cube to another seems like a very odd thing to do. Much better to simply have a generic process to do this job.
- Wed Feb 22, 2023 8:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Excel Calc Issues
- Replies: 3
- Views: 840
Re: TM1 Excel Calc Issues
When I connect to TM1 via excel, I am getting a RECALC error when I try to refresh my DBRW formulas. I have the add-ins, have tried DBR and DBSW formulas but it still is not working. Any ideas? Thank you If you are using Perspectives this is normally caused by linking a DBRW formula to another DBRW...
- Thu Feb 09, 2023 5:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy security update require a call to SecurityRefresh Function
- Replies: 7
- Views: 1257
Re: Hierarchy security update require a call to SecurityRefresh Function
I tried the CellPutS but the trick didnt work. :-( Maybe also try CellPutS to the element security cube. What George said rang a bell and I think I can recall needing to do this. (Why I don't know becasue AFAIK ElementSecurityPut should alone be adequate). HierarchyElementSecurityPut(sElSecurity, p...
- Thu Feb 09, 2023 12:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hierarchy security update require a call to SecurityRefresh Function
- Replies: 7
- Views: 1257
Re: Hierarchy security update require a call to SecurityRefresh Function
I agree this sounds strange. If element security cubes don't contain rules then the ElementSecurityPut function should be sufficient to update security without needing a SecurityRefresh.
- Mon Feb 06, 2023 7:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Why transaction logs are only available in Architect ?
- Replies: 3
- Views: 1183
Re: Why transaction logs are only available in Architect ?
At least as far as Arc goes you can raise a feature request
- Fri Feb 03, 2023 8:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Why transaction logs are only available in Architect ?
- Replies: 3
- Views: 1183
Re: Why transaction logs are only available in Architect ?
If you want to expose transaction logs to non-admin users then you have no alternative but to do the work yourself and load the transaction logs into another database which users have access rights to becasue non-admin users don't have access to transaction logs via rest API (or process error logs f...
- Wed Jan 25, 2023 8:36 am
- Forum: Enhancements
- Topic: Python Integration PA on Cloud
- Replies: 4
- Views: 9121
Re: Python Integration PA on Cloud
Where is the like button?
- Fri Jan 20, 2023 11:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: quote issue on a MDX TurboIntegrator function
- Replies: 7
- Views: 2869
Re: quote issue on a MDX TurboIntegrator function
+1 I would also always use Expand for such cases. It's just easier.
- Mon Jan 16, 2023 1:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Uploading data from source cube to target cube with the source cube bigger in dimensionality
- Replies: 3
- Views: 838
Re: Uploading data from source cube to target cube with the source cube bigger in dimensionality
There is a bedrock process which can do this task without writing any code. }bedrock.cube.data.copy.intercube