Search found 14 matches
- Thu Apr 25, 2024 1:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Calculated Zero Cells and Feeders
- Replies: 16
- Views: 10573
Re: Calculated Zero Cells and Feeders
Hi, I came across this post from 13 years ago and I'd like to make sure nothing has changed in this area, because my testing suggests that your conclusions are still valid. A fed cell "A" that has a value of zero will still feed other cells if it is their feeder. It doesn't matter if the z...
- Sat Oct 21, 2023 3:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Recreating Hierarchy by Attribute
- Replies: 2
- Views: 2728
Recreating Hierarchy by Attribute
Hi, I use process in which I recreate hierarchy by attribute for certain dimension. I would say it is standard: cDimName = 'Customer'; sAttrName = 'Customer Group'; sBlankSubstitute = 'No Cust Group'; sRootName = 'All Customer Groups'; sHierName = 'Customer Group'; IF ( HierarchyExists ( cDimName , ...
- Fri Dec 16, 2022 1:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Alias doesn't work in rule right hand side
- Replies: 4
- Views: 1765
Re: Alias doesn't work in rule right hand side
Thank you for clarifying that for me. I'm aware of consequences of using aliases in rules. Unfortunately the model I'm dealing with right now has them basically in every rule statement. Turned out aliases are used in functions, e.g. ElIsAnc('Dimension 1', 'Alias value', !Dimension 1) rather than in ...
- Thu Dec 15, 2022 11:12 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Alias doesn't work in rule right hand side
- Replies: 4
- Views: 1765
Alias doesn't work in rule right hand side
Hello, I've been experiencing issues with aliases in rules right hand side area. Regardless of how bad the idea of having aliases in rules is, I'd like to understand why it stopped working (I saw this apporoach in multiple models and it worked). The fact aliases work in left hand side - area definit...
- Wed Nov 02, 2022 11:59 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Disabling Consolidation Levels
- Replies: 5
- Views: 3979
Re: Disabling Consolidation Levels
Thanks for your replies, it's a compendium of knowledge. I chose what suits me best.
- Wed Aug 31, 2022 3:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Disabling Consolidation Levels
- Replies: 5
- Views: 3979
Re: Disabling Consolidation Levels
I do not want to show any values at consolidated element "Measures", because it would be misleading since children of this Element are just different measures (some are percenteges, some not etc.). I created calculation: ['Measures']=0; Unfortunately this consolidation is still visible adt...
- Wed Aug 18, 2021 1:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sorting elements within one level of hierarchy
- Replies: 2
- Views: 3014
Re: Sorting elements within one level of hierarchy
Thanks for the response, it solved my requirement. However, for whatever reason apllying it manually didn't work, DimensionSortOrder worked. Next step would be to sort it by aliases - and I found solution here: https://www.tm1forum.com/viewtopic.php?t=7122 using SwapAliasWithPrincipalName before Dim...
- Tue Aug 17, 2021 2:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Sorting elements within one level of hierarchy
- Replies: 2
- Views: 3014
Sorting elements within one level of hierarchy
Hi, I have just one hierarchy within dimension which looks more or less like this: Total (level 3) -Total Group 1 (level 2) ---A (level 1) ------x (level 0) ------y (level 0) ------z (level 0) ---B (level 1) ---C (level 1) -Total Group 2 (level 2) ---D (level 1) ------q (level 0) ------w (level 0) -...
- Tue Aug 17, 2021 2:01 pm
- Forum: General
- Topic: Public Dataset suitable for TM1
- Replies: 7
- Views: 56657
Re: Public Dataset suitable for TM1
It is not actually included in my university course. I'm doing postgraduate studies called 'Business Intelligence' and in order to get a diploma I need to create a model in any BI Tool, and since I have access to TM1 at my workplace I chose it over tools offered by the university (e.g. tableau)
- Tue Jun 15, 2021 6:37 pm
- Forum: General
- Topic: Public Dataset suitable for TM1
- Replies: 7
- Views: 56657
Public Dataset suitable for TM1
Hello, I need to create a model in TM1 to pass a course at university. I have an access to the tool, but what I need to do is to think of an imaginary client, its needs and dataset that would be provided by this client. I'm planning to create a simple planning model, where there will be few planners...
- Sun Jan 31, 2021 6:53 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - TI process timed out
- Replies: 3
- Views: 2227
Re: PAW - TI process timed out
Thanks for responses, but assuming I must stick to the excels - is there any place in configuration files where I can modify this irritating window that pops out?
edit:
i added ProxyTimeoutSeconds=3600 to /config/paw.env and it works
edit:
i added ProxyTimeoutSeconds=3600 to /config/paw.env and it works
- Fri Jan 29, 2021 3:50 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - TI process timed out
- Replies: 3
- Views: 2227
PAW - TI process timed out
Hello, I use Planning Analytics Workspace 2.0.53. There are excel applications with buttons that run TI processes. When I run any process via PAW that has execution time more than few minutes, after 2 minutes I get a messege from PAW "The request timed out. The process is still ongoing. Use the...
- Fri Dec 04, 2020 3:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding attributes only to newly created elements
- Replies: 6
- Views: 2745
Re: Adding attributes only to newly created
Or loop through all products in the Prolog tab and set the status to empty or "Inactive" with AttrPutS function. Then in the Data tab set status "Active" with AttrPutS. This way you can be sure that only products present in the file will have status "Active". ( Note: t...
- Thu Dec 03, 2020 4:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding attributes only to newly created elements
- Replies: 6
- Views: 2745
Adding attributes only to newly created elements
Hello, Please bear in mind I am a new TM1 user, so following question might look silly for you. There is a process in my model that runs daily and imports products (vProduct) from .csv file to a product dimension (V_Dimension). Then it adds attribute 'Product Status' value as 'Active' to every produ...