Skip to Content
Former Member
Feb 08, 2012 at 09:27 AM

Dynamic template in EPM 10.0 version



I am creating a dynamic template where the Employees and Cost centers are two dimensions. Under employee dimension, cost centers have been added as properties as shown below:

ID Costcenter


EMP001 2358

EMP002 2358

EMP003 2358

EMP004 2358

EMP005 2354

EMP006 2354

EMP007 2354

EMP008 2354

EMP009 2358

EMP010 2354

i have designed the Employees dimension members in row n time in column. While creating the template i can see the only 2354 employees. My requirement is if i change the context member from 2354 to 2358 then only those employees must appear which are shown under their respective properties. i have already checked filter because of which i can see only 2354 members but i want it to be dynamic and also that if i select 2354 then only 2354 members must appear and vice versa. It should not be static.

Please guide.

Thank you.