TM1 Forum

What I always do is apply "suppress zeros" in the rows. Then, I select all the elements in the rows of the suppressed view by clicking on the row header. Next, I right-click on any element and choose "keep". In the subset editor for the dimension in the rows, the subset I want to...

Security is based on }ElementSecurity cube rule. Rule is changed. YES ;) Security is based on }ElementSecurity cube rule. New element is added to the dimension YES }ElementSecurity cube does not have any rules. Particular cell is changed manually NO }ElementSecurity cube does not have any rules. Sec...

Will you need to use CubeProcessFeeders in this scenario? Unfortunately yes. I was pretty sure that next period will be triggered, because left side of the feeder statement is changing from 0 to any other value. But unfortunately it will not trigger because left side is rule derived, so it is neede...

It would not make sense doing your DB() read on the same measure that you are feeding from that's what I've always thought the left side of the feeder statement would always be non-zero cells (or previously valued which triggered a feeder but now zero). and fed cells with zero values (even if they ...

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...

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 , ...

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 ...

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...

Thanks for your replies, it's a compendium of knowledge. I chose what suits me best.

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...

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...

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) -...

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)

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...

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

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...

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...

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...