Search found 77 matches
- Sat Nov 11, 2023 1:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Model - Limit Overall RAM Usage
- Replies: 8
- Views: 10270
Re: Tm1 Model - Limit Overall RAM Usage
So there actually seems to be a way though not official/documented. If you add PooledMemoryMaxLimit=<threshold in MB> to your tm1s.cfg, that instance will basically just crash when the threshold is reached. Not ideal normally but may be what you need in your specific case. My TM1server.log shows th...
- Wed Jun 26, 2019 5:24 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Active Form creating hundred of blank columns?
- Replies: 12
- Views: 7752
Re: Active Form creating hundred of blank columns?
Sorry for bringing this old thread back from the dead. 2 years later, looks like the issue still exists, with the number of columns expanded to 1000 upon activeforms rebuild. Nothing we can do there. In terms of the file size though, I have found a way to minimise the file size . Because that's my m...
- Wed Mar 06, 2019 4:56 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unable to move Active forms from one server to another server manually
- Replies: 8
- Views: 4401
Re: Unable to move Active forms from one server to another server manually
Is the destination instance name same as source instance name? If not, you may need to update the excel file (in }externals) with the correct instance name.
- Thu Feb 21, 2019 6:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Temp View difference to Perm Views
- Replies: 16
- Views: 8002
Re: Temp View difference to Perm Views
What I would do is, attached a random number (10 digits) to the view/subset name every time a temporary object is used. And I've removed the check and remove existing view/subsets (the chance of the same object name is used in the same process chain is pretty low). Since they are temporary objects, ...
- Wed Feb 20, 2019 9:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1Web - Duplicate tabs being created on Websheet
- Replies: 1
- Views: 1440
Re: TM1Web - Duplicate tabs being created on Websheet
Just to clarify on a few things: 1. What does the button do? 2. When a websheet is opened, does it open in tm1web? 3. Does it store a counter, or update a subset as part of a process that action button triggers? 4. Does the original websheet contains the 5 worksheets? or does it get generated as par...
- Wed Feb 20, 2019 9:09 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX StrToMember Error
- Replies: 13
- Views: 10541
Re: MDX StrToMember Error
The issue here is not with the MDX. Checking the MDX, it looks ok. The issue is here, there may be cases where one or more site codes stored (in the Primary Site attribute) is invalid site. Hence the MDX errored out. If you are confident that all the non-blanks are valid site codes, then there is a ...
- Tue Dec 11, 2018 10:47 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Notepad++ 7.6 for TM1 process and Rules
- Replies: 17
- Views: 9774
Re: Notepad++ 7.6 for TM1 process and Rules
Hello, 1) How do I use/setup Notepad++ 7.6 to Edit and Save TI processes. I am not sure how to set up Notepad++ 7.6 for TM1 10.2.2. Its painful indenting TI with space bars in TM1 native editor. 2) Does IBM PA (latest version of TM1 have better editor for TI and Rules ?) Thanks, Rtel If your main c...
- Thu Oct 04, 2018 7:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process - Meta Data Behavior
- Replies: 2
- Views: 1958
Re: TI Process - Meta Data Behavior
If you want to stick with csv, then I would suggest getting the source file tidied up, as I believe the csv file is not correctly created. In the scenario you've shown, if correctly formatted in csv, it should be "126", "Lance, Christopher" ,"Christopher","Lance&q...
- Fri Sep 28, 2018 12:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: [Postman] Unexpected token : yes but where ?!
- Replies: 9
- Views: 6608
Re: [Postman] Unexpected token : yes but where ?!
I am not very familiar with Postman, but should your JSON payload not be in the body? Pre-request script should be Javascript code. Yes, in this case, the MDX query statement should be part of "Body". Is TM1 so difficult for newbies ? I have worked for 15 years on webapps and Java develop...
- Mon Sep 24, 2018 6:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX based on actual element compared to cube value
- Replies: 4
- Views: 3644
- Mon Sep 24, 2018 6:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Save the rights of a Contributor Application via TI
- Replies: 12
- Views: 8084
Re: Save the rights of a Contributor Application via TI
Sorry if my original post was a bit brief and/or confusing. Just want to clarify a couple of things: TI: }tp_deploy_create_shadow_dimension - This TI replicates your ApprovalDim to a shadow dimension, eg. }tp_task}....... This TI doesn't have anything to do with security. TI: }tp_rights_update_RDCLS...
- Wed Sep 19, 2018 12:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Save the rights of a Contributor Application via TI
- Replies: 12
- Views: 8084
Re: Save the rights of a Contributor Application via TI
The security cubes I've mentioned in my post behaves the same way as other security cubes in TM1. So, you can apply rules to those cube if you want. Just need to make sure you trigger a security refresh after update of approval dim. Because ruled security doesn't take effect straightaway, it is diff...
- Wed Sep 19, 2018 12:07 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Question
- Replies: 2
- Views: 2324
Re: MDX Question
In your MDX example, TM1FILTERBYPATTERN is not doing anything, since you don't have a wildcard (*) in your criteria. If what you wanted is just to specify, months (M01 to M12), then bring through all the children/leaf elements, then this may help: {TM1FILTERBYLEVEL( {DESCENDANTS( {[Period].[M01],[Pe...
- Mon Sep 17, 2018 7:49 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Question of the day
- Replies: 9
- Views: 5005
Re: TM1 Question of the day
Someone who has the time to play around with it ? :D 5 minutes can always be donated :lol: A TI process with a dynamic level 0 subset as the data source, and the Metadata inserting an N-level element in the dimension, will have the Data tab including this new element. Anyone who can test in a diffe...
- Sun Sep 16, 2018 11:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Question of the day
- Replies: 9
- Views: 5005
Re: TM1 Question of the day
That's really interesting. I wondered if this is a version specific functionality.
- Thu Sep 13, 2018 11:48 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Save the rights of a Contributor Application via TI
- Replies: 12
- Views: 8084
Re: Save the rights of a Contributor Application via TI
Yes, you can refresh/save rights of a Contributor Application via TI. I've done that for a few contributor apps for multiple clients. 1. You need to find out which apps (assuming you have multiple apps that use different approval dim/subsets). You can get all the info via "}tp_applications"...
- Thu Aug 30, 2018 3:37 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Creating a }Picklist cube in a TI process
- Replies: 3
- Views: 3253
Re: Creating a }Picklist cube in a TI process
Have you tried unloading picklist target cube, and then reload the target cube (create a one cell cube view and access it).
Suspect there is a cube dependency on picklist cubes. Destroying the picklist cube may have removed this dependency.
Suspect there is a cube dependency on picklist cubes. Destroying the picklist cube may have removed this dependency.
- Wed Aug 29, 2018 12:17 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Reports against TM1 - Question
- Replies: 4
- Views: 2850
Re: Reports against TM1 - Question
This is a fairly common scenario for a TM1 reporting cube, whether is reported from BI or other reporting tools such as Perspectives. Here is what I would do: All calculations is done in TM1 cube. Introduce another Account Attribute [1, -1] in TM1 that refers to the Revenue/Expenses attribute. This ...
- Wed Aug 22, 2018 5:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Best Cube Design for a Financial Model
- Replies: 10
- Views: 18711
Re: Best Cube Design for a Financial Model
If user usability outweighs performance, then I would be more incline to go with multiple cubes. DBRW formulas on perspective would be shorter, since you don't have to select those non-relevant dimensions for a cube. Users can still reference multiple cubes on the same sheet, (but it is more difficu...
- Wed Aug 22, 2018 5:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Best Cube Design for a Financial Model
- Replies: 10
- Views: 18711
Re: Best Cube Design for a Financial Model
I guess you would have evaluate the pros and cons of each method: Separate cube pros: less sparse cubes easier to rule and feed easier for user consumption (fewer dimensions to select from) cons: may require more TIs for data load or export may introduce reconciliation issues (as one GL combining P&...