Skip to Content
BW Business Explorer (SAP BEx)

To determine the number of Characteristics to be displayed in the first page of result

Purpose:

How to change the number of Characteristics to be displayed in the first page of the result.


Overview:

What steps need to be followed to change the number of Characteristics to be displayed in the first page of the result.


Steps to be followed in this regard:

When executing a query in Portal only 2 Characteristics are displayed in resultant page and rest are displayed in next page.

In transaction RSCUSTV27 in relevant SAP BW Backend system, the following parameters are set:

Here, we can find that parameter Ad Hoc Analysis is set to Web Template ZANALYSIS_PATTERN1
It means Web Template ZANALYSIS_PATTERN1 is used while executing the query when the problem
regarding only 2 Characteristics are displayed in report output  in one page occurred.

Suppose if you want to display here  3 Characteristics in one page here instead of 2, please keep a note of the following:


1)Please go to Web Application Designer of relevant  SAP BW Backend system and open Web Template ZANALYSIS_PATTERN1
and go to Web Item ANALYSIS. In the properties for Web Item ANALYSIS(in the left side of the page) ->  go to section Paging -> Here,
you can find Number of Data(i.e. Number of Data Rows Displayed at Once [BLOCK_ROWS_SIZE]) is displayed as 2


2)Make a copy of Web Template ZANALYSIS_PATTERN1 and name it as for eg: ZANALYSIS_PATTERN2  and in
this Web Template ZANALYSIS_PATTERN2  -> Go to  Web Item ANALYSIS -> In the properties for
Web Item ANALYSIS (on the left side of the page)->  Go to section Paging -> Here, you can change Number of
Data(i.e Number of Data Rows Displayed at Once [BLOCK_ROWS_SIZE]) from 2 to 3
and save this Web Template ZANALYSIS_PATTERN2

Please DO NOT make any changes in Web Template ZANALYSIS_PATTERN1 and also DO NOT MAKE any changes in

Default/Standard Web Template [Analysis - 0ANALYSIS_PATTERN]

3)Go to the relevant SAP BW Backend system and open transaction RSCUSTV27 and change the parameter Ad Hoc Analysis from ZANALYSIS_PATTERN1 to ZANALYSIS_PATTERN2 and  save it and then restart the Java server to make these settings effective.

4)Now, execute the Query in question and you should be able to see 3 Characteristics in the resultant page instead of 2 in the first page itself.



Please refer the following link with regard to  Number of Data Rows Displayed
at Once [BLOCK_ROWS_SIZE]):

http://help.sap.com/saphelp_nw73/helpdata/en/76/489d39d342de00e10000000a11402f/frameset.htm

No comments