SAP Knowledge Base Article - Public

2905588 - 2020.02.13 Behavior Change to SAP Analytics Cloud (SAC) Searching in Input Controls

Symptom

SAP Analytics Cloud 2020.02.13 changed the behavior of Searching in Input Controls

Environment

  • SAP Analytics Cloud (Enterprise) 2020.02.13

Reproducing the Issue

 InputCntrlSearch.png

Cause

This behavior was intentially changed by Development based on Customer feedback.

Resolution

You can use the wildcard character (*) to control how you search for your IDs or descriptions in filters and input controls. The placement of the wildcard character determines the search results.

Note

Search only works for flat data in SAP HANA models.

Tip

For best results, display the input control data as either ID or Description, not both.

The following table shows you the search options and the expected search results.

Search parameters

Results

Example

a

Contains “a”.

Search: J

Result:

  • Janet Bury
  • James Frank
  • John Minker
  • Kiran Raj

a*

Starts with “a”.

Search: J*

Result:

  • Janet Bury
  • James Frank
  • John Minker

*a

Ends with “a”.

Search: *J

Result:

  • Kiran Raj

*a*

Contains “a”.

Search: *J*

Result:

  • Janet Bury
  • James Frank
  • John Minker
  • Kiran Raj

a*b

Starts with “a” and ends with “b”.

Search: L*d

Result:

  • Lois Wood
  • Lia Armand

a*b*

Starts with “a” and contains “b”.

Search: J*n*

Result:

  • Janet Bury
  • James Frank
  • John Minker

*a*b

Contains “a” and ends with “b”.

Search: *n*r

Result:

  • John Minker
  • Nancy Miller

*a*b*

Contains “a” and “b”.

Search: *n*r*

Result:

  • Janet Bury
  • James Frank
  • John Minker
  • Kiran Raj

Remember

The search strings don't have to be next to each other, but they do need to be consecutive: strings where “b” occurs first won't be returned.

<space>a<space>

Contains the exact string, including leading and trailing spaces.

Search: <space>of<space>

Result:

  • Cost of Goods Sold
  • Other Cost of Goods Sold
  • Cost of Product

*(1..n)

(Multiple wildcard characters)

Contains the full list, as if there was no search.

Search: **

Result:

  • Janet Bury
  • Gary Dumin
  • James Frank
  • Lois Wood
  • John Minker
  • Nancy Miller
  • David Carl
  • Ed Young
  • Kiran Raj
  • Gabriel Walton

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, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC , KBA , LOD-ANA-DES , Model, Story Design & Visualizations , Product Enhancement

Product

SAP Analytics Cloud 1.0