Transcript TITLE

Information Design Tool
Overview and Best Practices
Natasha Kishinevsky – Business Intelligence Manager
Agenda






Introduction
SAP BI 4.x Platform Overview
UDT vs. IDT comparison
IDT – New Concepts and Terminology
Universe Creation Process
Questions
Introduction: Me
[email protected]
Introduction: Dunn Solutions Group
Chicago
Minneapolis
Raleigh
Full-service IT consulting firm
Founded in 1988
Offices
 Chicago
 Minneapolis
 Raleigh
 Bangalore, India
Bangalore
Practice Areas
Application Development
Business Intelligence
Packaged Solutions
Custom App Dev
End-to-End BI
Legal Dashboard
Mobile App Dev
Data Warehouse
Visible Visitors
Portals
Dashboards
Optical Shop Dashboard
Web Design
DI + EIM/Quality
Audience Opinion
E-Commerce
Budgeting & Planning
Training
Mobile BI
Open-Enrollment
Managed Services
On-Site + Custom
Predictive Analytics
Jumpstart/Mentoring
Selected Clients
City of Chicago
SAP BusinessObjects Partnership
SAP Gold Partner (top level, partner since 1995)
Utilize full SAP BusinessObjects stack
National coverage
Comprehensive SAP BusinessObjects training
Authorized Education Partner since 1995
Authorized Training Centers in Raleigh, NC /
Minneapolis, MN / St. Louis, MO
Agenda






Introduction
SAP BI 4.x Platform Overview
UDT vs. IDT comparison
IDT – New Concepts and Terminology
Universe Creation Process
Questions
SAP Business Intelligence Stack
Mobile Devices
Browsers
Analysis and Exploration
Dashboards
On Demand
Services
Embedded
Content
MS Office
Enterprise
Portals
Reporting
Business Intelligence Platform
Universe Semantic Layer
ERP
SAP Business Suite
Oracle E-Business
PeopleSoft
JD Edwards
EDW
SAP HANA Platform
Oracle, IBM DB2,
SAP NetWeaver BW
Microsoft SQL Server
TeraData
and other relational data
Other data warehouses
sources
MS Excel
Unstructured data in
Social Media and
Hadoop
OLAP Cubes
SAP BusinessObjects Business Intelligence
Analysis and Exploration
Dashboards
Reporting
Discover. Predict. Create.
Build engaging experiences
Share information
 Discover areas to optimize your
business
 Deliver engaging information to
users where they need it
 Securely distribute information
across your organization
 Adapt data to business needs
 Track key performance indicators
and summary data
 Give users the ability to ask and
answer their own questions
 Build custom experiences so users
get what they need quickly
 Build printable reports for
operational efficiency
 Tell your story with beautiful
visualizations
Semantic Layer: Universes
Creates a Query in
Web Intelligence
User Asks a
Business Question
Semantic Layer
Translates the
Business Question
into SQL
Agenda






Introduction
SAP BI 4.x Platform Overview
UDT vs. IDT comparison
IDT – New Concepts and Terminology
Universe Creation Process
Questions
Old vs. New: Overview
 The Universe Design Tool is supported
 The “Old” universe creation tool
 Universes created have the UNV extension
 The Information Design Tool – New Addition to the BI
stack
 The “New” and improved universe creation tool
 Universes created have the UNX extension
Old vs. New: Compatibility
Tool
IDT Universes (UNX)
UDT Universes (UNV)
Crystal Reports
X
X
Web Intelligence
X
X
Explorer
X
Dashboard Design
X
QAAWS & LO
Lumira (Visual Intelligence)
X
X
What Should I do with my “Old” universes?
Convert


Conversion
Process is
seamless and
straight
forward
Take full
advantage of
the platform
with UNX
universes
Agenda






Introduction
SAP BI 4.x Platform Overview
UDT vs. IDT comparison
IDT – New Concepts and Terminology
Universe Creation Process
Questions
New Concepts - Project
 Projects serve as Workspaces
 Connections and Connection
Shortcuts
 Data Foundation Layer
 Business Layer
 Multiple Retrievals
 Shared Projects
 Synchronize Changes with the
platform
 Collaborate on Universe
development
New Concepts - Data Foundation
Universe Structure
 Define relationships
(joins) between tables
 Multi-Source Data
Foundations
 Detect and resolve
Loops
 Create Calculated
Columns
 Create Derived tables
 Define Parameters and
Lists of Values
 Profile Data
 Create multiple views
of the data structure
New Concepts – Business Layer
 Business Layer is the
new Universe
 When published, is
combined with the
Connection and Data
Foundation to form a
UNX file
 Contains folders and
objects
 Objects can be tested
with Business Layer
Queries
New Terminology
Old Terminology
New Terms
Classes
Folders
Detail Objects
Attributes
Hierarchy
Navigation Path
Self Restricting Join
Filter
@Prompt
Parameter
Agenda






Introduction
SAP BI 4.x Platform Overview
UDT vs. IDT comparison
IDT – New Concepts and Terminology
Universe Creation Process
Questions
Universe Creation – Step by Step
New
Connection
New Project
• Insert connection in
the repository
• Add Connection
Shortcut
Data Foundation
Business Layer
•
•
•
•
•
• Add folders and
Objects
• Queries
• Publish to
Repository
Add Tables
Add Joins
Resolve Loops
Table Filters
Use Views
Universe Creation – Demo
Agenda






Introduction
SAP BI 4.x Platform Overview
UDT vs. IDT comparison
IDT – New Concepts and Terminology
Universe Creation Process
Questions
Any Questions?