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)

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

• SAP Analytics Cloud 2018.20.1

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

• Statistics Service, which is used for Smart Discovery, does not run immediately after updating the model data. 
• There is a daily scheduled job to re-generate model statistics on models updated from the previous day.
• Coping the model to another new model will triger the Statistics Service to run.

• This is current behavior for Smart Discovery.

• How to find User Assistance for SAP Analytics Cloud?
• Ask a question on the SAP Community!
• 2487011 - What information do I need to provide when opening incidents with SAP Analytics Cloud (Hint: Use component LOD-ANA*)

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

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 (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PR , SAC Predictive , Problem