Trick to split cross table with more columns in to two parts in webi
This blog is about one of our project requirement to split a single table with multiple columns for example 20 columns in to 2 parts ( Table-1 with 15 columns and Table-2 with 5 columns) to accommodate in single page and how we accommodated using Sections
We have a BO webi document that runs for 50+ Business Units. In one of the report tab – For some BUs the table displays more columns which cannot be accommodated in a single page when exported in pdf. It went in two pages but user requested us to accommodate in single page as we had enough blank space below the table as number of rows were less.
For explanation we use below data set with sample columns/rows.
Below is report structure with cross table and break applied on Tier_1_Sorting. First 2 rows and first column are used for sorting purpose and will be hidden later.
After hiding required rows and columns the report looks like below in Page mode (It spans in 2 pages with A4 Landscape and 0.1 Margin setting)
Requirement: Is it possible to move second part of the table in page 2 to page 1 as below?
How this is done?
Step-1: We create variables required for this trick
v_Tier1 Count=If (Count([Tier_1]) Between (5;9)) And (Count([Tier_1])+Count([Tier_2]))>18 Then 3 Else Max([Tier_1_Sorting])
v_Table Split=If [Tier_1_Sorting]<=[v_Tier1 Count] Then 1 Else 2
v_Tier1 Count – Will decide how many Tier-1 values to be displayed in Table-1.(Here we have shown sample logic required only for EMEA BU based on its Tier-1/Tier-2 values. In real time we have to handle with appropriate logic for different BUs that require table split)
Step-2: Create Section for table split
Section is created using variable (v_Table Split) and section header is hidden in final display as below.
SAP Environment Details Used
SAP BO 4.2 SP5 (Also applicable for SAP BO 4.3)
HANA 2.0 SP5
Using sections to group data