Search in Key for Prompt Item



The Pennsylvania State UniversitySIMBA Hands-On Guide TITLE \* MERGEFORMAT Search in Key for Prompt Item? 2020 The Pennsylvania State University? Copyright 2020 Labyrinth Solutions, Inc. All rights reserved. Labyrinth Solutions, Inc., the LSI logo, and CampusOneTM are trademarks of Labyrinth Consulting, Inc. SAP, R/3, SAP NetWeaver, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.Search in Key for Prompt Item?Description:Search in Key allows you to find the value for any prompt fields. This is helpful when you have the ID number, but the prompt field only returns the name or description.Process Steps?PSU BI LaunchPad QA StepActionIn this example, we will search for a value in the field called Internal Order / WBS Element / Sponsored Program.1.Internal Order/WBS Element/Sponsored Program?is clicked in the Prompts window.?PSU BI LaunchPad QA StepActionWe want to find all ID numbers that end with 17. We can use the wildcard character (i.e., asterisk) in our search.2.*17?is typed into the Search Pattern field.?PSU BI LaunchPad QA StepActionWe need to make sure our search is looking in the key for the field.3.The?Search options dropdown is clicked.?PSU BI LaunchPad QAStepAction4.The?Search in Key?button is clicked.?PSU BI LaunchPad QAStepAction5.The Search button is clicked.?PSU BI LaunchPad QA StepActionThe list shows all ID numbers that end in 17. We can select the one value we need for our selection criteria. 6.The 500000000017 option is clicked.?PSU BI LaunchPad QAStepAction7.The Add (>) button is clicked.?PSU BI LaunchPad QA StepActionYou can also search in the field name. Enter your search criteria in the search field.8.500000000117 is typed into the Search Pattern field.9.The Search button is clicked.?PSU BI LaunchPad QA StepActionIn this case, we have an exact match for our search.10.5000000000117?in the Search Results is clicked.?PSU BI LaunchPad QAStepAction11.The Add (>) button is clicked.? StepActionYou can enter any remaining required selection criteria and?run the report.?Disclaimer?Alternative Format Statement This publication is available in alternative media upon request.??Statement of Non-Discrimination The University is committed to equal access to programs, facilities, admission, and employment for all persons. It is the policy of the University to maintain an environment free of harassment and free of discrimination against any person because of age, race, color, ancestry, national origin, religion, creed, service in uniformed services (as defined in state and federal law), veteran status, sex, sexual orientation, marital or family status, pregnancy, pregnancy-related conditions, physical or mental disability, gender, perceived gender, gender identity, genetic information, or political ideas. Discriminatory conduct and harassment, as well as sexual misconduct and relationship violence, violates the dignity of individuals, impedes the realization of the University’s educational mission, and will not be tolerated. Direct all inquiries regarding the nondiscrimination policy to Affirmative Action Office, The Pennsylvania State University, 328 Boucke Building, University Park, PA 16802-5901; Email: aao@psu.edu; Tel: 814-863-0471. ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download