Percentage and Ratio fields

[Former Member]

Hi

Could someone pls help me with-

I have CSV file containing data, say Sales which includes Percentage fields and ratio fields. I am loading file to Standard DSO.

How to deal with it-

1. I don't have specific formulas mentioned/told which, as one option we can use while creating CKF in BEx Query Designer, instead of avoiding loading data from CSV for those columns. I only have data/values for those Percentage and Ratio fields and no reference how these values are calculated.

2. If directly loaded the CSV file with those fields, how or what should be the aggregation we use for those fields. (Ex. If we want to create BEx query with quarterwise data, for sales value or volume we can take simply summation of all values for that quarter. In our case, for Percentage and Ratio fields, what should b the aggregate?

Pls guide me.

Regards,

Swapnil

[john_hawk]

Hi Swapnil,

From a design standpoint, it is best to make Percentages and Ratios calculated key figures. This will provide a weighted average regardless of the level of aggregate or characteristic display.

If you think about it about it, the Percentages and Ratios in your source files are only meaningful at the level of the key field(s) - similar to how price is only meaningful a at the sales order number and item level. The sum of prices is meaningless as well as the average of Percentages and Ratios, as you already know.

If you have to be able to display these Percentages and Ratios, consider using exception aggregation based on the files key fields. This will insure that the Percentages and Ratios will be displayed only when the key fields are included in the output display.

John Hawk