Show TOC

Authorization for SAP Working Capital AnalyticsLocate this document in the navigation structure

Authorization Concept

The general authorization concept applies as described in the Privileges section.

The relevant query views consumed by Working Capital Analytics are:

  • sap.hba.apps.wca.dso.s.v/WCAClearedReceivableQuery

  • sap.hba.apps.wca.dso.s.v/WCADaysSalesOutstandingQuery

  • sap.hba.apps.wca.dso.s.v/WCADSORevenueQuery

  • sap.hba.apps.wca.dso.s.v/WCAReceivableHistoryQuery

  • sap.hba.apps.wca.dso.s.v/WCARevenueQuery

  • sap.hba.apps.wca.dso.s.v/WCAOpenReceivableQuery

  • sap.hba.apps.wca.dso.s.v/WCAReceivableQuery

  • sap.hba.apps.wca.dpo.s.v/WCAClearedPayableQuery

  • sap.hba.apps.wca.dpo.s.v/WCADaysPayableOutstandingQuery

  • sap.hba.apps.wca.dpo.s.v/WCADPOExpenseQuery

  • sap.hba.apps.wca.dpo.s.v/WCAPayableHistoryQuery

  • sap.hba.apps.wca.dpo.s.v/WCAExpenseQuery

  • sap.hba.apps.wca.dpo.s.v/WCAOpenPayableQuery

  • sap.hba.apps.wca.dpo.s.v/WCAPayableQuery

  • sap.hba.ecc/CompanyCodeQuery

  • sap.hba.ecc/CurrencyQuery

  • sap.hba.ecc/YearMonthQuery

  • sap.hba.ecc/ExchangeRateQuery

  • sap.hba.ecc/SAPClientQuery

In addition, the following authorization concept is needed for Path Persistence: The authorization for the read/write access to the database table can be controlled by granting privileges to the views and procedures.

Read Access

  • SQL object privileges (SELECT) for the runtime objects of the following query views:

    • “_SYS_BIC”.“sap.hba.apps.reuse.apf.s.v/AnalysisPathQuery”

    • “_SYS_BIC”.“sap.hba.apps.reuse.apf.s.v/AnalysisPathCountQuery”

  • Analytic privileges for sap.hba.apps.reuse.apf.s.v/AnalysisPathQuery and sap.hba.apps.reuse.apf.s.v/AnalysisPathCountQuery, defining which rows of the view the user is allowed to select

Write Access

SQL EXECUTE object privilege for the following procedures:

  • sap.hba.apps.reuse.apf.s.logic/InsertAnalysisPath

  • sap.hba.apps.reuse.apf.s.logic/UpdateAnalysisPath

  • sap.hba.apps.reuse.apf.s.logic/DeleteAnalysisPath

Moreover, SQLSELECT object privileges for the following tables/views of schema _SYS_BI are required:

  • BIMC_ALL_CUBES

  • BIMC_CONFIGURATION

  • BIMC_CUBES

  • BIMC_DIMENSIONS

  • BIMC_MEASURES

  • BIMC_PROPERTIES

  • BIMC_VARIABLE_ASSIGNMENT

  • BIMC_VARIABLE_VALUE

  • BIMC_VARIABLE_VIEW

  • BIMC_VARIABLE

Running SAP Working Capital Analytics

The SAP Working Capital Analytics application is accessed using a URL that contains an SAP-specific parameter. For security reasons, SAP strongly recommends the following:

Recommendation
  • Do not save the URL in your browser favorites. If you save the URL in the browser favorites, it can be manipulated by script or browser plugins, for example.

  • Instead, create a shortcut on your desktop that you can use to start the application.

  • When finishing your work, make sure you close the browsing session using the Logout button.

For any application extension (such as the use of additional charts), ensure that both the extension and its libraries are trustful.