Valid Data Intersections in Oracle's PBCS
The 'Valid Intersections' tool is available in Oracle's Planning and Budgeting Cloud Service.
is a hosted version of the
Oracle Hyperion Planning and Data Management/Integration (FDMEE)
tools with a particular focus on a completely online-based interface. Users can design input and review forms to access data from certain multi-dimensional intersections, and dictate which intersections
are valid for a particular member group. When designing one of these web forms, users must either select intersections manually using hard-coded member combinations, or can simplify populating a list of
their choosing using the valid intersections tool. This tool can save countless hours of hand-picking data intersections which can sometimes require thousands of rows to be populated, and is also a much
more dynamic option.
'Valid intersections' uses an 'anchor dimension', for example entity or country, to identify the valid intersection with other dimensions. The user can select the combinations of dimensions linked to
this anchor, and when that anchor member is identified in a web form, only the intersection with the identified members will appear as valid. Using Oracle's 'Smartview', users can then choose to hide invalid
data rows, leaving the form only populated with the intersections they had selected. This allows a form to be generated using a list of the anchor dimensions, and even with the top-level parent of each
other dimension referenced in the form, only those identified as valid will appear.
Continuing with the example of an anchor country member, see the possible intersections identified below:
Asia Pacific Legal Entity name
Online platform, On-site platform, Hosted Service
Business Management Suite, Financial Analysis tool,
North America Legal Entity name
Online platform, Hosted Service
Business Management Suite
MindStream Analytics is a leading consulting and managed services firm focused on providing Business Analytics solutions to organizations. The team at MindStream has years of experience delivering innovative
solutions to maximize and provide efficiency to an organizations strategic, operational and financial management processes. MindStream Analytics can help you learn more about Oracle Hyperion Planning and
PBCS and its full scope of capabilities. Our consultants have a long top notch standing within the Hyperion community including the Oracle Application User Group's (OAUG) and Hyperion Special Interest
For more information on how MindStream Analytics can help you take your vision and transform it into a winning game plan please visit our company website at https://www.mindstreamanalytics.com or call
us at 1-800-497-0151.
Contact MindStream Analytics
Want to know more about Valid Data Intersections? Fill out the form below and we'll get back to you shortly.