Xcelsius - Live Office Max 512 Rows Per Connection

41 Views

Experts,

We are on BOE XI 3.1, Live Office 3.1, Xcelsius 2008 SP2, BI 7.0 SP 15.

We have dashboards that are using webi reports instances using live office connection that are set to refresh on load.

We are noticing that the live office within xcelsius seem to truncate date after row 512 although in xcelsius we have set the max rows to 9999. We also checked the live office connections tab to ensure that right cells are bound pointed properly.

We found a relevant oss note 1257233 on the same issue but looks like the location of the live office config file for BOE R3 is different from BOE R2.

Cause

Xcelsius by default fetches only 512 rows and 512 columns from Live office.

Resolution

To enable Xcelsius fetch more than 512 rows from Live office connection we need to make changes to Liveoffice_config.properties file.

Liveoffice_config.properties file is present in location: \program files\Business Objects\Tomcat\work\Catalina\localhost\dswsbobje\loader\META-INF\Businessobjects\DSWS.

Edit the Liveoffice_config.properties file with notepad and change the MaxRow count from 512 to any greater values.

Save the changes and restart the Tomcat server.

Any idea on how to resolve this issue for BOE R3.

Thanks

Gopal Krishnamurthy

Now preview the dashboard and selector would display greater than 512 rows.