TM1 Forum

Let's say you want to summarize data at product level into product type. You could have a two level product dimension that rolls up into product type. But what if you also need to enter data at the product type level. What would be the best practice in achieving this in TM1? I understand that you could have a second dimension where the product type is a leaf element and have a detailed cube with the product dimension and a summary cube with the product type dimension. What are the available options for moving data between the detailed and summary cubes using rules? Thanks.

JJ2 wrote:Let's say you want to summarize data at product level into product type. You could have a two level product dimension that rolls up into product type. But what if you also need to enter data at the product type level. What would be the best practice in achieving this in TM1? I understand that you could have a second dimension where the product type is a leaf element and have a detailed cube with the product dimension and a summary cube with the product type dimension. What are the available options for moving data between the detailed and summary cubes using rules? Thanks.

I don't think that there is a single "best practice" but before we go on... what type of data is needed at product type level? If it's string data, you can actually enter that at consolidation level as things stand. (Assuming that you have a string element in your last dimension.)

If it's numeric data, one option to consider (which would save you the complexity of maintaining multiple cubes, rules or TIs) would be to add an element to each type consolidation which is intended to store only data that relates to the product type rather than to any individual product.

Hi Alan, thanks for the reply. The data is numeric (not string). Your idea is great and I will try it. But just out of curiosity, do you know what the different alternatives are to summarizing data generally in TM1. I'm new to TM1 and am trying to get a handle on it. Thank you!