2384931 - Users can't search for specific fiscal periods if 0FISCPER is used as variable in the BEx query used in BusinessObjects Cloud

SAP Knowledge Base Article - Public

2384931 - Users can't search for specific fiscal periods if 0FISCPER is used as variable in the BEx query used in BusinessObjects Cloud

Symptom

  • You can't search for specific months using the numeric values 001 or names JAN. The list will still display the full list of values available.
  • If you start typing manually in the section Value Selection and use the month number 001., you will be offered multiple times the same fiscal period.

Environment

  • SAP BusinessObjects Cloud 1.0
  • SAP Business Warehouse (BW) 7.3

Reproducing the Issue

  1. Create a query in BW using the fiscal period 0FISCPER
  2. In that query, select that as a mandatory variable
  3. In SAP BusinessObjects cloud create a new model using that BW query as source
  4. When prompted to select values, you will experince these behaviors:

You can't search for specific dates:

Typing_Variable.png

 

If you select a value and try to modify it in the area: Value Selection, you will be offered some years multiple times but missing others.

 

Selecting_Prompt.png

 

 

Cause

This is a known issue in SAP BW. The problem only occurs if you use the read mode Values in Master Data Table

Resolution

Follow the steps in note 2392093 to import the required Support Package in your SAP BW system.

See Also

Your feedback is important to help us improve our Knowledge Base Articles (KBA).
Please rate how useful you found this KBA by using the star rating facility at the top of this article.
Thank you.

Keywords

EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Hana Cloud for Planning, EPM-ODS, Cloud for Analytics, C4P, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, HCP, C4A, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJ, BOBJcloud, BOCloud., BICloud, BO Cloud , 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