Skip to Content
0
Former Member
Jul 06, 2010 at 01:03 AM

Requirement

15 Views

Hi ,

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.

Ex :

Costcenter ---time --position --head count

101---2010.jan -


admin --- 100

101---2010.jan -


labor --- 200

101---2010.jan -


helper --- 300

102---2010.jan -


labor --- 400

102---2010.jan -


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 .

Regards,

PSR