Search found 3511 matches
- Mon Dec 04, 2023 12:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RAM usage exploding with CubeUnload and ViewConstruct
- Replies: 5
- Views: 11773
Re: RAM usage exploding with CubeUnload and ViewConstruct
Why don't you export data to CSV on production and load the CSV in Test/Dev? It seems to me that this would be a better solution. - more scope for automation since at the end of the export the process to load the file could be chained by tm1runti or rest call - presumably the whole history doesn't c...
- Wed Nov 15, 2023 4:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Performance drop between 2.0.9.1 and 2.0.9.15
- Replies: 7
- Views: 10062
Re: Performance drop between 2.0.9.1 and 2.0.9.15
I can only agree that there is absolutely no point in testing an upgrade to 2.0.9.15 as this is already a year old. Go with the latest release: 1. as you will get better support if needed from IBM or your BP rather than being helpfully asked to upgrade 2. if you are working for a organization with g...
- Wed Nov 15, 2023 8:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: REST API Dimension Clone
- Replies: 16
- Views: 18763
Re: REST API Dimension Clone
There's no single endpoint to duplicate a dimension. You can get the elements and structure, but you then need separate calls to create the attributes and then copy the data.
- Tue Nov 14, 2023 9:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to ViewZeroOut }bedrock.cube.view.create
- Replies: 3
- Views: 7540
Re: Unable to ViewZeroOut }bedrock.cube.view.create
Declan's answer is correct. You need to use ExecuteProcess not RunProcess. 1. So that all processes will be part of the same commit transaction, which makes temp objects accessible to other processes whihc are part of the same transaction. 2. So that the execution is serial and the calling process w...
- Tue Nov 14, 2023 9:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10336
Re: Tm1 Model - Limit Overall RAM Usage
Not being able to shutdown the instance would seem to be a fatal flaw in using this! What would happen to a long-running TI process that was processing rule calculated cells and consequently growing the calculation cache? If memory limit exceeded does the TI process just error? Or does it do somethi...
- Wed Nov 08, 2023 6:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10336
Re: Tm1 Model - Limit Overall RAM Usage
You can't.
TM1 will eat up all available memory until it runs out.
And then it is paging, hanging and crashing time.
TM1 will eat up all available memory until it runs out.
And then it is paging, hanging and crashing time.
- Thu Oct 12, 2023 5:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Dependency with DB Function - How Smart?
- Replies: 3
- Views: 6534
Re: Cube Dependency with DB Function - How Smart?
We have an issue at the moment when updating a meta-data cube that is relied on heavily throughout our larger data cubes that it seems to be causing a constant recalc everytime a view is pulled once it's updated. The odd thing is, the measure that is being updated I do not believe is in ANY rules. ...
- Wed Sep 20, 2023 4:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Bedrock delimiter
- Replies: 5
- Views: 3781
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: 2088
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: 753
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: 21027
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: 7409
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: 1141
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: 2000
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: 842
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: 1076
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: 828
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: 9861
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: 666060
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: 1872
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...