TM1 Forum

Hello Guys. Disclaimer: Pretty new in TM1.

Lets assume I have data regarding sizes and areas of a building, in this hierarchy

Country
Store
Store Sub-areas

For the Store sub- areas, I have created a 6 different subsets for aggregations. Using weights.

So I guess it would look something like:
Country
Store
Subset X
Store Sub Areas

Now, I would like to combine this with financial data. To e.g calculate "profit per square meter".

The financial data I have is on the aggregated "Subset X" level.
1. Is it possible to combine the data on that level (which is not leaf level i guess)?
- If YES, is it possible to disable drill down for a subset? (Financial data does not exist on Store Sub Area Level), any "distributed" data wouldn't make sense.
- If NO, then do I need to rethink my cube and actually aggregate the data using rules in the TI-process , directly to the same TI-process? Or perhaps, create a new cube, importing data from this, and making the leaf-level the same?

Would appreciate any input, thanks in advance!

Hi,
When you say subset I think you mean sub-consolidation? i.e. an extra consolidation you've added to the dimension between Store and Store Sub-Areas.

You cannot load data to a consolidation so if you want the financial data to be in this cube then you need to load it to some generic element under it and then write C level rules to calculate your KPIs. I wouldn't recommend this approach, particularly if you are new since C levels rules can be a challenge.

Typically with a finance TM1 app the core set of data is the financial data and so your system needs to be designed around this rather the ancillary information used to calculate KPIs. So I would have all you financial data at the N element level of another cube and then pull the sq m data from your current cube at the "Subset X" level.

Your kind of doing things back to front in the moment....

Cheers,