Data Cookbook specification cheat sheet: Denodo derived view

To jump start creation of a new Denodo derived view specification according to Data Cookbook best practices, copy the Template / Denodo Derived View Specification, which contains most of the necessary information.

• Creating a new specification
• Completing the specification

---

Creating a new specification

To create a new specification:

1. From the Specifications menu, select Create a specification.
2. In the "Specification Name" field, enter a name, following this naming convention:

     < Functional Area (Subject) > / < Functional Area (System) > / < Description > < DV >[,][ Desc Modifier (optional) ][ - ][  Desc Org (optional) ]
   

3. From the "Specification Type" drop-down menu, select Denodo Derived View.

4. From the "Functional Area" drop-down menu, select the primary functional area associated with this specification. Select the area from the lowest hierarchical level that correlates with the EIG system code level.

   In the "Purpose" field, enter a concise, one- to three-sentence statement of the purpose of this specification, briefly summarizing the need it addresses and the business questions it answers.

5. In the "Description" field, enter a more detailed summary of the deliverable object (for example, how the deliverable can best be used, understood, or interacted with). Interface views are data sources, and therefore will have technical descriptions to provide context and facilitate self-service reporting.

6. Click ASSIGN TO ME AND START WORKING to create the specification.

Completing the specification

To complete your new specification, fill in the Overview and Definitions tabs:

1. Select the Overview tab.

2. Below the "Overview" heading, click Edit. In the "Owner" field, enter the business sponsor for the deliverable the specification is defining.

   • For a DSI deliverable that is a report, the owner is the organizational sponsor of the charter.
   • For AM360, the owner is the Office of Budgetary Administration and Planning.
3. Under "Data System", select a data system from the drop-down list. This list has been prepopulated with systems derived from the EIG system, along with some additional reporting systems and some requested auxiliary systems. For DSI, the data system for a given specification will indicate the most closely related source of data that feeds that specification.

   For a Denodo view, select EBI DTR for the DTR1PRD database.

4. Under "Functional Areas", select a functional area. Though each specification has a primary functional area associated with its design, development, and primary data, many deliverables will contain data from more than one functional area; this is particularly true of some DSI deliverables, which may cross subject areas and contain data from multiple Data Cookbook functional areas.
5. Under "Access Details", include the following three components for DSI. Inclusion of these three components is also best practice for any interface view being exposed via Denodo:
   • Descriptive guidance on how to direct report users to access a particular report
   • Hyperlink to a published report
   • Security classification

   The standard text for a Denodo view will be the following:

   This Denodo view is published in Denodo as a derived view named <Denodo_derived_view_name>.

6. Under "Related Specifications", associate your Denodo view with related Tableau workbooks, Tableau dashboards, and Tableau extracts. As DSI data grows, these related specifications will allow transparent exposure of data sources for self-service analytics, and help users with discovery of other potentially useful related information for decision making.

7. Under "Tags", for DSI, enter the following tag types:

   • Charter: Enter DSI/<Charter name> (for instance, DSI/AM360).
   • Segment: The segment tag should match the descriptions used by the product owner, business analyst, or acceptance criteria (for instance, credit hours).
8. From the specification navigation, select the Definitions tab:
   
9. On the Definitions tab, associate all the data definitions related to this specification. Data definitions associated with the specification (here, Denodo view) should be attached on this tab.