appsconsultant.com

appsconsultant.com

  • Home
  • About
      • About us

        Flexibility is the biggest selling point that we have over our larger rivals. We give our clients the freedom needed to thrive in today’s fast-paced business world, organisations say to us that they often see higher quality work from independent consultants like us, this reason is the primary motivator when choosing us over a big firm. This means that we have the same skills and experience as the big firms, with added freedom and flexibility to let us focus and resolve client requirements.

      • Latest news
        Be a leader who leads with HEART

        Great leaders know how to blend the analytical with the emotional. That doesn't make you a softie. Just the opposite. Some tips

        H: Humility

        E: Excellence

        A: Authentic

        R: Reliable

        T: Trust

         

        More tips for online meetings

        Say 'Thank you' and 'Please'

        Do not Respond to Negativity

        Do not nitpick

        Talk less but say more

        Listen without interrupting

         

         

         

         

        10 Disruptive ideas in 2021-2022

         

        BIG DISRUPTIVE IDEAS 2021-2022

        1 - Deep Learning (AI)

        2 - Virtual Worlds (Gaming and AR/VR)

        3 - Digital Wallets

        4 - Bitcoin Fundamentals

        5 - Electric Vehicles (EVs)

        6 - Online Web and Biometric Security

        7 - Autonomous Ride-Hailing

        8 - Delivery Drones

        9 - Orbital Aerospace

        10 - Home 3D Printing

        Happiness hacks

         

         

      • What we offer

        Business & Technology Consulting

        We offer clients specialised consulting in areas that we deeply understand. Our services include:

        • - Skills To Envision, Design And Develop Enterprise Apps
        • - Talent For SaaS/PaaS/IaaS In The Cloud
        • - API Architecture
        • - Data Science Talent
        • - ALM deployments – Agile/Devops
        Read more
  • Services
  • Blog
  • Contact
  • Home | 
  • Blog | 
  • Enterprise applications | 
  • 3 step process in modifying BI dynamic reports, dashboards or KPI's

3 step process in modifying BI dynamic reports, dashboards or KPI's

by Alex Antonatos
on 19 October 2018

This blog entry is dedicated to a question, received on august 16th from a reader in Sweden.

_________________________________________________________________________

This process/methodology can be used for all large enterprise vendors (Oracle, SAP, Microsoft, and IBM)

Every business has its own reporting requirements, new requirements come up constantly with the ever changing corporate vision to adapt to the constant technological evolution and meet the ongoing client experience requirements.

By modifying, we mean changing the out-of-the-box (OOTB) data warehouse structure, ETL logic or BI repository and front-end to cover the customer specific needs that aren’t covered by the out-of-the-box solution.

All the OOTB large vendors BI Apps offer a good framework to build custom reporting – Make sure to use it -  first rule of thumb : Customization is additive so we never lose the out-of-the-box objects when we customize BI Apps, the OOTB object will always be available. Don`t be fearful in modifying reports. All OOTB large vendor solutions come pre-populated with a specific field mapping as shown below. (you can download the specs. from the vendors support website)

 Field-mapping

Below is an example of a supplier spend dynamic report – Note again that all vendors provide the OOTB definitions as a starting point on the vendor support website, here is an example of a supplier spend report:

supplier-spend

This above mentioned definition provides the specific field mapping as compared to the front cover.

To recap, in your BI work area, create a custom folder where you need to paste the copied report. Right-click on the report and select Rename to give the report a different name (all vendors have incorporated this functionality to improve user experience).

You now have an exact duplicate of the original report which you can use to make the required changes as per your business need.

Final tip, always treat your BI projects as business projects and always put solid governance in place. In the context of BI, there are two key aspects to governance: data governance and BI deployment. 

 

Categories
  • Blogue (Francais)
  • Enterprise applications
2305 Rockland Rd Mount Royal, QC H3P 3E9
514-240-40907 Days a week from 9:00 am to 7:00 pm
alex@appsconsultant.com
appsconsultant.com © 2021. Privacy Policy
Login
 Facebook  Google

username / password