deFacto Product Information

deFacto

Product Information

deFacto Features & Functions

deFacto is a completely unified, OLAP-based, analysis and planning product that offers the full range of capabilities users need, including modeling, forecasting, drill-down/through, what-if analysis, reporting, and more. It empowers users who drive planning processes throughout an organization with the ability to perform real-time analysis by enabling Excel with data write-back capability. It goes far beyond the usual slicing-and-dicing of data to allow nearly-instant flash reporting of user-specific financial and operational data.

  • Input Forms
  • Reports
  • Alternate Hierarchies
  • Properties/Attributes Query-Ability
  • Maintains Native Excel Formulas and Formatting
  • Book Publication Wizard
  • Offline Support
  • Advanced Zero-Suppression
  • Formula-Based or Matrix-Based Reporting
  • Can Work with Any Analysis Services Cube
  • Drill-Through to Relational Data
  • Send and Receive Text Comments
  • Simple Out-of-the-Box Approval Structure for Contributor, Data Entry, Reviewer, and Approver
  • Ability to Completely Customize the Approval Structure
  • Based on Multiple Time Periods, Entities, Categories, and Scenarios
  • MDX Formulas
  • Foreign Currency Conversion
  • Customized Logic for Specialized Business Processes
  • Inter-Model Logic
  • Budgeting, Planning, and Forecasting
  • Consolidation
  • Inter-company Eliminations
  • Reporting
  • Create/Maintain Dimensions and Attributes
  • Create/Maintain Sets of Cubes
  • Create Alternate Hierarchies
  • Make Copies of Cubes and Sets of Cubes
  • SharePoint Monitoring & Analytics
  • Other Dashboard Tools – Standard MSAS
  • Web-Based Data Entry

deFacto is a critical component of any Microsoft-centric, BI, or Performance Management Strategy.

deFacto is a completely unified, analysis and planning product that offers the full range of capabilities users need including modeling, forecasting, drill-down, drill-through, what-if analysis, reporting, and more.

deFacto empowers users who drive the planning processes throughout an organization with the ability to perform real-time analysis by enabling Excel and Power BI with data submission capabilities to its centralized data store.

deFacto uses the full functionality of Excel to provide powerful, but easy-to-learn reporting for business users who want to analyze, organize, and use important data. It goes far beyond the usual slicing-and-dicing of data to allow nearly-instant flash reporting of user-specific financial and operational data.

deFacto complements Microsoft’s PowerBI with powerful capabilities such as cube building, user security, advanced logic, web-based data submission, and what-if, all of which can be managed by business and finance users.

deFacto enables any organization to structure and manage data using sophisticated OLAP cubes in a highly efficient, flexible, and easy-to-use manner. Its business rules engine extends deFacto’s Excel-based modeling capabilities to support the structure of any business by allowing seamless customization to meet specific needs. deFacto manages ETL and administrative functions, including role-based user security.

Seamless Integration - Moving to deFacto

deFacto is designed to appeal to clients who recognize the superior value of Microsoft technology. Customers find moving to deFacto is the best and easiest way to transition to a tool that offers critical, must-have functionality and performance, as well as an exciting future. Many SAP Business Planning and Consolidation (BPC)/OutlookSoft and Microsoft PerformancePoint Server 2007 Planning customers are attracted to deFacto because of its superior performance, scalability, support, and affordability. Since deFacto’s core technology is Microsoft-centric, it offers the added benefit of capitalizing on your investment in organization-specific assets such as models, dimensions, business rules, data structures, reports, templates, ETL, security, and others, all of which can be fully leveraged.

Other customers have transitioned from products like Hyperion and Cognos to get the additional benefit of a single, fully unified CPM product rather than just a collection of integrated products. Overall, deFacto customers realize meaningful improvements in performance and significant cost savings. In fact, they find that the total cost of a deFacto replacement is actually significantly lower than the cost of maintaining their existing applications for a single year.

Ready to See the deFacto Difference?

Provide your information & we’ll contact you to schedule a demo.