BPC10 NW: Same dimension Multiple times

[Former Member]

Hi Experts!!!

Is it imposible to have a dimension more than ones in the same model. The problem is that i have a dimension called Person and in person i have employees and bosses. A person can be a boss and be at the same time an employee. how can i register in the same transaction the name of the employee and the name of the boss without dividing the dimension taking to account than employee can have more than one boss and a boss can have morethan one employee??.

Regards,

[Former Member]

Hi,

You cannot have a dimension in the model more than once.

We have had something similar for a BPC 10 project I have recently been working on. You could have two dimensons do that you have a 'Manager' dimension, and an 'Employee' dimension. This will allow your one-to-many options.

Another options is that you could use hierarchies to configure it, maybe doing to data imports, one prefixing all employees with 'MGR_' for manage parent ID's. You'd do this in your transformation file using;

ID=*STR(MGR_)+ID

Or manually maintain your hierarchies and do it manually to set these up.

Hope this helps,

Nick

[Former Member]

Hi,

If you have a dimension called employees, then all the members are employees. You need to have a hierarchy, and then, all the parent members of the dimension will be bosses, as well.

Hope you got the idea.

[former_member313601]

Is it required that you need to record both employee and Boss in the Txn?

If not, Hierarchies can be used. you may use multiple hierarchies to capture multiple bosses for the employee.