Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How many queries on Excel supports Live Office on Xcelsius

Hi there,

I have a customer who is asking How many queries or views within Excel supports Live Office on Xcelsius4.5 (Designer).

Platform:

Windows 2003 Server SP1.

BO XIR2 SP3.

Thanks in advance.

Marlon.

replied

Hi Marlon,

There is no defined limit in Xcelsius with how many Live Office views/connections you can have in a single model. However, affect on performance will depend on the amount of data you are bringing back from those queries and the complexity of your Excel logic.

As a best practice, we'd suggest keeping the amount of connections below 10 while limiting the amount of data coming back in a single query to be below 500 rows.

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question