i am in BPC MS 7.0 and got the requirement as below .
i am maintaining maset data manulayy and TD data by falt file .
I have list of cost centers and each cost center has some positions and each position has some head count value and that positions are repeat under different cost centers.
Costcenter ---time --position --head count
admin --- 100
labor --- 200
helper --- 300
labor --- 400
helper --- 500
I need to develoupe report : if user select 101 cost center , report displays for all positions under 101 costcenter dynimically .same like 102 cost center.
I am confused about data model . i created costcenter , time dimensions . For position can i create dimension or property ?
because above example is very small ...i have so many attributes like position ( wage type , subgroup ...)
pls let me know ...design flow for my requirement .