Did you know… SAP BusinessObjects Cloud Modeling Tips and Tricks

This blog provides some information about SAP BusinessObjects Cloud modeling tips and tricks.

• A modeling trick to resolve bulk “invalid ID” data quality issues.
  • Change the Attribute Type from “Dimension ID” to “Description”.
    
• MASTER DATA:
  • Modelling is not an end user task. It is IT task, or IT and business users together build robust shared models.
  • Check how MASTER data text descriptions visualize in SAP BusinessObjects Cloud and make appropriate adjustments at source.
    • For best results, include the shortest available text field from source.
  • For a Connected (live) Model:
    • Hide any non-critical dimension attributes in SAP BusinessObjects Cloud.
• TRANSACTION DATA:
  • For TRANSACTION data, validate source system reports to the output in SAP BusinessObjects Cloud.
  • For a Manual (standalone) Model:
    • Limit the time horizon to the required minimum for transaction loads.
    • Schedule new transaction data loads in off-hours to not disrupt planning or other processes.
  • For a Connected (live) Model:
    • Limit the time horizon in the underlying source query to reduce the dataset to the required minimum.
    • Minimize the model time horizon by loading only the data you absolutely need.
      • Example: Load 2 years of data, rather than 5 years for great performance plus minimize maintenance and confusion.
    • Avoid creating objects with the same name.
      • Duplicate objects will result in the error message shown here

    Notes:

    • SAP BusinessObjects Cloud System Requirements and Technical Prerequisites: https://uacp2.hana.ondemand.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/11b4e5ff76eb4747bc255d7037be1f01.html
    • Only connect to one tenant at the same time.
      • Different browser tabs will share the same user/cache session which can cause authentication errors if simultaneously connected to more than one tenant.
    • There is an MS Excel file size upload limit of 100MB, CSV file size upload limit of 250MB and a 5 minute timeout for the upload.