Category Archives: Xcelsius

Do you know these tricks?

During the last couple of months I have discovered some usefull tricks, which in turn are too small for a post on its own, so I have combined them into this one. Formula for calculating the maximum scale for chart … Continue reading

Filed under Components, Design, Excel | Tagged , , , , , | 1 Comment

How to get a Sharepoint List in Xcelsius and publish outside Sharepoint

If eg. Treasury is maintaining a Tax Rate by country list in the Corporate Sharepoint directory, you can import that list into Xcelsius for use in your dashboard without setting up a portal provider as you do not want to … Continue reading

Filed under Connection | Tagged , , , | 4 Comments

Suppressing BEx Variable pop-up screen when opening dashboard in SAP portal

When the dashboard is published in SAP portal and it is based on a BEx query connected with a Netweaver dataconnection and that BEx has mandatory variables without default values, the variabele screen is always displayed before actually loading the … Continue reading

Filed under BW / Bex / BICS | Tagged , , , , | 2 Comments

“Empty” value in optional prompt in Bex query

I finally found the solution for the issue with the optional prompts and the empty value string when connecting through BICS to a Bex query. Unfortunately BW does not view the Excel formula =”” as an empty string as thus … Continue reading

Filed under BW / Bex / BICS, Connection, Excel, Xcelsius | Tagged , , , , , | 6 Comments

XComponent and Combobox without drop down triangle

It took me the better part of a day to fix the following error: When I added any one of the XComponents provided by Antivia and I previewed my dashboard, the combo boxes were not rendered proberly anymore. The drill … Continue reading

Filed under Components, Xcelsius | Tagged , , , , | 3 Comments

Maximum character output size limit reached

If you come across the following error in Xcelsius with either with QaaWS or BIWS (WebI): Maximum character output size limit reached. Contact your BusinessObjects administrator. (Error: ERR_WIS_30272) 2 things you might try to solve it: 1. This error can … Continue reading

Filed under Connection, Xcelsius | Tagged , , , , , | 3 Comments