Search found 3504 matches
- Wed Sep 20, 2023 4:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock delimiter
- Replies: 5
- Views: 3722
Re: Bedrock delimiter
I think if you just comment out lines 90-92 on the prolog then this should suffice. If( pThousandSeparator @= '' ); pThousandSeparator = ','; EndIf; You can raise a ER at https://github.com/cubewise-code/bedrock/issues The check for empty paramater and inserting a default makes sense. To achieve non...
- Mon Sep 18, 2023 7:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Export }-Cubes with Bedrock
- Replies: 3
- Views: 2063
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: 713
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: 20571
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: 7281
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: 1111
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: 1946
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: 808
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: 1064
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: 819
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: 9834
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: 662697
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: 1832
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: 1832
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: 1059
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: 2205
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: 2205
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: 637
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: 637
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: 996
Re: what is difference between TM1 9.1 and TM1 11.6
You do realize that TM1 9.1 came out in 2007?