Search found 3499 matches
- Mon Mar 04, 2024 12:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: }Drill process return handle
- Replies: 3
- Views: 173
Re: }Drill process return handle
I wasn't aware of this. Will have to look up ReturnCSVTableHandle and see if I can get it to work. The "classic" way of doing this is to use a text to ODBC driver and set up a public ODBC DSN pointed to a specific folder then have a TI process write a CSV to the folder which can then be di...
- Mon Mar 04, 2024 11:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Concentrating two dimensions elements together to form a unique identifier
- Replies: 4
- Views: 243
Re: Concentrating two dimensions elements together to form a unique identifier
It might help if you can explain why you need to do this. Do you need to flatten data and export using the key to another system?
- Thu Feb 29, 2024 12:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewConstruct on XBV view
- Replies: 1
- Views: 187
Re: ViewConstruct on XBV view
I assume the version in your profile isn't up to date? What version are you on as I am quite sure this has been solved for quite some time.
- Wed Feb 28, 2024 6:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: RAM and PVU licensing
- Replies: 6
- Views: 344
Re: RAM and PVU licensing
+100 for George’s 1st post.
- Wed Feb 14, 2024 6:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Subset TI Data Source Alias
- Replies: 4
- Views: 726
Re: Dimension Subset TI Data Source Alias
Is it a limitation that aliases do not show when the data source is Dimension Subset? Not a limitation, a feature! ;) It doesn't matter what alias is assigned to subsets used in datasources (views and subsets). From a data source variable perspective TI will always read the principal name. As sugge...
- Tue Feb 06, 2024 3:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA on IBM Cloud - Uploading users
- Replies: 4
- Views: 1044
Re: PA on IBM Cloud - Uploading users
I'm not convinced that being able to create users but not have the user accounts be properly active and able to be used (that is log onto the system with the account) is a really useful feature.
- Fri Jan 05, 2024 9:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rule Dependency Query
- Replies: 2
- Views: 703
Re: Rule Dependency Query
If the rule sheet for both cubes reference the attributes of the same dimension via a lookup, something like a prior period lookup then does this create a dependency between my two cubes? No. in Cube A ['Measure'] = DB ('Cube A' , ......, DB('}ElementAttributes_Period' , !Period, 'Prior') ,....); i...
- Mon Dec 11, 2023 8:42 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ViewZeroOut doesn't work
- Replies: 11
- Views: 14501
Re: ViewZeroOut doesn't work
Why are you using a 3 year old version?EP_explorer wrote: ↑Sat Dec 09, 2023 11:28 amIt seems you are rightburnstripe wrote: ↑Sat Dec 09, 2023 10:38 am What version is this on
https://www.ibm.com/support/pages/flash ... hout-error
Version is 9.0.4
Thank you
- 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: 10311
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: 8760
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: 16442
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: 6529
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: 8839
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: 8839
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: 5637
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: 3660
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: 2021
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: 664
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: 18920
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: 6957
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?