cancel
Showing results for 
Search instead for 
Did you mean: 

Cell merging option for table in web intelligence

Former Member
0 Kudos

Hello Experts,

Iam using the BI Query to created the universe and based on the universe i have created the webi document. In this document list out the values, i need to merge the cells for common values. But i not able to merge because i selected the rows and the cell merge property, it showing Not applicable for cell merging.

Please help me for this.How i can merge the cells in the table ?

Regards

Prakash T

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Prakash T,

The merge items in WebI works on the dimensions in the left hand panel. Click on two of these and the merge option should appear.

You can also combine fields using the formula bar, for instance

=[field1] + [field2]

Hope this helps

Alan

Former Member
0 Kudos

Hi,

We can able to merge two fields and also two different dimensions. But i need to merge two rows. For example, In the result tables contains country and State are showing like this.


Country    States
USA        California
USA        Indiana
USA        Texas
USA        Georgia 

Now i want to show like this


Country    States
USA        California
           Indiana
           Texas
           Georgia 

Grouping the same name of country field. It should be in dynamically. Please share your ideas regarding this.

Regards

Praksah T

Former Member
0 Kudos

Hi Praksah T,

You can achieve this look using the break feature. Select the country column and then the break button (it is normally left of the sort button) This will create mini tables for each of your countries. If you want it to look like a single table, click on the footer rows and click remove, then on theemply row and click remove and finally on the header row (headers appear by default for each break) and click remove row.

this will leave you data in the shap you want it but with no header. So select the table, and int he properties turn on show table headers.

Regards

Alan

Former Member
0 Kudos

Hi,

Thanks for your quick reply and very helpful answer.

Regards

Prakash T

Former Member
0 Kudos

Hi Alan,

I have the same requirements as well, can this be achieved on runtime instead? I'm guessing the break feature is performed on the output results, however I would like to have it on runtime, which in a way it is merged dynamically if it recognizes the same characteristics.

Thanks,

Jordi

former_member225163
Active Participant
0 Kudos

Hi,

if you need to achieve this at runtime, then it is like results needs to be grouped in database level. which is nothing but adding a 'Group by' clause to your reports SQL statement.

Group by statement can be added to report SQL statement, if we set the universe parameter DISTINCT_VALUES as GROUPBY.

Hope this helps..!!

Thanks,

Bala

Former Member
0 Kudos

Hi Bala,

That does ring a bell but group by can only be applied for relational database right? Our backend is SAP, is that still possible to use group by on universe ?


Thanks,

Jordi

Answers (0)