WAD - fixed column width truncates header text

[former_member186445]

i've just started working with the WAD stuff...

In one of the templates I've added the piece of coding as described in note 1118502 in order to have a fixed width for my reports. As described in note 1292696 the header of the column is truncated at the end. so i've added the coding to wrap the text, but i don't get in working. Can anybody tell we where to exactly add this piece of coding to have it working?

thanks in advance.

where to add :

<bi:MOD_PARAM_NAME value="WRAPPING" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="BOOLEAN" >

<bi:BOOLEAN value="X" />

</bi:MOD_PARAM_VALUE>

in the below code?

<bi:ANALYSIS_ITEM name="ANALYSIS_ITEM_1" designwidth="400" designheight="200" >

<bi:DATA_PROVIDER_REF value="DP_1" />

<bi:MODIFICATION type="CHOICE" value="MOD_SINGLE_MODULE" >

<bi:MOD_SINGLE_MODULE type="COMPOSITE" >

<bi:MOD_ALIAS value="SET_COL" />

<bi:ACTIVE value="X" />

<bi:MOD_SELECT type="CHOICE" value="MOD_GENERIC_MODULE" >

<bi:MOD_GENERIC_MODULE type="COMPOSITE" >

<bi:MOD_REFERENCE value="com.sap.ip.bi.ColumnWidthByIndex" />

<bi:MOD_PARAMETER_LIST type="ORDEREDLIST" >

<bi:MOD_PARAMETER type="COMPOSITE" index="1" >

<bi:MOD_PARAM_VALUE type="CHOICE" value="INTEGER" >

<bi:INTEGER value="20" />

</bi:MOD_PARAM_VALUE>

<bi:MOD_PARAM_NAME value="1" />

</bi:MOD_PARAMETER>

<bi:MOD_PARAMETER type="COMPOSITE" index="2" >

<bi:MOD_PARAM_NAME value="*" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="INTEGER" >

<bi:INTEGER value="40" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

</bi:MOD_PARAMETER_LIST>

</bi:MOD_GENERIC_MODULE>

</bi:MOD_SELECT>

</bi:MOD_SINGLE_MODULE>

</bi:MODIFICATION>

<bi:WIDTH value="400" />

</bi:ANALYSIS_ITEM>

[Former Member · Accepted solution]

Hi Mti,

The code snippet is supposed to work with modification module com.sap.ip.bi.rig.ColumnWidth. But nevertheless you may try it with com.sap.ip.bi.rig.ColumnWidthByIndex by inserting it before </bi:MOD_PARAMETER_LIST> & check if it works.

i.e.

<bi:MOD_PARAMETER type="COMPOSITE" index="2" >

<bi:MOD_PARAM_NAME value="*" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="INTEGER" >

<bi:INTEGER value="40" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

<bi:MOD_PARAM_NAME value="WRAPPING" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="BOOLEAN" >

<bi:BOOLEAN value="X" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER_LIST>

--Priya

[former_member186445 · Accepted solution]

thanks for your reply.

if i add the snippet like you suggest, the report dumps with the below message :

The initial exception that caused the request to fail was:

The parameter "MOD_SINGLE_MODULE" with the index "0" occurs multiple times in Web template "YALLBIO_BTCHREL_SUMMARY":

<bi:param name="MOD_SINGLE_MODULE" >

If i add it like below, the reports does not dump anymore, but the wrapping does not work, showing an error message in the web report : Parameter 3: "X" is not an integer (Web item "BTCHREL_0013", module 1: "SET_COL")

adapted code :

<bi:ANALYSIS_ITEM name="BTCHREL_0013" designwidth="400" designheight="200" >

<bi:DATA_PROVIDER_REF value="DP_0013" />

<bi:MODIFICATION type="CHOICE" value="MOD_SINGLE_MODULE" >

<bi:MOD_SINGLE_MODULE type="COMPOSITE" >

<bi:MOD_ALIAS value="SET_COL" />

<bi:ACTIVE value="X" />

<bi:MOD_SELECT type="CHOICE" value="MOD_GENERIC_MODULE" >

<bi:MOD_GENERIC_MODULE type="COMPOSITE" >

<bi:MOD_REFERENCE value="com.sap.ip.bi.ColumnWidthByIndex" />

<bi:MOD_PARAMETER_LIST type="ORDEREDLIST" >

<bi:MOD_PARAMETER type="COMPOSITE" index="1" >

<bi:MOD_PARAM_NAME value="1" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="INTEGER" >

<bi:INTEGER value="180" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

<bi:MOD_PARAMETER type="COMPOSITE" index="2" >

<bi:MOD_PARAM_NAME value="*" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="INTEGER" >

<bi:INTEGER value="50" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

<bi:MOD_PARAMETER type="COMPOSITE" index="3" >

<bi:MOD_PARAM_NAME value="WRAPPING" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="BOOLEAN" >

<bi:BOOLEAN value="X" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

</bi:MOD_PARAMETER_LIST>

</bi:MOD_GENERIC_MODULE>

</bi:MOD_SELECT>

</bi:MOD_SINGLE_MODULE>

</bi:MODIFICATION>

<bi:BLOCK_COLUMNS_SIZE value="250" />

</bi:ANALYSIS_ITEM>

</bi:CONTAINER_LAYOUT_ITEM>

</bi:CONTAINER_LAYOUT_ITEM>

[Former Member · Accepted solution]

Hi Mti,

What you have done seems correct. Can you use com.sap.ip.bi.rig.ColumnWidth instead to check if it works?

--Priya

Edited by: Priya Jacob on Mar 24, 2010 12:08 PM

[former_member186445 · Accepted solution]

I changed the coding according to your suggestions. Indeed it's not throwing any errors anymore, but it's not working, meaning the header texts are not wrapped. Any other suggestion?

the code:

<bi:MOD_REFERENCE value="com.sap.ip.bi.rig.ColumnWidth" />

<bi:MOD_PARAMETER_LIST type="ORDEREDLIST" >

<bi:MOD_PARAMETER type="COMPOSITE" index="1" >

<bi:MOD_PARAM_NAME value="COLUMN_FIX_DEFAULT" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="INTEGER" >

<bi:INTEGER value="180" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

<bi:MOD_PARAMETER type="COMPOSITE" index="2" >

<bi:MOD_PARAM_NAME value="COLUMN_DEFAULT" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="INTEGER" >

<bi:INTEGER value="50" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

<bi:MOD_PARAMETER type="COMPOSITE" index="3" >

<bi:MOD_PARAM_NAME value="WRAPPING" />

<bi:MOD_PARAM_VALUE type="CHOICE" value="BOOLEAN" >

<bi:BOOLEAN value="X" />

</bi:MOD_PARAM_VALUE>

</bi:MOD_PARAMETER>

</bi:MOD_PARAMETER_LIST>

[Former Member · Accepted solution]

Hi Mti,

Plz. also check your BI SP/Patch version as per Note 1292696, maybe your current version doesn't support the same.

--Priya

[former_member186445 · Accepted solution]

after some discussions with the technical people that seems infact to be the problem

thanks

M.

[Former Member · Accepted solution]

Hi Priya/Mti,

I need to change the width of colum of table/analysis. How to achieve this?

Can any one help me...

Thanks,

KN

[Former Member · Accepted solution]

Hi all,

In the WAD we have option called analysis/table. Generally we can't control the table column width through properties.

so, my question is we can achieve this through html code or something.

Plese help me on this...

Thanks,

KN