SAP Knowledge Base Article - Public

2847179 - Data Acquisition fails with error when importing data from BW BEx query with mandatory interval variables on fiscal period in SAP Analytics Cloud (SAC)

Symptom

Data Acquisition fails with error when importing data from BW BEx query with mandatory interval variables on fiscal period in SAP Analytics Cloud (SAC):

  • Provider Selection Object: Initialization Issue\tSpecify a value for variable Fiscal Year/Period (Interval)\tValue '<MMM.YYYY>' is not valid for variable Fiscal Year/Period (Interval)

Environment

  • SAP Analytics Cloud 2019.19.2

Reproducing the Issue

  1. Log on to SAC tenant.
  2. Create a model on Import BW Connection.
  3. Select Create a new query and then click Next.
  4. Search for a BW Query containing mandatory interval variable on [Fiscal Year/Period].
  5. Select values from list (key in format '<MMM.YYYY>') and then click Next.
    => Error "Provider Selection Object: Initialization Issue\tSpecify a value for variable Fiscal Year/Period (Interval)\tValue '...' is not valid for variable Fiscal Year/Period (Interval)" appears.
    => In Chrome trace, the following post data could be found in HTTP header:
    -----------------------
    {"action":"readQueryMetaData","data":{"query":"<BW query name>","queryType":"Query","variables":{...[{"function":"BETWEEN","arguments":["<YYYYMMM>","<YYYYMMM>"],"useBackendDefault":false,"useInternalKey":true}],...}}}
    -----------------------
    => The selected value '<MMM.YYYY>' is transformed to '<YYYYMMM>' unexpectedly.

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

Workaround: Enter value manually in format '<MMMYYYY>' which will not be transformed but kept same value in http header.

See Also

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

Keywords

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, SAP BW Import Data Connection, list of values, lov, mandatory, exit, customer, sap, variable, format, period, fiscal, MMM.YYYY, YYYYMMM, internal, between , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0