I have an xclesius document using a live office excel spreadsheet based on a Universe Query. The report produces 2500 rows and the live office insert/refresh works fine in excel.
I can import the spreadsheet model create my dashboard, view it and see all the data. But once I try to refresh the data using live office connector to refresh the live office content, I only get 512 rows.
I have set the max rows parameter to 3000. To resolve this issue we tried to install as you can see below. Step 1 till 8 works. The problem is the jar file in step 8 does not create the directory from step 9. \DSWS is missing. So there is no file for configure the properties.
Can anybody guide us?
-
X----
1. Navigate to the DSWS war file location.
(ie: F:\Program Files\Business Objects\deployment\workdir\tomcat55\application)
2. mkdir dswsbobje
3. cd dswsbobje
4. jar -xvf ..\dswsbobje.war
5. Navigate to directory containing dsws-common-provider.jar
cd WEB-INF\lib
6. mkdir dsws-liveoffice-provider
7. cd dsws-liveoffice-provider
8. jar -xvf ..\dsws-common-provider.jar
9. cd META-INF\BusinessObjects\DSWS
10. Type command. notepad liveoffice_config.properties ( use vim on Linux)
11.Change the following parms and save file.
maxRowCount=1024
maxColumnCount=1024
12. Change directories back to the root of dsws-liveoffice-provider.
cd ..\..\..\..
13. jar -uvf ..\dsws-liveoffice-provider.jar META-INF\BusinessObjects\DSWS\liveoffice_config.properties
adding: META-INF/BusinessObjects/DSWS/liveoffice_config.properties(in = 974) (out= 483)(deflated 50%)
14. Change directories back to the root of dswsbobje.
cd ..\..\..
15. jar -uvf ..\dswsbobje.war WEB-INF\lib\dsws-liveoffice-provider.jar
adding: WEB-INF/lib/dsws-liveoffice-provider.jar(in =1954779) (out= 1344659)(deflated 31%)
16. Stop Tomcat
17. Navigate to <tomcat>\webapps\ (ie: F:\Program Files\Business Objects\Tomcat55\webapps)
18. Rename dswsbobje folder to OLD_dswsbobje.
19. Start Tomcat.
20. After app is redeployed, navigate to the lib folder (ie: F:\Program Files\Business Objects\Tomcat55\webapps\dswsbobje\WEB-INF\lib)
dsws-liveoffice-provider.jar file should have a new timestamp relative to the time you ran the jar -uvf command.
21. You can run jar -xvf dsws-liveoffice-provider.jar to verify the contents and that the new parms are in the newly deployed liveoffice_config.properties
mkdir dsws-liveoffice-provider
cd dsws-liveoffice-provider
jar -xvf ..\dsws-liveoffice-provider.jar cd META-INF\BusinessObjects\DSWS\ notepad liveoffice_config.properties
21. In Xcelsius. Go to File -> Preferences and check your Excel options. Change Max Number of Rows setting.
-
X----