3437447 - Date dimension needs to be specified with a non-null default value when importing data into model with New Model type (Model with Measures) in SAP Analytics Cloud (SAC)

• Rows with empty date (including null, zero) value are rejected while running import jobs in model with New model type (Model with Measures) 
• When setting up import for an import job in a model with New Model type (Model with Measures), it is required to specify a non-null default value for the date dimension in "Map to Facts"
• This issue does not happen to classic model.

• SAP Analytics Cloud 2024.2.8

1. Login to SAC
2. Create a model with New Model type (Model with Measures) and insert a date dimension into this model
3. Navigate to the Data Management workspace
4. Create an import job
5. Click on the button "Set Up Import" on this import job 
6. On the following "Prepare Data" page, click on the Next button after finishing the data preparation step
7. On the following "Map to Facts" page, navigate to "Unmapped" and find out the unmapped date dimension
   Scenario 1:
8. On this unmapped date dimension, click on the three dot graph button on "Drop a column" box under "Source"
   => Observe that "Set Default Value" panel would pop up and a non-null default value is required to be specified for this date dimension if there is no source column is selected to map the target date dimension.
   => Unable set default value to blank/null/zero value.
   Scenario 2:
9. For this unmapped date dimension, drag and drop a Source Column to map this date dimension
10. Finish the set up of the import job and run this import job
    => Observe that Rows with empty date value would be rejected while data refreshing

• It is expected behavior of the product. 

• The new data import architecture for model with New model type (Model with Measures) has differences to the data import for the classic account model data import in terms of features. One difference is that in this new data import process, it does not differentiate planning and non-planning model for date dimension. In both cases it doesn’t allow entering empty date in the fact table. The empty date value from the source data will be rejected.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• SAP Analytics Cloud > Learning > Guided Playlists
• SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
• Need More Help? Contact Support or visit the solution finder today!

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

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, new model type, date, empty, date range, null, reject, zero , KBA , LOD-ANA-ML-DE , SAC Data Wrangling , Problem