LOGISTICS DATA GATEWAY Workshop

1
LOGISTICS DATA GATEWAY Workshop
DEFENSE AUTOMATIC ADDRESSING SYSTEM CENTER
(DAASC)
PRESENTED BY KEVIN MOE MARCH 2005
2
Items of Interest

• DAASC Mission
• What is LDG?
• Current Online Data
• LDG Framework
• LDG Web Site
• Personal Web Pages
• Functional Areas
• Reports
• OLAP
• Other Access Methods
• Points of Contact

3
DAASC Mission

• The DAASC mission is to perform as an
  interoperable gateway for the DoD Components,
  Government activities, and Foreign Military Sales
  Countries to provide value added services and to
  deliver logistics data to the appropriate
  destination, efficiently, expeditiously and
  accurately.

4
What is LDG?

• The LDG is a data warehouse that contains
  DAASC-managed data
• The LDG is optimized for informational and
  analytical processing (OLAP)
• The LDG provides easy web access to the current
  and historical data that flows through the DAASC
  and provides this data in an integrated fashion
• The LDG system is a gateway for external
  customers to extract logistics information on a
  regular basis
• The LDG enables the user to
• Analyze data and create reports
• Track requisitions
• Monitor trends and project future needs
• Extract DoD-wide information

5
Current Online Data

• Three years of MILS transactions
• Historical Lookup Data
• DoD Activity Address Codes
• Materiel Items (NSN, Part Numbers)
• Sources of Supply Codes
• Project Codes
• Routing Identifier Codes
• Joint Task Asset Visibility Cross-reference
• Service Codes
• Document Identifier Codes

6
LDG Framework
SAR
LDG Web Site
SQLNet, ODBC, JDBC, HTTP
MILS/EDI
Oracle
BOBJ Enterprise
DocID/ FieldPos
LDAP
Hyperion EIS
Hyperion Analyzer
MILRI
Data Warehouse
Meta- Data Access Layer
Crystal Reports/ Analysis
DoDAAF
Grid API, MaXI, SOAP, XML
Oracle SQLPlus
COMMRI
Oracle
MSOS
Microsoft Excel
Data Marts
SQLNet, ODBC, JDBC, HTTP
Data Stores
Information Access Tools
Multi- Dimensional Structures (MOLAP)
Data Views
ETL
Operational Data Sources
7
LDG Web Site

• Available to public
• Entry point to secure environment
• Provides access request form
• Provides alerts
• Provides latest news

https//ldg.daas.dla.mil/ldg
8
LDG Personal Web Pages

• Capabilities
• Personal Preferences
• User Favorites Area
• Search
• Filters

Search
Filters
Main Public Area
Preferences
Favorites
9
Functional Areas
Displays Microsoft Office Documents

• Logistics Transactions (MILS/EDI)
• DoD Activity Address Directory
• Logistics Information Data Service
• Military Routing Identifier
• Materiel Item/Source of Supply

Drill Down to DoDAAC
Drill Down to Logistics Transactions
10
Reports
Select Report

• Role/User-based Reports
• Lookups/Hotlinks
• Details on-demand (Drill-down)
• Exportable
• Modifiable

Prompts User
Detail Report
Summary Report
11
On Line Analytical Processing(OLAP Report)
Select Report
Each Spreadsheet provides Drilling
Display Predefined OLAP Session Report
12
On Line Analytical Processing(OLAP Session)
Define Spreadsheet
Select Type of Layout
Display Results
Change to Chart Layout
13
Other Access Methods

• Any Tool that is Oracle compatible (examples
  below)
• Business Objects Crystal Reports
• Oracle SQLPlus (SQLNet)
• Quest TOAD
• Microsoft Excel or Access
• Informatica
• Any tool that is Hyperion Essbase compatible
  (examples below)
• Microsoft Excel (with add-in)
• Hyperion Analyzer
• Business Objects Crystal Analysis

14
BOBJ Crystal Reports
Display Results
Build Report
15
BOBJ Crystal Analysis
Select Layout
Define OLAP Report
Display Results
16
Quest TOAD
Build SQL
Displays Metadata
Displays Results
17
Microsoft Excel
Oracle RDBMS query
Hyperion Essbase query
18
Informatica PowerMart
Define ETL Session
Define Data Mappings
19
Points of Contact
Access to LDG may be obtained by completing an
On-line System Access Request (SAR)
at https/ldg.daas.dla.mil/ldg and select
Register DAASC CUSTOMER SERVICE Phone
Commercial [phone] DSN 986-3247 FAX
[phone] DSN 986-3247 E-mail
ldghelp_at_daas.dla.mil
Clarissa Elmore, Project Manager
Kevin Moe, Logtec Inc.