Skip to Content

SAP BusinessObjects - How to merge tables and aggregate values based on certain conditions?

Hello Experts,

I'd like to merge two tables from two different data providers and would like to know the possibility of aggregating values based on the values provided by another table as shown below.

For example: In Table 1, we have a complete list of the dataset and we would like to use this table as a reference for Table 2, which is coming from different data provider compare to Table 1.
I wonder if it is possible for SAP BusinessObjects Webi to merge the table and calculate the 'Money Spent on Food' based on a list of items provided under 'Favourite Food' which is mainly separated by comma.

Would this be possible? Any feedback or tips would be very appreciated!

sample1.png (21.0 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Mar 17 at 06:37 PM

    Hi Owen,

    You'll need to follow the below blog
    https://blogs.sap.com/2015/08/15/string-aggregation-on-webi-report-level/

    I still don't understand why you're asking contradictory questions in different posts? In the below post you asked almost an opposite question.
    https://answers.sap.com/questions/13004726/sap-businessobjects-how-to-split-string-values-int.html

    What are you trying to achieve?

    Thanks,
    Mahboob Mohammed

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Mahboob, thank you very much for taking a look into this issue!

      What I am trying to achieve is actually for more complex than thread so I need to break them down into several straightforward questions so it could help me better understand the mechanics of SAP BusinessObjects and how it works.

      So basically for this question, I'd like to know the possibility of linking two tables that are related but having different formats and the capability of SAP BusinessObject to manipulate the data without having to modify the database/dataprovider directly,

      let's say, the Table 1 is taken from a universe and the Table 2 is from excel as the data provider. I would want to merge them and create a report which looks like the third table called 'Merged Table'.

      I'd like to know if it is possible to pull and aggregate the 'Money Spent on Food' based on the given values, which is a string of combined values from another table separated by comma.

      Once again, thank you for your comprehensive reply for the other post. Much appreciated!

      I look forward to your feedback or tips for this one as well if you dont mind ;)

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.