Kig figure Display Requirement in BEx

[former_member182997]

Dear Experts,
I have a Bex report for Buffer Norm where I have two keyfigures.
1. Maximum Stock Level and  2 Closing Stock
In the report the Maximum Stock level keyfigure is displayed as an aggregated value while the closing stock is okay.
On analysis i found for every material there are four entries of record rows. I need to display only one of them in the report as such to pick only that record for the material where closing stock is not zero.
Attaching the screen shots.
At Cube level:

At Report Level

Need to show:
Maximum Stock Level = 65 and Closing stock = 57
Can you suggest how to pick only those required values from the cube.
I was thinking to use exception aggregation for the keyfigure Maximum Stock Level. But no idea how  or if it will work.

Thanks and Regards
Aparajit

[anshu_lilhori · Accepted solution]

Yes you are thinking in right direction.Please check the other characteristics in cube which make your row unique.From the above data all four rows combination is same.

So check the characteristic which is making a unique row and use the same as reference characteristic while applying Exception aggregation.

Regards,

AL

[former_member182997]

hi

Any suggestion from your side ??

[Former Member]

hi,

you can define global key figures i.e. RKF/CKF for your solution. The Maximum stock level can be a RKF with the exception aggregation defined in the details. In the CKF you can use this Maximum stock level and the closing stock to get the values. Defining global key figures would help as the values will be pre calculated and with appropriate aggregation.

regards,

Arvind.

[former_member182997]

Hi

Thanks for your guidance.
Yes your suggestion worked.
I have found out another characteristic  which is storage location which i used as reference characteristic and used average as exception aggregation, and it is displaying the right values for maximum stock level key figure

But this has brought another problem which is as below:
The buffer norm status calculation is showing wrong results.
I must inform you that there are Exceptions and conditions defined in the report.
The APD collects the results for Buffer Norm Status into direct DSO
So buffer norm status  for some of the conditions  is showing incorrect buffer norm status calculation

How to correct this would you please guide me?

For reference this is below in screenshot:
11/2 * 100   =  550  which is showing correct
17/24 * 100 =  70.83 which is showing 35.42  which is wrong.

Regards!

[anshu_lilhori]

Can you let me know the definition of buffer norm status.Like how this being calculated and also check if any aggregation is applied on it .Also check if calculate tab of this formula/ckf.

Regards,

AL

[former_member182997]

Hi ,

Thanks for your kind reply.
Yes I am attaching the screenshot of this KF Definition. Also, I must say,  I have created a calculated KF  Maximum Stock Level which I am displaying in the report, while in Buffer Norm, the global KF  Maximum Stock Level (MAXMSTKLEVEL) has been used.
Now some values of the calculation are showing desired output while few others are not.

The aggregation applied is Exception aggregation type: Use Standard Aggregation with
0Material as reference characteristic

In calculations nothing has been defined however,  Calculation Direction is along the row.

Thank you!

[anshu_lilhori]

What is the use of MBST = 0 and closing stck > 0 formula.Can you share its definition as well.

Also try removing it from the buffer norm status formula and see if that gives correct value or not.

Regards,

AL

[former_member182997]

Goodmorning ,

There is an interesting find out. After a new analysis I have found out that the similar thing is happening as above. Meaning there by is :

The KF Maximum Stock Level which had multiple entries  were being displayed in aggregated form as in the above screenshot which with your suggestion got resolved yesterday. So, for those materials which have single record rows, the buffer norm is being calculated correctly. But the problem is with multiple entries only.
Here in calculation of Buffer Norm, what is happening is  Closing Stock Quantity KF values are correctly being picked up but again Maximum Stock Level KF values are being aggregated and being calculated.

Buffer Norm= (Closing stock quantity / Maximum Stock Level) * 100

For your reference:
As per described problem, buffer norm is incorrectly calculated as  (44 /180) * 100 = 24.44
which should have been,  (44/45)*100= 97.77
Here is report level calculation screenshot:

My understanding :

If i can make the buffer norm calculation take the average value of  Maximum Stock Level Key Figure, it will 100% become correct. But i am not sure how to make that happen.

As you asked for the formula  definition  MBST = 0 and closing stck > 0  here is the screen shot for that.

Regards!

[anshu_lilhori]

Hi,

Did you apply Exception aggregation on Maximum stock level kf.

Lets make the steps simpler.

choose Exception aggregation as first value and reference characteristic as Storage location.

Now as per the buffer norm status formula.

Divide : Closing stock / Maximum stock level (With exception aggregation)

I am sure this should give the correct value.Please share the output after applying.

Regards,

AL

[former_member182997]

Dear ,

Hurray it worked! I am sorry for late reply. Although I got the results , but wanted User confirmation as well which delayed. Well as you have asked to share the output I am attaching the screenshots.

But another thing I must say, I have choose Exception aggregation as average value and reference characteristic as Storage location and it is working properly as I needed only one value out of four identical entries I thought to take average.

Here are the screenshots
Before modification:(Incorrect values)

After modification : (Correct values)

  

Thanks for your time and patience
Aparajit