IBM Planning Analytics v2.1.x Analyst (C9008500) Practice Exam
Prepare for the IBM Certified Planning Analytics v2.1.x Analyst – Professional exam across the tasks an analyst actually performs — navigating cubes and views, tuning rules and feeders, working in Planning Analytics Workspace and Planning Analytics for Excel, and loading data with TurboIntegrator — with objective-mapped questions, Learn-mode feedback, and a full timed Exam mode.
Start 24-hour free trial →IBM Planning Analytics Analyst exam at a glance
- Vendor
- IBM
- Exam code
- C9008500 (also referenced as C1000-199 under IBM’s newer numbering)
- Certification
- IBM Certified Planning Analytics v2.1.x Analyst – Professional
- Level
- Professional (intermediate)
- Blueprint
- Aligned to Planning Analytics v2.1.x (PAW and PAfE 2.1.9); verify current objectives before scheduling
- Format
- Multiple choice and multiple response; knowledge-based (no hands-on labs). IBM does not publish an exact question count — roughly 60 is typical.
- Passing score
- IBM does not publish a fixed passing score for this exam
- Delivery
- Online proctored or at a test center, via IBM’s certification provider
- Prerequisites
- None formally required. Hands-on Planning Analytics Workspace experience and familiarity with cubes, dimensions, hierarchies, rules, and TM1 concepts strongly recommended.
- Retake policy
- A waiting period applies after a failed attempt; the full fee is charged for each retake
- Validity
- IBM certifications do not expire; IBM recommends staying current with newer Planning Analytics releases
Sources: IBM — Certified Planning Analytics v2.1.x Analyst - Professional · IBM Planning Analytics product page. Confirm the current exam code, format, and policies with IBM before scheduling.
About the IBM Planning Analytics v2.1.x Analyst certification
The IBM Certified Planning Analytics v2.1.x Analyst – Professional credential validates that you can use IBM Planning Analytics (the platform built on TM1) to do real FP&A work: navigate and slice cubes, build views and sets, tune rules and feeders, work in Planning Analytics Workspace (PAW) and Planning Analytics for Excel (PAfE), and keep data current with TurboIntegrator. It is an intermediate, Professional-tier exam — not entry-level — and it assumes you are already comfortable with dimension modeling and the interplay between rules, feeders, and consolidations.
The exam is knowledge-based rather than hands-on: you answer multiple-choice and multiple-response questions about how the tools behave, not lab exercises. That makes two things decisive on exam day — understanding feeder logic (which cells a rule-feeder pair actually calculates, and when) and sandbox behavior in PAW (when a sandbox value is private to the contributor versus visible to others). Both are among the most-missed topics. For the broader analyst skill set behind this exam, see the Business Analysts certification guide.
IBM Planning Analytics Analyst exam objective areas
IBM organizes this exam around the tasks an analyst performs across the Planning Analytics toolset. IBM does not publish stable public percentage weights for this version, so the areas below are described by scope rather than by an invented split — plan your study around what each covers and lean hardest into rules/feeders and sandbox behavior, which the exam tests repeatedly.
Opening cubes, building views, pivoting axes, creating static and dynamic (MDX) sets, custom hierarchies, zero-suppression, and on-the-fly view calculations.
Rule syntax, scoping, feeder logic and performance, and diagnosing rule-induced circularity with controls such as STET and SKIPCHECK.
Books, websheets, sandboxes, and the plan approvals workflow — including exactly when sandbox values stay private versus become visible after commit.
TurboIntegrator (TI) processes, chores, scheduled jobs, and error handling (ItemReject / ProcessError) to keep cube data current and resilient.
Planning Analytics for Excel (PAfE) for live-connected reporting and data entry, workflow-driven contribution, and distributing plan results to stakeholders.
Objective areas reflect the tasks in IBM’s Planning Analytics v2.1.x Analyst role. Because IBM does not publish reliable public weight percentages for this exam, none are stated here rather than risk false precision. Source: IBM — Certified Planning Analytics v2.1.x Analyst - Professional. Confirm the current objectives on IBM’s certification page before scheduling.
Who this exam is for
IBM positions this credential for analysts who already work in Planning Analytics and want to validate hands-on competence across PAW and PAfE. It is intermediate-level and task-focused:
- FP&A and financial analysts who build budgets, forecasts, and what-if scenarios in Planning Analytics and need to prove they can navigate the tools fluently.
- Business and planning analysts designing views, sets, and books to deliver the data slices planners submit against.
- TM1 and Planning Analytics practitioners tuning rules and feeders and loading data with TurboIntegrator on live models.
- Reporting specialists building live-connected PAfE workbooks and running workflow-driven contribution cycles.
If your focus is dashboards and enterprise reporting rather than planning models, IBM’s Cognos Analytics v12 Analyst credential is the closer fit; those managing the platform can look at the Cognos Analytics v12 Administrator track. For the analyst and consultant roles this certification supports, see our Career Hub.
What this IBM Planning Analytics practice exam delivers
Learn mode
Get the correct answer, the explanation, and why each other choice is wrong — immediately after each question. Best for rules and feeders, where the trap is usually whether a calculation belongs in a rule, a consolidation, or a TI process.
Exam mode
Timed, full-length simulation in the exam’s knowledge-based multiple-choice / multiple-response style, so you build pacing across all five objective areas before test day.
Scenario-based questions
Case-driven items set in realistic FP&A situations — top-N subsets, circular-rule diagnosis, sandbox isolation, month-end TI loads — that mirror how the real exam frames its questions.
Score by objective area
Results break down across cube/view navigation, rules and feeders, PAW experience, data import and maintenance, and reporting and contribution — so practice tells you exactly what to revisit.
Sample IBM Planning Analytics practice questions
Ten free questions across the five objective areas, with full explanations and source links. The complete bank is available with the 24-hour trial.
An FP&A analyst needs a view showing revenue by quarter, region, and product, filtered to the top 10 products by volume. Which Planning Analytics technique fits?
- Export the cube to CSV and filter in Excel
- Build a view with the three dimensions and apply a dynamic (MDX) subset that selects the top N by a measure
- Create 10 separate views and switch between them manually
- Rebuild the cube without the unwanted products
Show answer & explanation
Correct: B — A dynamic (MDX) subset that picks the top N by a measure. Dynamic subsets re-evaluate against live cube data, so the top-10 list updates automatically as volumes change — the intended way to do top-N filtering in Planning Analytics.
Why not the others: exporting to CSV and filtering in Excel (A) breaks the live connection; ten manual views (C) is unmaintainable and still static; rebuilding the cube (D) is destructive and disproportionate.
Source: IBM Docs — Planning Analytics 2.1.0 → Further reading: PowerKram — IBM Cognos Analytics v12 Analyst →A model needs a custom Region rollup (Country → State → Store) that differs from the default geographic grouping. Which Planning Analytics capability fits?
- Duplicate the dimension and edit the copy manually
- Ask each user to memorize the grouping
- Define a custom hierarchy on the Region dimension so users can navigate Country → State → Store without altering the base structure
- Move the data to a different cube
Show answer & explanation
Correct: C — A custom hierarchy on the dimension. Custom hierarchies provide alternate rollups on the same dimension without touching the base structure, which is exactly what an alternate Region navigation calls for.
Why not the others: duplicating the dimension (A) creates maintenance drift; relying on user memory (B) is not a modeling solution; a new cube (D) fragments the data and misses the feature entirely.
Source: IBM Docs — Planning Analytics 2.1.0 →A view shows too many empty rows because many store/product combinations have no sales. Which navigation technique improves readability?
- Delete the empty combinations from the cube
- Apply zero-suppression so rows and columns containing only zeros or nulls are hidden
- Increase the window size
- Change the font color to white to hide the zeros
Show answer & explanation
Correct: B — Zero-suppression on the view. Zero-suppression hides empty intersections at display time without changing the underlying data, cleaning up the view non-destructively.
Why not the others: deleting combinations (A) is destructive and pointless for sparse cubes; a bigger window (C) does not reduce empty rows; white font (D) only hides zeros visually and breaks on export or re-theme.
Source: IBM Docs — Planning Analytics 2.1.0 →A model calculates ‘Gross Margin = Revenue − COGS’ with a rule, but it runs slowly across large dimensions. Which rule-and-feeder practice fits?
- Remove the rule and compute manually each month
- Calculate gross margin in Excel outside the cube
- Add the rule with no feeder
- Write the rule with appropriate scope and add a matching feeder so only affected cells are recalculated rather than the whole cube
Show answer & explanation
Correct: D — Scope the rule and add a matching feeder. A feeder that matches the rule’s scope tells the engine exactly which cells to recalculate, so performance stays targeted instead of triggering broad recalculation.
Why not the others: removing the rule (A) loses automation; Excel calculation (B) forfeits the live model; a rule with no feeder (C) is the actual cause of the slow, over-broad recalculation.
Source: IBM Docs — Planning Analytics 2.1.0 → Further reading: PowerKram — Business Analysts guide →An analyst writes a rule that unexpectedly creates a circular dependency through a consolidation. Which practice resolves the issue?
- Identify the circularity, rewrite the rule so the consolidation it depends on is not also driven by the rule’s target, and apply STET or SKIPCHECK where appropriate
- Keep the rule and ignore the warnings
- Clear the entire cube and re-enter the data
- Wrap the rule in another rule to hide the warning
Show answer & explanation
Correct: A — Break the dependency and use STET/SKIPCHECK. Fixing circularity means removing the dependency loop and, where the model legitimately needs it, applying the documented STET/SKIPCHECK controls so the engine skips the checks that caused the cycle.
Why not the others: ignoring warnings (B) leaves incorrect results; clearing the cube (C) destroys data without fixing the logic; wrapping the rule (D) only hides the symptom.
Source: IBM Docs — Planning Analytics 2.1.0 →A budget owner needs to experiment with ‘what if’ figures without affecting other contributors. Which PAW capability isolates these changes until the owner commits them?
- Export the cube and work in Excel
- Create a personal sandbox so changes stay isolated until explicitly committed to the base data
- Overwrite the base data directly
- Ask every other contributor to stop working
Show answer & explanation
Correct: B — A personal sandbox. Sandbox values are private to the contributor until committed, so what-if changes never touch the base data or other users’ numbers until the owner promotes them — a distinction the exam tests directly.
Why not the others: exporting to Excel (A) leaves the live model behind; overwriting base data (C) is exactly what a sandbox exists to prevent; blocking other contributors (D) is not a real workflow.
Source: IBM Docs — Planning Analytics 2.1.0 → Further reading: PowerKram — Business Analysts guide →A plan-approval flow needs each region to submit, then a central reviewer to approve. Which PAW capability governs the submit-then-approve path?
- Track approvals informally over email
- Ask regions to paste numbers into a shared chat
- Configure an approvals workflow so submitters and approvers follow a defined path, with a state recorded per region
- Approve everything automatically without review
Show answer & explanation
Correct: C — A PAW approvals workflow. Approvals workflows enforce the submit-then-approve path and record each region’s state, giving the audit trail a formal planning cycle needs.
Why not the others: email (A) and shared chat (B) leave no governed state or audit trail; auto-approval (D) defeats the point of review.
Source: IBM Docs — Planning Analytics 2.1.0 →A monthly HR extract must load into the Headcount cube every month-end. Which Planning Analytics mechanism fits?
- Email the extract to analysts and hope they load it
- Paste the extract into cells by hand
- Skip the load and estimate the numbers
- Build a TurboIntegrator process that parses the extract and loads the cube, then schedule it with a chore on the month-end calendar
Show answer & explanation
Correct: D — A TI process scheduled with a chore. A TurboIntegrator process handles the parse-and-load, and a chore runs it on the month-end schedule — the standard automated data-maintenance pattern in Planning Analytics.
Why not the others: emailing the extract (A) and manual paste (B) are error-prone and unscheduled; estimating (C) abandons the source data entirely.
Source: IBM Docs — Planning Analytics 2.1.0 →A TI process fails intermittently on a specific record containing an unusual character. Which TurboIntegrator practice fits?
- Add error-handling logic (ItemReject / ProcessError) to log the bad record, continue the load, and alert the analyst to investigate
- Delete the bad record silently
- Let the process crash on every run
- Remove all error handling and hope it clears
Show answer & explanation
Correct: A — Add ItemReject / ProcessError handling. Proper TI error handling logs the offending record, lets the rest of the load complete, and surfaces the problem for follow-up — resilient data maintenance rather than an all-or-nothing failure.
Why not the others: silent deletion (B) hides data-quality problems; letting it crash (C) blocks the whole load; removing error handling (D) makes failures worse and undiagnosable.
Source: IBM Docs — Planning Analytics 2.1.0 →A contribution workflow needs users to edit specific cells in Excel while seeing live cube values. Which Planning Analytics reporting tool fits?
- Send a static Excel file by email each month
- Use Planning Analytics for Excel (PAfE) so contributors edit live-connected worksheets with workflow control
- Ask contributors to use sticky notes
- Rebuild each user’s spreadsheet manually
Show answer & explanation
Correct: B — Planning Analytics for Excel (PAfE). PAfE gives contributors live-connected worksheets so edits write back to the cube and reflect current values, with workflow control — the successor to the older Perspectives/CAFE Excel add-ins.
Why not the others: static emailed files (A) forfeit the live connection; sticky notes (C) are not a tool; manual rebuilds (D) don’t connect to the cube at all.
Source: IBM Docs — Planning Analytics 2.1.0 → Further reading: PowerKram — Data Preparation & Feature Engineering →Keep going: Learning & Career resources
Planning Analytics skills sit inside the wider FP&A and analytics landscape — and open onto analyst, senior-analyst, and consulting tracks. Two PowerKram hubs back this exam.
Deep dive: exam format, objective areas, study path, and recertification
Exam format and codes
This is a knowledge-based, multiple-choice and multiple-response exam — there are no hands-on labs or performance simulations. IBM does not publish an exact question count or a fixed passing score; roughly 60 questions is typical for this style of IBM exam. One point of confusion worth clearing up: IBM’s certification page uses the code C9008500, while several third-party references cite C1000-199 under IBM’s newer numbering for the same “Planning Analytics v2.1.x Analyst – Professional” credential. Confirm the exact code you are registering for on IBM’s site. See IBM’s certification page →
What the objective areas actually test
The exam spans five task areas: cube and view navigation (views, sets, custom hierarchies, zero-suppression), rules and feeders (syntax, feeder logic, circularity), Planning Analytics Workspace (books, websheets, sandboxes, approvals), data import and maintenance (TurboIntegrator processes, chores, error handling), and reporting and contribution (PAfE live-connected reporting). IBM does not publish stable public percentages for these areas on this version, so treat rules/feeders and sandbox behavior as the highest-yield study targets regardless — they recur most often and are where candidates most often slip. IBM Planning Analytics overview →
Feeders and sandboxes: the two make-or-break topics
Two subjects decide a lot of borderline scores. Feeder logic: a rule computes values, but without a matching feeder the engine either over-calculates (slow) or leaves cells un-fed (wrong or blank), so you must be able to read a rule-feeder pair and predict which cells get calculated and when. Sandboxes: a sandbox value is private to the contributor until it is committed, at which point it becomes part of the base data other users see — the exam tests that visibility boundary directly. Drill both until you can explain them without hesitating. IBM Planning Analytics documentation →
Realistic study path
Because the exam is knowledge-based but grounded in real tool behavior, pair reading with hands-on time: work in Planning Analytics Workspace and PAfE, build a view with a dynamic subset, write a rule and its feeder, create a sandbox, and run a small TI process with a chore. Then use objective-mapped practice to find weak areas and go back into the tool for those specific tasks. Study one objective area at a time, starting with rules and feeders. PowerKram Business Analysts guide →
Scheduling, retakes, and validity
The exam is delivered online-proctored or at a test center through IBM’s certification provider. A waiting period applies after a failed attempt before you can retake, and the full fee is charged for each attempt, so schedule when you are genuinely ready. IBM certifications do not expire; IBM instead recommends staying current by certifying on newer Planning Analytics releases or progressing toward administrator or architect roles. Verify current fees, scheduling, and retake rules on IBM’s site before booking. IBM certification details →
Frequently asked questions
What is the exam code for the IBM Planning Analytics Analyst certification?
IBM’s certification page uses the code C9008500 for the IBM Certified Planning Analytics v2.1.x Analyst – Professional credential. Several third-party sources also refer to it as C1000-199 under IBM’s newer numbering scheme. They describe the same credential — confirm the exact code you are registering for on IBM’s site.
How many questions is the exam and what is the passing score?
IBM does not publish an exact question count or a fixed passing score for this exam. It is a knowledge-based, multiple-choice and multiple-response test — roughly 60 questions is typical for this style of IBM exam — with no hands-on labs. Check IBM’s certification page for the current details before scheduling.
Does the exam include hands-on labs?
No. The exam is knowledge-based and does not include hands-on lab or performance-based simulations. You answer questions about how Planning Analytics Workspace, Planning Analytics for Excel, rules, feeders, and TurboIntegrator behave — so hands-on practice is valuable preparation even though the test itself is multiple choice.
What are the most heavily tested topics?
Rules and feeders, and sandbox behavior in Planning Analytics Workspace, come up repeatedly and are where candidates most often lose points. Be able to read a rule-feeder pair and predict which cells calculate and when, and know exactly when a sandbox value is private to the contributor versus visible after commit.
Does the IBM Planning Analytics Analyst certification expire?
IBM certifications do not have a fixed expiry date. However, IBM recommends staying current by certifying on newer Planning Analytics releases as they ship, or progressing toward administrator or architect credentials, since organizations often prefer credentials aligned to the most current version.
Start your free 24-hour IBM Planning Analytics practice trial
Full access to the question bank, both study modes, and score-by-objective feedback. No credit card required.
Start free trial →