TM1 Forum

Really no ideas / recommendations how to handle this in TM1?

Below link is about how other tools handly those business needs. Furthermore it describes my issues more detailed and it gives a good overview about the subject in general.
http://www.sqlbi.com/articles/many2many/

Hi, I try to give you some additional information. I attached a sample model, some sample data and desirable results. Hopefully it illustrate my issue a bit more. As long as a measure (e.g. downtime) rely on one incident_id and one incident_id can affect more services i have a summarisability proble...

Hi, is it possible to imagine a many to many relationship in TM1? For example, i have a incident fact table and a time and status dimension table. The relationship between incidents, time and status allows storing the state of every incident and for every month. And an incident can have several stat...

Thanks Lance! The hint with the if Statement solved the issue for me. I did it that way: ['Measure A'] = C: IF( DTYPE('DimA',!DimA) @= 'N' ,ConsolidatedAVg(...) ,STET ); Additionaly i had to change the dimension order in the cube, to get the right sum in the C nodes of both dimension ... Helpful for...

Thx for a reply! I changed the rule to ['Measure A'] = C:ConsolidatedAvg(0, '', !DimYear, 'cons_elem', 'Measure A'); But it changed nothing at the result. I tried also to work with the STET function. But didn't get it. YEs, i tried it with value 1. But that didn't work neither. Probably it was not c...

Hello, i have a problem with the consolidatedavg function and hopefully anyone could help me to deal with it. I have a sample cube with three dimensions. I attached a picture to demonstrate my problem. 1. Measure A should be consolidated as average along the time dimension, but shoul be consolidated...