SAP BW Projekt Eclipse - Exeption Aggregation

[former_member1318024]

Hi there,

I am new with SAP BW Projects and I want to create a formular in my BW-Project in Eclipse. I have a full data sources which includes sold number of pieces (Unit Sold) and price per product (Retail Price) in different key figures. Now I want to generate a formular which calculate the gross sales.

The formular is: Unit Sold (Product X) * Price per Pice (Product X) + Unit Sold (Product Y) * Price per Pice (Product Y) + Unit Sold (Product Z) * Price per Pice (Product Z).

There are 9 different Product Types. I know I need to create an exception aggregation, but I do not know how to do that. I have tried several times, but in SAC there are always a wrong number.

Can anyone help?

Regards and lovely day

[moshenaveh]

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!