Have you ever created an IBM Planning Analytics Workspace (PAW) exploration and then wanted to look at data that was not in your original set? You can open the set editor and follow the applicable steps, or you can instead simply type the element you want to select. The second option is done via the use of the “Enter Member” feature in PAW.
For example, if I had a view with a company dimension selector but only had the grand total element in my existing set then I would see the following clickable option:
However, if I know that my model contains a company element called 002 then I can input that directly by selecting “Enter member” within the context area:
You have the option to either enter a single element or a set:
- When you enter a member using the input box, the current set is ignored, and you can directly use any member. The set then changes to a single member set.
- If you are selecting a set using the input box, the named set you enter must exist.
The system will utilize the alias that is currently defined in the existing set, even if you input the element differently. For example, if I input the element called 002 then the system will convert this to an alias called Oldies.
becomes…
This approach will speed up your analyses by allowing you to skip the subset editor and directly accessing a new data point.
IBM Planning Analytics, which TM1 is the engine for, is full of new features and functionality. Not sure where to start? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. And stay tuned for more Planning Analytics Tips & Tricks weekly in our Knowledge Center and in upcoming newsletters!
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: Convert to Driver-Based Planning
IBM Planning Analytics Tips & Tricks: Excel’s WRAPCOLS Formula
IBM Planning Analytics Tips & Tricks: Fixing Repetitive Scripts