2462678 - SAP BusinessObjects Cloud Aggregation Exception Count Showing No Data

SAP Knowledge Base Article - Public

2462678 - SAP BusinessObjects Cloud Aggregation Exception Count Showing No Data

Symptom

SAP BusinessObjects Cloud Aggregation Exception Count Showing No Data

Environment

  • SAP BusinessObjects Cloud

Reproducing the Issue

  1. Create a Model in SAP BusinessObjects Cloud
  2. Add a Row to the Account dimension:
    • ID=COUNT
    • Description=COUNT
    • Account Type=NFIN
    • Hierarchy=<BLANK>
    • Units & Currencies=Label(Count)
    • Aggregation Type=<BLANK>
    • Exception Aggregation Type=COUNT
    • Exception Aggregation Dimension=<DIMENSIONYOUWANTTOCOUNT>
    • Required Dimensions=<DIMENSIONSYOUWANTTOCOUNTBY>
    • Scale=<BLANK>
    • Decimal Places=2
    • Formula=<BLANK>
    • Calculate on=<BLANK>
    • Hide=No
    • Threshold=<BLANK>
  3. Save the Model and create a Story from it.
  4. Notice the COUNT returns blank values

Cause

Formula property must contain a value.

For a simple count this is 1

For a more complex count can be an IF( , , )

Resolution

  1. Open the Model in SAP BusinessObjects Cloud
  2. Edit the COUNT Row in the Account dimension:
    • ID=COUNT
    • Description=COUNT
    • Account Type=NFIN
    • Hierarchy=<BLANK>
    • Units & Currencies=Label(Count)
    • Aggregation Type=<BLANK>
    • Exception Aggregation Type=COUNT
    • Exception Aggregation Dimension=<DIMENSIONYOUWANTTOCOUNT>
    • Required Dimensions=<DIMENSIONSYOUWANTTOCOUNTBY>
    • Scale=<BLANK>
    • Decimal Places=2
    • Formula=1
    • Calculate on=<BLANK>
    • Hide=No
    • Threshold=<BLANK>
  3. Save the Model and create a Story from it.
  4. Notice the COUNT returns the number of <DIMENSIONYOUWANTTOCOUNT> for every <DIMENSIONSYOUWANTTOCOUNTBY>

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, , EPM-ODS, Cloud for Analytics, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., BICloud, BO Cloud, SBOC, counting, count, number, blank, empty, dash , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0