During exam development, the Subject Matter Experts (SMEs) define all of the tasks, knowledge and experience that an individual would need in order to successfully fulfill their role with the product or solution. These are represented by the objectives below and the questions on the exam are based upon these objectives.
","OVERVIEW_JOB_SKILL":"All IBM exams presume a certain amount of \"on-the-job\" experience which is not present in any classroom or Web presentation. The recommended courses and links will help you gain the skill and product knowledge represented in the test objectives. They do not teach the answers to the test questions and are not intended to do so. This information may not cover all subject areas in the certification test or may contain more recent information than is present in the exam. Taking these or any classes will not guarantee that you will achieve the certification.
","JTA_OBJECTIVE_UPLOAD_PATH":null,"JTA_SURVEY_FLAG":true,"JTA_JOB_ROLE_DESCRIPTION":"This intermediate level certification is intended for professionals who wish to validate their comprehensive knowledge of IBM Planning Analytics v2.1.x as an Analyst.
An IBM Planning Analytics v2.1.x Analyst is familiar with the 2.1.9 versions of Planning Analytics Workspace (PAW) and Planning Analytics for Excel (PAfE). The analyst is responsible for building books/views in PAW and reports in PAfE. They can navigate the tools, perform ad-hoc analysis, enter data, create sets, and develop applications and plans.
Skills
Understand multidimensional data models
Basic knowledge of MDX
Understand spreading methods and Data Entry
Proficiency in PAfE worksheet functions
Interact with cube views
Ability to format Books
Ability to customize the cube view and widgets
Develop applications and plans
Basic familiarity with Excel formulas
Ability to troubleshoot issues
","BLUEPRINT_UPLOAD_PATH":null,"SURVEY_FROM_JTA_COUNT":21,"PLANNED_ASSESSMENT_EXAM_FLAG":true,"PLANNED_SAMPLE_QUESTIONS_FLAG":true,"NUMBER_OF_LIVE_FORMS":2,"NUMBER_OF_ITEMS_PER_FORM":60,"MINIMALLY_COMPETENT_CANDIDATE":"This intermediate level certification is intended for professionals who wish to validate their comprehensive knowledge of IBM Planning Analytics v2.1.x as an Analyst.
An IBM Planning Analytics v2.1.x Analyst is familiar with the 2.1.9 versions of Planning Analytics Workspace (PAW) and Planning Analytics for Excel (PAfE). The analyst is responsible for building books/views in PAW and reports in PAfE. They can navigate the tools, perform ad-hoc analysis, enter data, create sets, and develop applications and plans.
Skills
Understand multidimensional data models
Basic knowledge of MDX
Understand spreading methods and Data Entry
Proficiency in PAfE worksheet functions
Interact with cube views
Ability to format Books
Ability to customize the cube view and widgets
Develop applications and plans
Basic familiarity with Excel formulas
Ability to troubleshoot issues
","ITEMTYPE_MULTIPLE_CHOICE":true,"ITEMTYPE_DOMC":false,"ITEMTYPE_BUILD_LIST":true,"ITEMTYPE_HOT_AREA":true,"ITEM_WRITING_TOOL_OTHER":null,"ITEM_WRITING_BEST_PRACTICE":true,"ITEM_WRITING_BEST_PRACTICE_OTHER":null,"ITEM_WRITING_TYPES":2,"ITEM_WRITING_GRAMMAR_CHECK_FLAG":true,"ITEM_WRITING_TECHNICAL_CHECK_FLAG":true,"PSYCHO_REVIEWED_ALL_FLAG":false,"PSYCHO_EVALUATE_TEN_PERCENT_FLAG":false,"PSYCHOMETRIC_REVIEWER_NAME":null,"PSYCHOMETRIC_REVIEWER_EMAIL":null,"STANDARDS_TWO_STEP_METHOD_FLAG":true,"STANDARDS_OTHER":null,"STANDARDS_OTHER_WHO":null,"STANDARDS_OTHER_DATE":null,"STANDARDS_OTHER_COMMENTS":null,"STANDARDS_SUPPORTING_FILES_UPLOAD_PATH":null,"CUTSCORE_RATING_FILE_UPLOAD_PATH":null,"FORMS_ASSESSMENT":true,"FORMS_SAMPLE_QUESTIONS":true,"FORMS_ITEMS_PER_FORM":60,"FORMS_ANCHOR_ITEMS_PER_FORM":9,"SAMPLE_EXAM_COS_KEY":null,"STUDY_GUIDE_COS_KEY":null,"TINSERTTS":"2025-03-19 04:02:29.215267","TLASTUPDTS":"2026-02-27 19:44:30.778245","FINANCE_BUSINESS_UNIT":"IBM Data and AI","FINANCE_BRAND":"Data and AI","EXAM_TYPE_ID":0,"DIVERSE_COUNTRY_BACKGROUND_FLAG":true,"EXAM_TYPE_DEVELOPING":"New exam based on existing technology","STANDARDS_JOB_ROLE_DESC":"This intermediate level certification is intended for professionals who wish to validate their comprehensive knowledge of IBM Planning Analytics v2.1.x as an Analyst.
An IBM Planning Analytics v2.1.x Analyst is familiar with the 2.1.9 versions of Planning Analytics Workspace (PAW) and Planning Analytics for Excel (PAfE). The analyst is responsible for building books/views in PAW and reports in PAfE. They can navigate the tools, perform ad-hoc analysis, enter data, create sets, and develop applications and plans.
Skills
Understand multidimensional data models
Basic knowledge of MDX
Understand spreading methods and Data Entry
Proficiency in PAfE worksheet functions
Interact with cube views
Ability to format Books
Ability to customize the cube view and widgets
Develop applications and plans
Basic familiarity with Excel formulas
Ability to troubleshoot issues
","ITEMTYPE_OTHER":false,"TARGET_PUBLICATION_DATE":"2025-06-27","PEARSONVUE_START_DATE":null,"ACTUAL_START_DATE":"2025-04-09 00:00:00.000000","FORMS_PSYCHOMETRICIAN_NAME":"Isaac Pfleger","FORMS_PSYCHOMETRICIAN_EMAIL":"isaac@cms.itemexperts.com","PEARSONVUE_SELECTION":"Publish according to business rules","ASSESSMENT_FLAG":true,"PARENT_FORMS":"Form A,Form B","GOVERNANCE_COMPLETED_FLAG":true,"WITHDRAWAL_REASON":null,"WITHDRAWAL_REASON_COMMENT":null,"PV_PUBLISH_DATE":"2025-06-27 12:15:29.447668","READY_FOR_LIVE_DATE":"2025-06-27 12:20:00.852549","UUID":"068076ee-0aee-4a76-8a20-81b5fd5f39f5","GO_LIVE_DATE":"2025-07-02 15:04:29.949427","MKTGCATEGORY":"MBDA1","EXAM_STATUS":"Live","MKTGCATEGORY_NAME":"Data, Analytics, and AI","OBJECTIVES":[{"EXAM_SERIES_CODE":"C1000-199","EXAM_OBJECTIVE_ID":0,"EXAM_OBJECTIVE_TITLE":"Planning Analytics Workspace (PAW) Books","PERCENTAGE_OF_OBJECTIVE_QUESTIONS":"32","EXAM_OBJECTIVE_DESCRIPTION":"Get ready for success with this Certification Prep Session on IBM Planning Analytics v2.1 – Analyst Professional. This session covers the key exam objectives, core concepts, and practical guidance to help candidates strengthen their skills in Planning Analytics ensuring they are well prepared to achieve the certification.
","RESOURCE_URL":"https://mediacenter.ibm.com/media/Certification%20Prep%20Session%3A%20IBM%20Planning%20Analytics%20v2.1.%20Analyst%20-%20Professional/1_7uaa6svw","RESOURCE_TYPE_NAME":"Web Resource"}]}],"RELATED_CERTS":[{"PARTNERWORLD_CODE":"C9008500","CREDENTIAL_TITLE":"IBM Certified Planning Analytics v2.1.x Analyst - Professional"}],"PREREQS":[],"ASSOC_COURSES":[{"COURSE_CODE":"V020001G","CSEMSTRNAME":"IBM Planning Analytics for End-Users"}],"ASSOC_NON":[],"ASSOC_PATHS":[{"PATH_CODE":994,"LEARNING_JOURNEY_TITLE":"IBM Planning Analytics Analyst Role","URL":"/training/learning-path/ibm-planning-analytics-analyst-role-994"}],"ASSESSMENT":"A1000-199","LANGUAGES":"English","PRICE":200,"STUDY_GUIDE_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-199_STU_stuC1000199.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T213956Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-199_STU_stuC1000199.pdf%22&X-Amz-Signature=7b81b19d9462b5941193562ef9bc5c7357cf30f22ccafa4df2f27c246ebcfcf8","SAMPLE_EXAM_URL":"https://s3-api.us-geo.objectstorage.softlayer.net/credman-prod/exam/C1000-199_SAM_samC1000199.pdf?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=88673a689335411dbbef07d4969c34c2%2F20260926%2Fus-geo%2Fs3%2Faws4_request&X-Amz-Date=20260926T213956Z&X-Amz-Expires=86400&X-Amz-SignedHeaders=host&response-content-disposition=inline%3B%20%3B%20filename%3D%22C1000-199_SAM_samC1000199.pdf%22&X-Amz-Signature=cc46948779b5f9ecd9b0bc5bff16b0f273ccb78d725621fb43fc2c7123242fef"}