SAP BusinessObjects - How to split string values into several items?

[#1]

Hello Experts,

I am an amateur user of SAP BO and would like to seek advice from the community to tackle one of the issue I am currently facing for my project utilizing BusinessObjects.

From my current database, I can pull three fields namely "Class", "Name" and "Favourite Food". My objective is to split the string values of the items in "Favourite Food" into several records while still maintaining its relationship with other fields.

Is this even possible theoritically? since BusinessObjects only allows quering data but not manipulating or adding/splitting items the database itself. Please kindly advice how can I achieve below screenshot in BusinessObject. Thank you very much!

I look forward to your opinions.

[mhmohammed]

Hi Owen,

If assuming you can alter anything in Excel, you should create an excel based Universe or, load that Excel data to a Microsoft access data base (saved on shared drive accessible through BO) and create a Universe using that database. That's one way, if you don't want to alter Excel.

Or, you create another excel document, having formula in each cell pointing to each cell of the Excel (with data), and do some transformations there, to split the Favorite Food column into multiple columns (then copy that in different tabs), and then create multiple queries.

Thanks,
Mahboob Mohammed