ONYX REPORTING LTD.
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters
Search

Jet Enterprise - Reverse Engineer Cubes

23/1/2015

0 Comments

 
Historically, one of the barriers to even starting BI projects was the sheer volume of work that would come with it.  In the present day, many of us have custom inhouse BI solutions that are too complex to update or modify with the changing needs of our company.  We shudder to think what would happen if we needed to adjust to new business processes, change the level of granularity in a fact table, or implement new measures.

By automating ETL code generation, the Jet Data Manager, JDM, allows developers to focus on data modeling and transformation, but recreating an already finished Data Warehouse and Cube from scratch--complete with measures, dimensions, and hierarchies--may still be too significant a deterrent to invest in converting to the JDM.

With the ability to reverse engineer OLAP cubes and create the supporting DataWarehouse, the JDM reseats itself as a superior Data Automation tool, even for vendors with significant capital invested in an existing multidimensional project executed with other backend tools.


As indicated in the video, once reverse engineering is complete, developers will still need to define the ETL for data extraction and transformation.  But fortunately, the JDM has a myriad of features that will facilitate recycling existing code, including the ability to create custom views, integrate stored procedures, user defined functions and scripts.

Rebuilding your BI project using the Jet Data Manager allows the best of two worlds, you can recycle significant portions of existing code, while taking advantage of the JDM's major selling points including automatic project documentation, versioning, ease of integrating multiple datasources, scheduling tools, and of course automated ETL code generation.


Although the process of rebuilding a project may seem unpleasant, your ability to respond to user's business needs is unparalleled, and truly TIME to implement customizations is where the JDM outshines competition.
0 Comments

Your comment will be posted after it is approved.


Leave a Reply.

    Profile Picture Jae Wilson
    View my profile on LinkedIn

    Stay Informed.

    * indicates required

    RSS Feed

    Categories

    All
    Automation
    Basic Training Series
    Business Intelligence
    Connect
    Dashboard
    Data Pipeline
    Data Science
    Domo
    Excel Tricks
    Executive Training & Leadership
    Extract
    Jet Enterprise
    Jet Essentials
    New Release
    NP Function
    Onyx Reporting
    Planning
    Power Pivot
    Python
    Report Writing
    Statistics And Analytics
    TimeXtender
    Visualization

London, UK
jae@OnyxReporting.com
+44 747.426.1224
Jet Reports Certified Trainer Logo
  • Welcome
  • Services
  • Blog
  • YouTube Channel
  • Contact
  • Domo IDEA Exchange
    • Schedule
    • Call for Presenters