SAP Knowledge Base Article - Public

2723886 - The rule about which dimensions will be automatically selected to analyze the target measure in Smart Discovery is not clear in SAP Analytics Cloud (SAC)

Symptom

The rule about which dimensions will be automatically selected to analyze the target measure in Smart Discovery is not clear in SAP Analytics Cloud (SAC) :

  • After the version data in the model is cleaned and replaced during importing, same dimensions will be selected
  • When copying the model including data to a new model, sometimes same dimensions will be selected but sometimes different dimensions will be selected

Environment

  • SAP Analytics Cloud 2018.20.1

Reproducing the Issue

  1. 1Log on to SAC tenant.
  2. Try to Run a Smart Discovery on the sample model [BestRunJuice_SampleModel] with target measure as [Gross Margin].
    => In the Overview page, the following dimensions will be selected to analyze the target measure:
    • Bar chart: Analyze Gross Margin by Sales Manager
    • Tree Map: Compare the Gross Margin by Sales Manager and Location
    • Scatterplot: Identify the association between Discount and Gross Margin by Store
  3. Go to Browse > Models, and copy the sample model [BestRunJuice_SampleModel] to a new model [BestRunJuice_CopyOriginal].
  4. Try to Run a Smart Discovery on the copied model with target measure as [Gross Margin] too.
    => In the Overview page, the same dimensions as step 2 are selected to analyze the target measure:
    • Bar chart: Analyze Gross Margin by Sales Manager
    • Tree Map: Compare the Gross Margin by Sales Manager and Location
    • Scatterplot: Identify the association between Discount and Gross Margin by Store
  5. Import Data From file to the copied model [BestRunJuice_CopyOriginal] by selecting Clean and replace selected version data as Import Method in Data Integration dialog.
  6. Perform step 5 again.
    => In the Overview page, the same dimensions as step 2 are still selected to analyze the target measure:
    • Bar chart: Analyze Gross Margin by Sales Manager
    • Tree Map: Compare the Gross Margin by Sales Manager and Location
    • Scatterplot: Identify the association between Discount and Gross Margin by Store
  7. Copy model [BestRunJuice_CopyOriginal] to a new model [BestRunJuice_CopyImported].
  8. Try to Run a Smart Discovery on the new copied model [BestRunJuice_CopyImported] with target measure as [Gross Margin] too.
    => In the Overview page, different dimensions will be selected to analyze the target measure:
    • Bar chart: Analyze Gross Margin by Location
    • Tree Map: Compare the Gross Margin by Location and Product
    • Scatterplot: Identify the association between Discount and Gross Margin by Store

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, smart discovery, dimension, automatically, auto, chart, import, copy, overview , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0