Many to Many In TM1 or Framework manager

[A.Pete]

Hi

Im having some difficulties making Many 2 Many relationsship work in TM1. The trouble is that it sums up the total of the many2many dimensions. This works in Framework Manager, which is my source in TM1, but when the data is summed up to the total its wrong. I know its working as intended and i have to "break" the sum up with a rule but im not getting that rule working. The rule states that if we are at the top of one the M2M dimension we should add the sum of a dimension. This is kind of hard to explain...
Ive added a picture from framework manager on how the tabels relations are set up.

Any tips or suggestions would be greatly appreciated.

/Peter

[tomok]

It's "kind of hard to explain" yet you offer no attempt at trying to explain it except for a worthless diagram? Where in TM1 is this? A TI process, a dimension structure, or a cube rule? You say the rule works as intended and then you say it doesn't work? Which one is it? You need to provide some details here before anyone is going to be able to provide assistance. Granted it may be difficult for you to do this but why should we have to guess at to what your problem is. Give us specifics as to what you have done in TM1 and exactly what is not working.

[A.Pete]

It's "kind of hard to explain" yet you offer no attempt at trying to explain it except for a worthless diagram? Where in TM1 is this? A TI process, a dimension structure, or a cube rule? You say the rule works as intended and then you say it doesn't work? Which one is it? You need to provide some details here before anyone is going to be able to provide assistance. Granted it may be difficult for you to do this but why should we have to guess at to what your problem is. Give us specifics as to what you have done in TM1 and exactly what is not working.

Fair enough.

The TI process arent that exciting since im using a DMR from framework manager as source. Its been modeled as star schema except the Many to Many tables depicted in the "worthless" diagram above .

Hopefully the pictures should explain this better.

I was hoping of using a rule sort of like this

SKIPCHECK;

IF(DTYPE('Group Account',!Group Account) @='C',

# Add values
,
# Add Total from cueb without M2M dimension
);

FEEDERS;

Let me know if you need more info.

Br
Peter

[tomok]

Those are nice pictures but they still don't tell me what is "wrong". You just state it is wrong and don't provide any details about what exactly is wrong with it. I don't understand your M2M dimension and why you think this structure is causing you problems. I'm going to go out on a limb and guess that you are loading the same transactions into multiple spots in this tree and then complaining that the totals are wrong. What have you done to counteract this in TM1? You can't post the same GL transaction into a cube and expect the totals to be correct. This will not work unless you have some sort of "offsetting" transaction to keep the totals from being wrong. Without a complete picture, from a business perspective, as to what you are trying to accomplish I don't have any way to provide guidance.