How to avoid aggregation at parent level for specific member

[former_member590808]

Hi,

We have GL member of Accounts dimension which is for "No. of Days" for which the user inputs data in an Input form at all base Entity levels.

At Parent member of Entity dimension the no. of days come as aggregated which we wish to avoid. We want the parent member to also show the same number entered at base member. Is there any possible way to avoid aggregation of data ?

[former_member186338 · Accepted solution]

Sample with dimension member formula:

2 Accounts: NUMDAYSINP - to enter value for DUMMY ENTITY, NUMDAYS - member with dimension member formula:([ACCOUNT].[NUMDAYSINP],[ENTITY].[DUMMY])

Result:

[former_member590808]

I implemented the member formula, it's working now. Thank you 🙂

[former_member590808]

We have a common GL code 'A00001' against which the numbers are being entered for different entities.

As per my understanding, since we had to create a new formula for every entity, we have an input form.

Is there any approach where we get just the base value in Parent entity and not the aggregation of all the child members?

[former_member186338]

Sorry, but "since we had to create a new formula for every entity" - absolutely incorrect!

You need to create ONLY one formula:

And using this formula the same value will be shown for base and parent members.

Please read help about dimension member formulas: https://help.sap.com/viewer/a2049170bfeb4178ace32222842c3ec1/10.1/en-US/0dec437d04924d3a879e283f0652...

[former_member590808]

User has to enter 'number of days' against different entities which will be later used to calculate inventory for a company.

So that is why the value entered against E1-E4 or E6 for that matter, will always remain constant.

[former_member186338]

Sorry, but you do not understand basic things.

You have MULTIPLE base members with data entered individually for each company. There is no reason why you will always have the same value for all companies.

If "number of days" is constant for all companies, then you have to enter it only once in some dummy company. Then for real companies you can have dimension member formula to get this value from dummy company.

[former_member590808]

91 is the "number that the user inputs" It can be any 'n' digit.

E1-E4 are the child member in Parent E5 hierarchy therefore, we get the summation of their data in the output.

[former_member186338]

User is entering 91 into E1, E2, E3 and E4 - 4 values!!!!

Next time the user will enter 90 - E1, 93 - E2, 70 - E3 and 65 - E4

What do you want to show in parent E5????

No logic!

[former_member590808]

We are entering value at child member of Entity dimension[E1-E4 and E6].

P1 being the parent head is getting calculated which is a summation of child members[E5 and E6]. We want the parent member P1 and E5 to only display the same number as child member and not the summation [in this case 91].

[former_member186338]

Strange idea without background logic... Why 91???

What is the criteria to use E1 or E2 or E3 or E4 to show in parent???

P.S. Please delete duplicated answer!

[former_member186338]

"We want the parent member to also show the same number entered at base member." - ???? what do you mean? What do you want to have in Parent member of Entity dimension? Provide some sample screenshot of the required result.

Something can be done using custom measure formula, but the requirements are not clear.