There are various ways to use the IBM Planning Analytics Workspace (PAW) rules auto-complete feature to help you create rules in your environment. For example: when referencing a specific element, you can simply type a left bracket and a single quote to see a list of selectable components. You can then click on an element to have it automatically populate into your rule.
When populated, the result will appear as a fully qualified member reference. The phrase “fully qualified” means that three parts will be defined:
- Dimension
- Hierarchy
- Member Name
For example, if I have a hierarchy in the Account dimension called “GAAP_Reporting” then a fully qualified reference to account 100100 will appear as:
[‘Account’:‘GAAP_Account’:‘100100’]
In a situation where no hierarchies are defined, the dimension name will be repeated. For example, the same account with no hierarchies would appear as:
[‘Account’:‘Account’:‘100100’]
In situations where you are not using hierarchies, this may appear redundant … and potentially confusing to new developers. You can change the appearance of the account within your rule by modifying your settings.
If the full expression is not selected, the same account will appear as:
[‘Account’:‘100100’]
Revelwood is an IBM Gold Business Partner with 25+ years of experience designing, developing, implementing and maintaining IBM Planning Analytics environments. Revelwood has helped clients in all sizes across all industries optimize and grow their use of Planning Analytics. Revelwood’s Planning Analytics team consists of experienced PA experts, including a multi-year IBM Champion.
Stay up to date with PA – sign up for our weekly Planning Analytics Tips & Tricks newsletter, subscribe to our YouTube channel, and join our IBM Planning Analytics All-Stars group on LinkedIn.
Read more IBM Planning Analytics Tips & Tricks:
IBM Planning Analytics Tips & Tricks: Search with Descendants
IBM Planning Analytics Tips & Tricks: PAW – Navigation Approaches Using Action Buttons
IBM Planning Analytics Workspace Settings: DIM Editor Page Size