two nice scenario question help plz

[Former Member]

hello sap gurus,

2 scenario questions...help me plz

15. It is require to find the average age of employee of a company. Also it is necessary to make a filter in one other report of the same cube. In this scenario, following designe alternatives are correct:

A. It is not possible to have selection on key figure age

B. Only condition can be used to find make a filter on key figure age

C. Selection based on age is not possible

D. Define, avg in the exception tab and also make sure that it does not display the total for age as it does not make any sense

E. Age can be defined as an attribute of employee and then define the selection on it

16. Cost center managers keep changing and it is required that expense is linked to the right manager at that time. How will you design this scenario:

A. By making manager as a time dependent attribute of cost center

B. Making cost center as time dependent attribute

C. Making cost center and the manager time dependent chara

D. Making time dependent hierarchy

[Former Member · Accepted solution]

Q1. Ans E

Q2. Ans: Could be A and D

[Former Member · Accepted solution]

thx BVC and Ajay,

can you explain 2nd scenario...isn't it frequently changing dimension?

thx

[former_member699913]

Hi Gaurav,

Just to add to BVC...

For question 1 ....you can still have a selection on age by creating a condition on key figure age and enter the conditions value dynamicaly through the use of a formula variable.

Reward if it helps,

Ajay