Prepare a nested view
Place version and quarter on the same axis. In the example, all four quarters are initially visible for both plan and actual.
IBM PLANNING ANALYTICS · CUBE VIEWS · MEMBER SELECTION
Want to show every quarter for plan, but only the fourth quarter for actual? Target selection lets you choose specific combinations in a nested cube view, keeping different periods visible for each version.
Enable Target selection in the toolbar. Hold Ctrl and select the version-and-quarter combinations you need. Then right-click and choose Keep.
Place version and quarter on the same axis. In the example, all four quarters are initially visible for both plan and actual. Click Target selection in the toolbar. In the video, the data area turns light grey. Hold Ctrl and select Q1 to Q4 under plan, plus Q4 under actual. Open the context menu and choose Keep. Check the result: plan retains all four quarters, while actual shows only Q4.
IN PLANNING ANALYTICS WORKSPACE
Place version and quarter on the same axis. In the example, all four quarters are initially visible for both plan and actual.
Click Target selection in the toolbar. In the video, the data area turns light grey. Hold Ctrl and select Q1 to Q4 under plan, plus Q4 under actual.
Open the context menu and choose Keep. Check the result: plan retains all four quarters, while actual shows only Q4.
IN PRACTICE
This example follows the video. Target selection keeps the chosen combinations within the nested axis.
| Version | Visible quarters |
|---|---|
| Plan | Q1, Q2, Q3 and Q4 |
| Actual | Q4 only |
COMMON QUESTIONS
A symmetric selection shows the same quarters for every version. Target selection lets you keep specific combinations and create an asymmetric selection.
No. Keep restricts the displayed selection. Values that are not shown remain in the cube.
You can also enable target selection with F7. Hold Ctrl while clicking to select several combinations.
THE PLANNING ANALYTICS NEWSLETTER
New tutorials, useful features and selected updates on IBM Planning Analytics (TM1). Once a month, in German.
What to expect from the newsletterJUST ONE MORE STEP
Open the confirmation email and click the link. Your subscription is complete only after you confirm.
KEEP LEARNING
Florian KaiserPlanning Analytics consultantSUPPORT FOR YOUR TM1 MODEL
Want to make your reporting clearer or develop your Planning Analytics model? I can help you implement your requirements in Planning Analytics.
Discuss your project ↗