Search found 3503 matches
- Mon Sep 18, 2023 7:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export }-Cubes with Bedrock
- Replies: 3
- Views: 2048
Re: Export }-Cubes with Bedrock
The process }bedrock.hier.export will include all attribute names and type in the header, before the body which contains the hierarchy structure and attribute values. So if you want the attribute values it will be in that file. If you aren't interested in the structure you could always just ignore a...
- Mon Sep 11, 2023 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help on MDX
- Replies: 4
- Views: 697
Re: Need help on MDX
CURRENTMEMBER.PROPERTIES work fine but CURRENTMEMBER.PROPERTIES().PROPERTIES() doesn't work. And why on earth would you expect this to work? CurrentMember is obviously a member CurrentMember.Properties("propertyName") returns a string You cannot pass a string into an expression which requ...
- Fri Sep 08, 2023 11:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock And Github vs Other Options
- Replies: 22
- Views: 19754
Re: Bedrock And Github vs Other Options
The key point, THE. KEY. POINT. is that if Bedrock was still maintained entirely in house by Cubewise such that each release was an unvarying quantity that could be comprehensively tested, there would be a degree of certainty about the functionality for that version of it . As it was released into ...
- Wed Sep 06, 2023 11:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX which takes Value from Cube
- Replies: 12
- Views: 7042
Re: MDX which takes Value from Cube
Why would a new user with no post history necromance a thread from 6 years ago just to troll someone? Very weird stuff. Maybe it's a chatbot/trollbot?
- Wed Sep 06, 2023 11:03 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Any tm1web log setting to get user access websheet info
- Replies: 6
- Views: 1094
Re: Any tm1web log setting to get user access websheet info
If you are lucky enough to have Pulse, and it is properly configured then Pulse captures this information and it can be reported.
- Wed Aug 30, 2023 4:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Mirantis mandatory for PAW
- Replies: 10
- Views: 1888
Re: Mirantis mandatory for PAW
Long term roadmap?WilliamSmith wrote: ↑Wed Aug 30, 2023 12:45 pm Are you saying the long term road map is to migrate PAW away from running on Windows server?
- Fri Aug 25, 2023 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turn off consolidated drilling?
- Replies: 4
- Views: 786
Re: Turn off consolidated drilling?
Using element security is an interesting idea, I'll have to try it out. I am trying to display the top and bottom levels of a three tier hierarchy so I would just need to make sure that hiding the middle parents didn't block access to the leaves altogether. Whether this works using element security...
- Fri Aug 11, 2023 12:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Domain-Administrator for TM1?
- Replies: 1
- Views: 1062
Re: Domain-Administrator for TM1?
The main issue is access to network resources. The account running the TM1 service doesn't need to be domain admin, but the account needs to have sufficient rights to do what it needs to do, e.g. read from and write to network shared folders which are located on another machine on the network, use t...
- 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: 817
Re: TM1-Web Usage of Alias for Elements
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.
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.
- Fri Jul 07, 2023 7:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify All References to Cube
- Replies: 7
- Views: 9807
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: 661662
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: 1788
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: 1788
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: 1049
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: 2193
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: 2193
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: 630
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: 630
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: 985
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: 920
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 ...