on 01-22-2009 4:51 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.