cancel
Showing results for 
Search instead for 
Did you mean: 

Increasing row capacity of any excelcius component (Filter ,Combo Box)

former_member360582
Participant
0 Kudos

Hi

Even though I have increased the capacity of Dashboard rows capacity from 512 to 2000.

But my filter component or combo box component source data is mapped to more than 512 rows in the spreadsheet,while previewing it still shows data of 512 rows.

Is there any way to increase component capability?

I know the performance will be bad but still atleast it should capture the whole source data records and

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

It could be two reasons

First Reason: it could be due to the limit of no of rows in excel .Please check the preferences option in Xcelsius . By default it will be set as 512 rows of data increase that to required rows.

Second Reason: if you are using live office in Xcelsius.By default it will fetch 512 rows of data.To increase limit we have to do some server side settings.Please refer to the following SAP Note which gives the solution to this problem.

SAP Note:1307538

or go through the following steps:

These changes have to be made on the server side

1. Create a backup of dsws-liveoffice-provider.jar from serveru2019s InstallDrive:\program files\business objects\Tomcat\webapps\dswsbobje\WEB-INF\lib for future reference.

2. Copy dsws-liveoffice-provider.jar from serveru2019s InstallDrive:\program files\business objects\Tomcat\webapps\dswsbobje\WEB-INF\lib to your computer.

3. Rename the file just copied to dsws-liveoffice-provider.jar.zip (add.zip to end of filename)

4. Create folder in root of InstallDrive: named META-INF (case sensitive), in InstallDrive:\META-INF named BusinessObjects (case sensitive) and in InstallDrive:\META-INF\BusinessObjects named DSWS (case sensitive)

5. Using WinZip or WinRAR, unzip the file named liveoffice_config.properties from the dsws-liveoffice-ws.jar.zip file copied from the server. Place this file in InstallDrive:\META-INF\BusinessObjects\DSWS.

6. Edit the liveoffice_config.properties file and find the following section:

#max number of range rows and range columns to return

maxRowCount=512

maxColumnCount=512

7. Edit the maxRowCount entry to the value youu2019d like to use

8. Save the file as liveoffice_config.properties (same filename)

9. Using winRAR or WinZip add the new liveoffice_config.properties file back to dsws-liveoffice-ws.jar.zip, making sure to use the "use absolute path" option.

10. Stop Apache Tomcat service on BO server

11. Copy dsws-liveoffice-ws.jar.zip to serveru2019s InstallDrive:\program files\business objects\Tomcat\webapps\dswsbobje\WEB-INF\lib.

12. Rename dsws-liveoffice-provider.jar in serveru2019s InstallDrive:\program files\business objects\Tomcat\webapps\dswsbobje\WEB-INF\lib directory to dsws-liveoffice-provider.jar.old.

13. Rename dsws-liveoffice-provider.jar.zip in serveru2019s c:\program files\business objects\Tomcat\webapps\dswsbobje\WEB-INF\lib directory to dsws-liveoffice-provider.jar

14. Empty the Tomcat cache by deleting the content of the folder <<C:\Program Files\Business Objects\Tomcat55\work>>

15. Restart Apache Tomcat on server

This should increase the number of rows fetched by LiveOffice, however it may happen that changing the number of rows in the liveoffice_config.properties many times may result in liveoffice picking the data from the cache. Hence deleting the cache (C:\Program Files\Business Objects\Tomcat55\work) is necessary. Incase deleting the cache also doesn't work, we may have to redeploy the dswsbobje folder.

To redeploy, follow the steps given below:

1. Go to C:\Program Files\Business Objects\Tomcat55\webapps and keep a backup of the dswsbobje folder.

2. Now delete this folder and restart Tomcat.

3. Restarting Tomcat will recreate the dswsbobje folder but will again default the number of rows fetched by LiveOffice to 512.

4. We will again have to follow the steps mentioned in the start to increase the number of rows from 512 to the desired value.

5. Restart Tomcat again for the changes to take place.

Note: Increasing the number to large values might cause inconsistency in the behavior or instability.

former_member360582
Participant
0 Kudos

Act this is done by admin at server side..