Summarizing data
Summarizing data
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.
-
Alan Kirk
- Site Admin
- Posts: 6667
- Joined: Sun May 11, 2008 2:30 am
- OLAP Product: TM1
- Version: PA2.0.9.18 Classic NO PAW!
- Excel Version: 2013 and Office 365
- Location: Sydney, Australia
- Contact:
Re: Summarizing data
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.)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.
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.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
Re: Summarizing data
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!