I think there's nothing to do here except user education.
When the users make an alternate selection by dimension for the relative spread it will launch the subset editor, and there they get the chance to apply an alias rather than the element technical names.
Search found 3515 matches
- Fri Jul 28, 2023 11:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1-Web Usage of Alias for Elements
- Replies: 2
- Views: 830
- Fri Jul 07, 2023 7:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify All References to Cube
- Replies: 7
- Views: 9884
Re: Identify All References to Cube
Or commercial tools such as Qubedocs. Note: I have no advantage of or links with, Qubedocs. Or roll your own solution by using a TI process to read the PRO and RUX files, etc. Or develop a solution using the TM1 REST API. tm1py has some support for this task at hand. Or commercial tools such as Pul...
- Thu Jun 29, 2023 2:01 pm
- Forum: Jedox
- Topic: Any Quality Open Source Olap ??
- Replies: 19
- Views: 667007
Re: Any Quality Open Source Olap ??
Well there's tinyolap https://tinyolap.com/
But this is single user in-process. Although the project bio talks about xP&A use cases I can't think of any real planning use case which is viable without multi-user and a security model.
But this is single user in-process. Although the project bio talks about xP&A use cases I can't think of any real planning use case which is viable without multi-user and a security model.
- Thu Jun 29, 2023 1:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting Architect Users into PAW
- Replies: 6
- Views: 1904
Re: Getting Architect Users into PAW
Wow, can you please share more details? can't seem to find anything like it in release notes. I thought it's the other way around, there's now a way to sync PaW users to TM1 database now, like this https://www.ibm.com/docs/en/planning-analytics/2.0.0?topic=mugpadco-import-users-groups-from-planning...
- Fri Jun 02, 2023 3:10 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Getting Architect Users into PAW
- Replies: 6
- Views: 1904
Re: Getting Architect Users into PAW
Well until very recently you would have needed to set them all up again as users and security in Workspace are independent of the TM1 server. However, as of either PAW 86 or 87 users and groups from TM1 can now be used as a source for PAW. So as long as you go with the latest version you will be fin...
- Wed May 24, 2023 7:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remove duplicate elements in MDX subset build
- Replies: 6
- Views: 1138
Re: Remove duplicate elements in MDX subset build
For a relatively small subset just use MDX with the + (union) operator between the elements. This will automatically do a distinct. I think this would be the most simple. SubsetMDXSet(dDimName, sSubName, Expand('{{[%dDimName%].[Planning]}+{[%dDimName%].[Budget]}+{[%dDimName%].[%PriorMonthForecast%]}...
- Tue May 09, 2023 7:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
- Replies: 7
- Views: 2244
Re: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
We believe this is working differently to how it used to and we think this has appeared in either .15 or .16. We have many cubes with inter cube feeders, conditional feeders etc. On server startup the feeder process time for a particular cube is approximately 30 minutes. This has not changed with t...
- 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: 2244
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: 660
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: 660
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: 1103
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: 1044
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: 1200
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: 2044
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: 2664
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: 1433
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: 2044
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: 2044
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: 1133
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: 871
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...