Information Design Tool Overview and Best Practices Natasha

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 natashak@dunnsolutions. com

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 Business. Objects Partnership SAP Gold Partner (top level, partner since 1995) Utilize full SAP Business. Objects stack National coverage Comprehensive SAP Business. Objects 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 People. Soft JD Edwards EDW SAP HANA Platform Oracle, IBM DB 2, SAP Net. Weaver BW Microsoft SQL Server Tera. Data and other relational data Other data warehouses sources MS Excel Unstructured data in Social Media and Hadoop OLAP Cubes

SAP Business. Objects Business Intelligence Analysis and Exploration Dashboards Reporting Discover. Predict. Create. Build engaging experiences Share information Discover areas to optimize your business Adapt data to business needs Tell your story with beautiful visualizations Deliver engaging information to users where they need it Securely distribute information across your organization 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

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?