ERP, BW/BI and Reporting


Moxie brings over 10+ years with Oracle technologies including the Oracle Apps platform, the Oracle Business Intelligence platform and the Oracle database.

Enumerating experience specific to BI projects experience we have to mention the below:
  • Designing and developing end-to-end BI solutions according to standard OLAP methodologies using Oracle Business Intelligence (OBIEE)
  • Experience in working on pre-build RPD's for Financial Analytics, Supply chain, Order Management, Procurement & Spend Analytics according to our clients’ business requirements.
  • Expertise in design and development of an OBI Metadata Repository using Oracle BI Administration Tool through layers of:
  • Physical Modeling
  • Business Modeling
  • Star Schema/Snowflake Schema Design
  • Mapping/Presentation
  • OBIEE Delivers and iBots are other modules that are under use
  • Created reports using OBIEE Answers and empowered users to navigate OBIEE Dashboards.

Moxie also brings experience with integration, configuration, migration and upgrades having recently overseen projects involving “OBIEE 10g to OBIEE 11g upgrade” and “Siebel Analytics 7.7.1 to OBIEE migration”.

Our team has installed and configured Oracle Business Intelligence Suite (OBIEE in development environment to explore the new features like:

  • Enhanced Data Mart automation
  • Microsoft Office integration
  • Oracle Reports 2.5, 6i, 8i, 10g, 11g
  • BIPublisher
  • Improved Data Visualization and
  • End User Personalization.
Client have also capitalized on our expertise in developing Reports and Dashboards using features like Pivot tables, charts, view selector, etc.

With the world of Oracle BI we bring extensive project experience with:

  • Oracle BI Server
  • Oracle BI Answers
  • Oracle BI Scheduler
  • Oracle BI Interactive Dashboard and
  • Oracle BI Publisher.
Oracle Modules to showcase would include:
  • R.10.7
  • R.11
  • R.11i
  • R.11.5.10
  • R12
  • Order Management
  • Inventory
  • Quoting
  • Service Contracts
  • Installed Base
  • General Ledger
  • Accounts Receivable
  • Accounts Payable
  • Purchasing
  • Shipping
  • Cost Management
  • Advanced Supply Chain Planner
  • Demantra
  • Bill Of Material
  • Work in Process
  • Human Resources
  • Oracle Process Manufacturing (OPM)
  • Financials
  • Payables
  • Receivables
  • Order Management
  • Workflow
  • Discoverer
  • Lease Management

SAP BW/BI/Business Objects

Right from the point of identifying reports/KPIs and other requirements then rolling BEx queries all the way through to the delivery of reports, Moxie will make the experience seamless to the client. The skills required are a combination of SAP BW/BI and SAP Business Objects and it has only been recently where people have begun to bridge the gap. Moxie has a team of professionals that have already delivered projects in the world of BW/BI combined with SAP BO reports in WebI and Dashboards formats.

Moxie’s ERP, BI and BW projects have been delivered to many in industry verticals namely:
  • Financial
  • Pharmaceutical
  • Retails
  • Manufacturing
  • Healthcare
  • Insurance
  • Transportation
This SAP Delivery experience in combination of BI/BW with Business Objects has helped us deliver project-based (small and large) results for our clients in the following areas:
  • Designing BOBJ Architecture,
  • Extensively used BEx Analyzer to build queries, queries with maps and charts and worksheets to access data from BW data targets.
  • Developed reports using BEx Analyzer and BEx Query Designer as per the requirement of the query.
  • Creating complex Xcelsius Dashboards:
  • Creating single or multi-line chart for showing tendency over a period of time (particularly used in revenue history)
  • Creating graphical representation of reports such as Bar charts, Pie charts, Column chart, and Line chart.
  • Creating complex WebI Reports
  • Modeling appropriate universes using ‘Universe Design’ depending on the need of the project
  • Using experience in Central Management Console(CMC), Central Configuration Management (CCM), Info view, Desktop Intelligence, Import Wizard, Supervisor, Reporter, and Scorecard
  • Extensive work on creating custom data sources using Infoset Query, Table/View and Function module.
  • Creating InfoObjects, DataSources, InfoSources, Data targets, Data Store Objects, Transformations, DTP’s, InfoCubes, Multi Providers and Process chains as per end user requirement.

Additionally, these BW/BI projects have spanned multiple SAP functional modules including MM-Purchasing, IM, SD, PM/QM, FI-GL/AP, AR, HR, HR-PY, ECC, CRM, SCM (Demand Planning/Supplier Network Planning), SRM and System Management Tools like CCM, CMC, Import Wizard and Publishing Wizard.

A collection in brief can be reviewed here:
  • SAP Net Weaver 2004s BW 7.3, 7.1, BW 3.5, 3.1C and 3.0B
  • Performance Optimization, BW Accelerator (BWA) & SAP HANA
  • SAP BPC, BCS and Integrated Planning
  • Business Objects BOE XI 3.1, BI 4.0, WebI, BO Analysis 4.0, BO Explorer 4.0
  • Business Objects Dashboard Designer & Xcelsius 2008
  • SAP ECC 6.0, 4.7 and 4.6C
  • Sales & Distribution (SD) & Customer Relationship Management (CRM)
  • Finance & Controlling (FICO), COPA, Profit Center & Cost Center Accounting
  • Material Management (MM) & Supplier Relationship Management (SRM),
  • Supply Chain Management (SCM), Advance Planning Optimizer (APO)
  • ABAP/4, SQL, PL/SQL, DB-Connect


Our usage of Cognos has gone much beyond the occasional reporting that it was used for in the beginning to a fully integrated Business Intelligence Applications Suite of tools. We have, accordingly, extended that usage with some of our clients to include all the following:
  • Cognos (Older versions to the latest Version 8BI to Cognos 10.x)
  • Cognos Data Manager
  • Cognos Framework Manager
  • Cognos ReportNet
  • Cognos Transformer
  • Cognos Report Studio
  • Cognos Query Studio
  • Cognos Connection
  • Cognos Impromptu
  • Cognos Access Manager
  • Cognos Scheduler
Our projects go all the way from installation, configuration and integration, to upgrades, migration and customization depending on the industry and the needs of the Clients and their customers.

Additionally, you can rely on our expertise in Cognos PowerPlay. With our expert understanding of PowerPlay Transformer and client we have helped design models and analyze Power Cubes, have been involved with administration of IWR Server, PowerPlay Enterprise Server and ReportNet Server and have delivered projects on PowerPlay User, and PowerPlay Web Reports.

Cross-Functional and Cross-Platform Experience

Key notification of Moxie’s breadth of experience is that we have done projects (more recently for one of the largest pharmaceutical companies in the US) where many different platforms were used for different report, BI/BW and dashboard publications, depending on the type of data and the audience reviewing the data. There are environments with a complex array of Oracle, Cognos, and SAP, with potentially many modules inter-connected, migrated or upgraded on a continuous basis. Only a strong team that can boast a collective experience in all of these tools can come in and bridge the gaps between these tools and what is requested by the users.

Our team brings Functional and Technical experience to:
  • Communicate with the right questions
  • Analyze your requirements
  • Build the appropriate KPIs and subsequently the data-models
  • Write the correct queries corresponding to those
  • Create the Universes as and when needed
  • And finally build the dashboards, reports, etc. in relation, to help decision-makers make the correct decisions.
  • Testing it for cross-platform use and publication (BI Launch Pad/Infoview/InfoBurst, etc.)
  • Training users on these platforms

Doing this in a cross-platform basis can rarely be achieved in one shop. Doing so simultaneously, while working on migrations, upgrades, etc. makes it even more difficult. Using different teams for different tasks would be extremely disconnected and counter-productive. Many clients are experiencing this disconnection and therefore, come to us as a holistic one stop-shop for all their BI/BW and Reporting needs.

Other BI/BW/Reporting tools we have occasionally helped clients with include:

  • Ab Initio
  • IBM InfoSphere DataStage and
  • Pervasive Software