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