Xcelsius uses MS Excel as a base to create Interactive Dashboards. Xcelsius does not support all the functions available in MS Excel. I have put together the list of MS Excel functions that are supported by Xcelsius 2008. This list can also be found in Xcelsius User’s Guide. Following is the List.
If you enjoyed this post, make sure you subscribe to my RSS feed!
And you can use the Xcelsius 2008 SDK to add to this list by writing your own custom function support
Hi i was looking around of google about how to do the 3 tabs you have in this page… where can i get that code?
@ Cristina,
It is an Interactive SWF, created using Xcelsius 2008. Do you want to know how to create it using Xcelsius? or are you looking for a wordpress plugin that can do a similar job?
Regards,
Kalyan Verma
Admin
Hi there,
I have a question in relation to the INDEX and SMALL formula – do you know if they support them together such as =INDEX($C$2:$C$9, SMALL($F$2:$F$9, G4),1)
I have a list view box showing the result of this. Before I render it out I can see the result but when I export it all I get is #NUM!
Any help much appreciated!
Cheers
Kate
Hi together,
I have a problem: when I open xcelsius 2008 and clink on CONNECT for connect it with BPC 7.5, the error pop-up appear with “ActiveX component cann’t create object”, and the connection doesn’t work. Why??
Roberto
Hi,
Can Xcelsius read array formula? I have a model that sumifs with multiple conditions and I use array. I am not sure if loading this into Xcelsius would affect the computation of these formula.
Thanks.
@Bombet, Xcelsius does not support Excel Array functionality at this moment
Do you know from a reliable source when it will be supported?
@Fred, no info yet on the array function. We will be one of the first to break the news once available. Stay tuned. Thanks
Hello everybody,
yesterday I have wasted a lot of time trying to create a Xcelsius 2008 dashboard by using an excel-spreadsheet with arrays. Thanks to your website I now have learned about the problem xcelsius has with arrays. However, can you tell me, whether there exists a document/information about all the other “excel-incompatibilities” of xcelsius in addition of the list of not supported excel-functions!? Thanks in advance for your reply.
Per this forum( http://forums.sdn.sap.com/thread.jspa?threadID=1667292 ), and from my head-wall banging experience just now I believe DCOUNTA is NOT SUPPORTED, or not in its full capacity. My DCOUNTA works beautifully in my spreadsheet, and it is a very robust function, but when I preview my dashboard it doesn’t deliver.
Have you run across this? If this is true, perhaps you should remove it from your list (as I and I’m sure others use it as absolute truth – a great reference).
Cheers,
Jim
SOLVED: DCOUNTA does work! NOTE: DCOUNTA does work, however, it doesn’t perform the same way that it does in Excel (which is very confusing). In my case, in excel when I left a criteria cell blank, it would basically omit that criteria. As if to say in SQL (Considering fields County, Industry and Class)
Select * From Table Where County = Wicomico, MD AND Industry = Retail
However, once compiled as an SWF it was as if it were saying:
Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = “”
So…to make it work you must use the WILDCARD Operator * in the criteria cell to indicate ALL.
Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = *
And it works…
See a modified example dashboard of the difference between * and “” at: http://staff.salisbury.edu/~jrgarrity/dcounta.swf
Download the Excel Model at: http://staff.salisbury.edu/~jrgarrity/dcounta.xls
See more DCOUNTA functionlity at:
http://office.microsoft.com/en-us/excel-help/dcounta-HP005209050.aspx
Hello James,
thanks a lot for your feedback and the link. I suppose that I will have to set up my own little “database” to note all the undocumented problems unless SAP is able to provide us with such an information.
Bernd
Bernd,
DCountA does work! :
I had a similar issue with Xcelsius and DCOUNTA does work! NOTE: DCOUNTA does work, however, it doesn’t perform the same way that it does in Excel (which is very confusing). In my case, in excel when I left a criteria cell blank, it would basically omit that criteria. As if to say in SQL (Considering fields County, Industry and Class)
Select * From Table Where County = Wicomico, MD AND Industry = Retail
However, once compiled as an SWF it was as if it were saying:
Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = “”
So…to make it work you must use the WILDCARD Operator * in the criteria cell to indicate ALL.
Select * From Table Where County = Wicomico, MD AND Industry = Retail AND Class = *
And it works…
See a modified example dashboard of the difference between * and “” at: http://staff.salisbury.edu/~jrgarrity/dcounta.swf
Download the Excel Model at: http://staff.salisbury.edu/~jrgarrity/dcounta.xls
See more DCOUNTA functionlity at:
http://office.microsoft.com/en-us/excel-help/dcounta-HP005209050.aspx
INDIRECT() does not work
…
Hi, ROUND() is not working in my dashboard xcelsius 2008. is three any other w/around ..
Round works for me.