Supported SAP BO Dashboard Design MS Excel functions
In the new release of SAP BusinessObjects Dashboard Design there will be more MS Excel functions available. In the menu below you’ll find all supported functions. For convenience an explanation of each function is added.
If your are interested in the added functions of the new release, you can download the source file here. You can find the comparison on the 3rd excel sheet in the xlf-file.
Addition 29-07-2012:
The functions ROW and ROWS are not working with Dashboard Design 4.0 SP4.
Hello Pieter — Thank you for sharing the source file for the MS Excel funtions. What version of Xcelsius do you need to have in order to open/update the file?
Thanks,
-Mark
Hi Mark,
You’re welcome. The version you need is the newest version of Xcelsius –> Dashboard Design. I downloaded this version via the SAP Service Marketplace.
Regards,
Pieter
Hi Peter,
I am working on Dashbaord Design Prototype. I still have Xcelsius 2008 setup on my machine. But I am not able to work with AVERAGEIF function in Dashboard Design. I get message “NOT Supported Function”.
Any idea, what could be the reason for this?
Thanks,
Alka
Hi Alka,
The function “AVERAGEIF” is not supported in Xcelsius 2008. Also the fixpacks will not work.
You can use two alternative functions:
– COUNTIF and SUMIF
If you need an example, please send me your e-mailaddress.
Regards,
Pieter
Hi Pieter,
The functions ROW and ROWS are not working in Dashboard Design in SAP BO 4.0.
Kindly help me in this case.
Reagrds,
Arun
Hi Arun,
Sorry for my late reply! You’re right. Both functions are not working in SAP BO 4.0. I tested the functions in the newest version 4.0 with SP4.
Regards,
Pieter
I am trying to use search() function in dashboard, but unfortunately its not supported by dashboard.
The search function is not supported in Dashboard Design. Maybe you can use the INDEX and/or MATCH function.