BO WEB Intelligence - Group dimension values in a single cell - based on Section

[former_member560087]

Hi All,

My Requirement is to display all members of a given dimension in one Cell separated by Commas in a each sections.

I went through the Blog :

https://blogs.sap.com/2016/05/12/group-dimension-values-in-a-single-cell/

Written by "Didier MAZOUE"

The solution work fine for Cell and Break. But it doesn't work for sections. It gives

"# Error" Message.

Example :

Universe : e fashion

Requirement is

"CITY" as Section - display all the store names for each section with comma.

When i tried , based on the above blog. here is the screen shot of the error.

Regards,

DV

[amitrathi239]

Drag the Horizontal table instead of Vertical table for Store Name object under the section.

After that use like store name object in the horizontal table and adjust the width =[Store Name]+";"