Call Us: 1-800-497-0151
Follow Us:

Valid Intersections

Valid Data Intersections in Oracle's PBCS

The 'Valid Intersections' tool is available in Oracle's Planning and Budgeting Cloud Service. PBCS 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:

Entity(Country)Legal EntityProduct GroupProduct
JapanAsia Pacific Legal Entity nameOnline platform, On-site platform, Hosted ServiceBusiness Management Suite, Financial Analysis tool,
CanadaNorth America Legal Entity nameOnline 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 Group (SIG).

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.


Latest testimonial

The MindStream team offers the best of application expertise and data security and system redundancy. It's the ideal solution for our needs.


Global Manufacturing Company

Planet Big Data News

 

Partner SpotLight

Oracle Exalytics

Oracle Exalytics

Built using best in class hardware, market- leading business intelligence software and in-memory database technology, Oracle Exalytics is an optimized system that delivers speed of thought analysis with unmatched intelligence, simplicity and manageability. For customers evaluating Oracle Exalytics, MindStream Analytics houses an Oracle Exalytics machine dedicated to 'sandbox' environment testing.

Oracle Profile

Share:
About Us

MindStream Analytics is a leading consulting firm focused on helping clients improve business understanding and decision making. With years of experience in the analytics and Business Performance Management area, MindStream offers services ranging from software selection and implementation to best practices for financial planning.

Contact Us
  • Address: 400 Commonwealth Ave, Unit 2
    Boston, MA 02215
  • Phone: 1-800-497-0151
  • Monday - Friday: 9:00 am - 6:00 pm
    Saturday - Sunday: Closed
Newsletter
© 2015 - 2018. MindStream Analytics. All right reserved. SiteMap