Skip to Content

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

Purpose:

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

Overview:

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

Steps to be followed in this regard:

When executing a query in Portal only 4 Keyfigures 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 means Default /Standard Web Template  is blank. It means Default /Standard Web Template  0ANALYSIS_PATTERN is used while executing the query when the problem regarding only 4 Keyfigures are displayed in report output  in one page occurred.

Suppose if you want to display here  6 Keyfigures in one page here instead of 4, please keep a note of the following:

1)Please go to Web Application Designer of relevant  SAP BW Backend system and open Default/Standard Web Template 0ANALYSIS_PATTERN 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 Columns Displayed at Once [BLOCK_COLUMNS_SIZE]) is displayed as 4

2) Make a copy of Default/Standard Web Template [Analysis - 0ANALYSIS_PATTERN] and name it as for eg: Z0ANALYSIS_PATTERN and in this Web Template Z0ANALYSIS_PATTERN  -> 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 Columns Displayed at Once [BLOCK_COLUMNS_SIZE]) from 4 to 6 and save this Web Template Z0ANALYSIS_PATTERN

Please 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 blank to Z0ANALYSIS_PATTERN 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 6 Keyfigures in the resultant page instead of 4 in the first page itself.

Please refer the following link with regard to  Number of Data Columns Displayed at Once [BLOCK_COLUMNS_SIZE]:

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

Tags: