Excel Best Practices in Xcelsius Dashboard


At designing your dashboard time in BO Dashborards or Xcelsius follow the best practices concerning  Microsoft Excel.

Is suggest to avoid:
- Array calculations as they can dramatically affect performance:
1. SUM
2. COUNT
3. SUMIF
4. COUNTIF
5. INDEX
6. MATCH
7. HLOOKUP
8. VLOOKUP
9. and similar
- Repeating logic:

    This example will run the SUM twice :IF(SUM(A1:A10),   ,SUM(A1:A10))

 Any calculations:
They add overhead when loading or interacting with the dashboard
They increase the time it takes to generate the flash file when you export or preview

Is better to: 
- Hard code values wherever possible instead of using formulas
- Define calculations on the server side where possible
- Use server side sorting to order your data and make the results easier to compare
- Use server side ranking to limit the number or rows returned
- Link to a report for detailed drill down
- Use a selector with filtered rows instead of Excel lookups
- Use direct binding from components directly to the results of a query (new in Dashboards 4.0) to bypass the spreadsheet layer wherever possible.


Comments

  1. SAP HANA Online TrainingNovember 14, 2012 at 9:21 PM

    this is very analysis system for SAP HANA interdiction part. I am very happy about this article thank you. and one more thing for best sSAP HANA online and Class room Training at Arrowsol Training Institute provide SAP HANA
    please contact at info@arrowsoltraining.com

    ReplyDelete
  2. businessobjectsbi4May 17, 2013 at 10:36 PM

    Thanks a lot!

    ReplyDelete
  3. UnknownNovember 5, 2013 at 11:03 PM

    Hai,I have seen your site that was about sap hana online training with the best information and it is very interesting & useful for the one who is looking for the brightful career in the sap.

    ReplyDelete
  4. UnknownJuly 18, 2016 at 10:34 PM

    Nice post love reading it...

    Managers Dashboard for Business

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innov...
Read more

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo...
Read more

FWM 01002 - Unable to reconnect to the CMS. The session has been logged off or has expired.

An error has occurred: Unable to reconnect to the CMS.  The session has been logged off or has expired. (FWM 01002) Environment BO XI R 3.1 SP 4 In order to solve this issue we found a  SAP released note 1422296  1422296 - Error:' Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' with BusinessObjects XI 3.1. Symptom Not able to schedule WebIntelligence reports. Reports fail with error:'Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Environment BusinessObjects XI 3.1. Reproducing the Issue Schedule a WebIntelligence report to run now. Reports fails with error:u2018Unable to reconnect to CMS :6400. The session has been logged off or has expired.(FWM 01002)' Resolution 1. From Central Configuration Manager, disable all the services and re-enable them. 2. Log into Central Management Console and go to the server area. 3. Go to the properties of Central Man...
Read more