hana sps07 modeling enhancements
Post on 05-Dec-2014
806 Views
Preview:
DESCRIPTION
TRANSCRIPT
What´s New? SAP HANA SPS 07Modeling Enhancements (Delta from SPS 06 to SPS 07)SAP HANA Product Management November, 2013
© 2013 SAP AG. All rights reserved. 2Public
SAP HANA SPS 07 - Modeling EnhancementsOverview
Unifying the SAP HANA Modeling Experience Enriching the model and enhancing the design capabilities
– Enhanced Semantic Properties Authoring– Improved Insight and overview in the model scenario
Enhancing Calculation Views capabilities
Modeling Productivity Enhancements Enhanced performance through background object loading Introducing Undo/Redo capabilities Propagation option for renamed and new columns New Join Properties dialog Enhanced Expression Editor (autocompletion, autoproposal, …)
Unified Editor Enhancements
© 2013 SAP AG. All rights reserved. 4Public
SAP HANA SPS 07 - Unified Model Editor Enhancements
Semantic Node – New capabilities and enhancements
Semantic Node – Column List Enhanced Semantic Properties Authoring
– Enable semantics properties for attributes and measures– Edit calculated columns– Persist order of attributes and measures– Enhanced Where-used analysis for columns,
Input Parameters, Variables, …– Output column data type properties
© 2013 SAP AG. All rights reserved. 5Public
SAP HANA SPS 07 - Unified Model Editor Enhancements
Semantic Node Column List – Semantic Type
Semantic Type Properties Enable semantics properties for attributes and measures
– Geo-Types for use with reporting clients– Date-Types– Currency and Unit-Types
> incl. conversion specifications
© 2013 SAP AG. All rights reserved. 6Public
SAP HANA SPS 07 - Unified Model Editor Enhancements
Currency and Quantity Conversion
Client and Type parameterization via Attribute All parameters for currency and quantity conversion can be linked to
another view column many input parameters can be avoided.
© 2013 SAP AG. All rights reserved. 7Public
SAP HANA SPS 07 - Unified Model Editor Enhancements
Semantic Node – Where Used References
Where Used References Enhanced Where-used analysis now supports
– Columns, Calculated Columns, Input Parameters, Variables– Called from sematic or output-pane
© 2013 SAP AG. All rights reserved. 8Public
SAP HANA SPS 07 - Unified Model Editor Enhancements
Where Used Enhancement
Where Used Analysis Enhancement Direct opening of referenced objects in Model Where-Used List Refresh action to check for changed references
© 2013 SAP AG. All rights reserved. 9Public
SAP HANA SPS 07 - Unified Model Editor Enhancements Semantic Node – New capabilities and enhancements
Semantic Node – Properties Area Default Client
– renamed values and enhanced calculation view support New Data Category property*
– Default “<empty>” | CUBE | DIMENSION Apply Privileges
– Select standard Analytic Privilege or SQL Analytic Privilege (for BW Models only with SPS 07)
Enhanced Default Schema selection dialog
*replaces multidimensional reporting flag relevant mostly for calculation views
Calculation View
Analytic View
Attribute View
© 2013 SAP AG. All rights reserved. 10Public
SAP HANA SPS 07 - Unified Model Editor Enhancements Semantic Node – View Properties
New Data Category property* Default “<empty>”
– View is not enabled for multidimensional reporting, the input to the Semantics node is defaulted with a projection node
CUBE – Enabled for multidimensional reporting, the input to the Semantics node is
defaulted with an Aggregation node (or Calculation View Star Join-node)
DIMENSION– View is not enabled for multidimensional reporting, the input to the
Semantics node is defaulted with a projection node– A calculation view of type Dimension is created
*replaces multidimensional reporting flag
© 2013 SAP AG. All rights reserved. 11Public
SAP HANA SPS 07 - Unified Model Editor Enhancements General Dialog Enhancements
Less clicks for column selection dialogs Direct Click to add Add button directly appends list Delete via delete key or delete button
Easier and clearer Join dialogs Enhanced join setting control dialog
alternative to using properties window
© 2013 SAP AG. All rights reserved. 12Public
SAP HANA SPS 07 - Unified Model Editor EnhancementsVariable and Input Parameter Enhancements
Variable & Parameter Creation Enhancements External views, tables supported for value help dialog
– In the UI you can either specify an attribute only (like today) or you specify a view / table and an attribute/column. In the latter case the value help lists all attributes/columns of the view/table.
Variable Mapping from incoming views
© 2013 SAP AG. All rights reserved. 13Public
SAP HANA SPS 07 - Unified Model Editor EnhancementsVariable and Input Parameter Enhancements
Input Parameter Creation Enhancements.
Input Type specification – Unit of Measure is now supported– Description and Short Description as value help
for currency default value
© 2013 SAP AG. All rights reserved. 14Public
SAP HANA SPS 07 - Unified Model Editor EnhancementsScenario Node Details
Choose to show column names and description.
• Column type icon indicator shown
• As default shortened Technical Name and Description is shown
• Context Menu to change display– Enable/Disable to show complete Name
(full technical name)– Enable/Disable show description
default enabled full namedisabled full name
disabled description
© 2013 SAP AG. All rights reserved. 15Public
SAP HANA SPS 07 - Unified Model Editor EnhancementsAnalytic View Enhancements
Distinct Count Measures
• Distinct Counter (Counter) type measures, can be defined for view columns (similar to calculation views)
© 2013 SAP AG. All rights reserved. 16Public
SAP HANA SPS 07 - Unified Model Editor EnhancementsData Foundation Filter Enhancements
Filter Expression Enhancements “Contains” is now supported as filter operator
Input Parameter Support for Filter on Data Foundation IP references can now also be used (typed in) or selected
from value help dialog* for filters on data foundation in Analytic and Attribute Views
*Not in Attribute view Data Foundation
© 2013 SAP AG. All rights reserved. 17Public
SAP HANA SPS 07 - Unified Model Editor Enhancements Expression Editor Enhancements
Expression Editor Enhancements Enhanced Expression Editor for Calculated Columns and Filter
expression, use CRTL+SPACE for– Autoproposal for columns, function sceletons and function
arguments, Input Parameters, …– Autocompletiton– Highlighting– Expression validation, highlighting wrong arguments, checking
for correct data types
Also for variable and input parameter default expression dialog
© 2013 SAP AG. All rights reserved. 18Public
SAP HANA SPS 07 - Unified Model Editor Enhancements Multidimensional Reporting Clients Navigation Flags
Navigational Behavior Flags for Multidimensional Reporting Clients SPS 07 new Behavior and Property “Drill Down Enablement”*
Both these flags have been combined into a single property "Drill Down Enablement" with the following possible values.
– <blank>: Not available for drill down operations and no additional flat hierarchy is generated. – Drill Down : Attribute appears as a separate dimension in the client tools and it is available
for drill down operation. – Drill Down with Hierarchy : The attribute is enabled for drill down and an additional flat
hierarchy is generated for attribute. In that hierarchy all the distinct attribute values make up the first and only level of the hierarchy. The hierarchy enables the attribute for drill down in MDX based tools.
*Replaces and combines properties "Drill down enabled" and "Hierarchy Active“
Also refer to 1934485 - Release Note for SAP HANA Modeler SPS 07
© 2013 SAP AG. All rights reserved. 19Public
SAP HANA SPS 07 - Unified Model Editor Enhancements Hierarchy Advanced Capabilities
Hierarchy Design Advanced Options (revisited) Add a Root Node
– Add an All member to the Hierarchy. – Default it is set On for level hierarchies and Off for parent-child hierarchies.
The user can now optionally turn it On or Off on either hierarchy– Note for Level Hierarchieso All member in a level hierarchy that has the name “(all)”.o With no all member, there are multiple root members at level 0.
The default member becomes the first member at level 0.
– Note for a parent-child hierarchieso If a root node is added, this member has an empty name in the hierarchy.
It does have a caption “(all)”.
© 2013 SAP AG. All rights reserved. 20Public
SAP HANA SPS 07 - Unified Model Editor Enhancements Hierarchy Advanced Capabilities
Hierarchy Design Advanced Options(revisited) User defined default member
– Default Hierarchy member can be specified to a user-defined setting.– The entry must be a fully qualified valid member unique name of the
hierarchy, else you get an error and the hierarchy cannot be instantiated. o The default member can be anywhere in the hierarchy – it just has to be a valid
member.o The entry field is plain text and is not checked or verified by the modeler.
Note: a user defined default member is implicitly used for the aggregations (when dimensions is not explicitly referenced in the query context) and appears as the default member on the slicer.
© 2013 SAP AG. All rights reserved. 21Public
SAP HANA SPS 07 - Unified Model Editor EnhancementsData Preview
Data Preview in SAP HANA Studio Optimized query generation (analysis preview), with much better performance!
New option to open the SQLEditor
New generated query code
Old generated query code
Calculation View Enhancements
© 2013 SAP AG. All rights reserved. 23Public
SAP HANA SPS 07 - Calculation View enhancementsCalculation View Scenario Layout
Scenario Layout-ing capabilities Zoom Auto-Layout Resizing of Nodes (also for ATVs, ANVs) State is saved and persisted (resized nodes and
elapse/collapse state) Alternative Flyout Tool-Palette
© 2013 SAP AG. All rights reserved. 24Public
SAP HANA SPS 07 - Calculation View enhancementsCalculation View Scenario Insight
Scenario Overview enhancements Calculation View Modeling enhancement
– Improved Insight and overview in to the model by indicating join type, cardinality and filters indicators in scenario panel
– Filter expression (mouse over)
© 2013 SAP AG. All rights reserved. 25Public
SAP HANA SPS 07 - Calculation View enhancementsChanging Calculation Views
Insertion of Nodes Better refactoring of calculation views via insertion / re-connection of nodes without loosing semantic information Connections between nodes can be deleted and new nodes inserted, while the definition of the subsequent nodes are kept
and automatically remapped, when connection to the inserted node is defined The rearrangement of nodes capabilities have been enhanced to support drop of new nodes on top of object references
within existing nodes
© 2013 SAP AG. All rights reserved. 26Public
SAP HANA SPS 07 - Calculation View enhancementsColumn Changes Propagation
Propagation of Columns Changes Renamed column names from lower nodes
can be propagated the changed name up to the sematic node
New columns added to lower nodes can be propagated up to the sematic node
Conflict Handling
© 2013 SAP AG. All rights reserved. 27Public
SAP HANA SPS 07 - Improved modeling experienceCreating Calculation Views
Calculation View authoring Overview Start with preselecting the calculation view data category,
which defaults the top output-node (can be switched later)– CUBE (aggregation-node)– DIMENSION (projection-node)
For data category CUBE and Star Join selected– New StarJoin-based calculation view scenario is modeled
(details see following slides)
© 2013 SAP AG. All rights reserved. 28Public
SAP HANA SPS 07 - Calculation View enhancementsDimension Calculation Views
Dimension-Type Calculation View View is not enabled for multidimensional reporting, the input to the
Semantics node is defaulted with a projection node A calculation view of type Dimension is created Key Attributes and Hierarchies can be specified Dynamic Input Structures using mapped parameters are supported,
of which dynamic Hierarchy structures can be composed
Usage Scenario Star-Join Calculation Views
(details see following slides)
© 2013 SAP AG. All rights reserved. 29Public
SAP HANA SPS 07 - Calculation View enhancementsDimension Calculation Views and Advanced Hierarchies Scenarios
Usage of Parameters in Hierarchies Not supported for Attribute View Hierarchies. Supported only for Calculation Views (Data Category “Dimension”)
– The calculation view defining the hierarchy maybe composed of an underlying view using parameters, these must be passed and mapped to the calculation view.
– With SPS 07 parts of the hierarchy definition itself can be made dependent on parameters. Most important use cases areo Setting Root Node values with mapped Input Parameters (Parent-Child Hierarchies)o Using parameter in calculated columns,
used to build hierarchies.
© 2013 SAP AG. All rights reserved. 30Public
SAP HANA SPS 07 - Calculation View enhancementsStar Join Calculation Views
Enhancing Calculation Views with Star Join capabilities Joining fact input data flows with multiple dimension views in a single node
– Fact Input flow can be any custom calculation flow of nodes– Other, only Calculation Views of Data Category Dimension are allowed as input
Dimension Properties– All DIM-View Attributes are automatically part of the StarJoin (incl. Hierarchies) – DIM-Views are added as shared (referenced) dimensions, changes to dimension
views are immediately available– Local hierarchies can also be defined
Measures, like Counters use the dimension reference, hence can reference to attributes hidden from the output
UseCase Make use of special Calculation View Dimension capabilities
(e.g. parameterized Hierarchies) or multiple fact-table inputImportant Note: Star Join currently cannot regarded a replacement for Analytic View capability, especially as it has not been optimized for aggregation performance yet.
© 2013 SAP AG. All rights reserved. 31Public
SAP HANA SPS 07 – Calculation View enhancementsCalculation View Properties
Session Client Property Previous to SPS 07 for calculation views the default client property wasn’t
honored correctly by the calculation– Session Client or a Fixed Client values were treated as Cross Client (Dynamic)– Note embedded conversion settings honored the default client values
With SPS 07 default client settings are honored correctly for calculation views
– For compatibility reasons, opening pre-SPS 07 calculation views are initially set to cross-client and must be explicitly set and saved as Session Client.
– Note take especially care with default client behavior and conversion settings
Also refer to 1934485 - Release Note for SAP HANA Modeler SPS 07
© 2013 SAP AG. All rights reserved. 32Public
SAP HANA SPS 07 – Calculation View enhancementsMisc. Enhancements
Other Calculation View enhancements New Icons used for Aggregation-Node, Input Parameter, Counter Restricted measure are now supported
© 2013 SAP AG. All rights reserved. 33Public
SAP HANA SPS 07 – Calculation View enhancementsScripted Calculation Views
Target Column Creation
• Copy/paste in output structure is now supported- Incl. multiple selection + move
- delete
Other Enhancements
© 2013 SAP AG. All rights reserved. 35Public
SAP HANA SPS 07 - Modeling Productivity and Developer Enhancements Open Model Performance
Better Model opening performance Loading of referenced resources
occurs in background Yellow decorators are shown
while loading
© 2013 SAP AG. All rights reserved. 36Public
SAP HANA SPS 07 – Modeling Productivity and Developer Enhancements Developer Productivity
Developer Productivity Enhancements Support for Undo/Redo from the Eclipse Toolbar for View-Editor Actions
– Undo-Tool from the Eclipse Toolbar, – Redo-Tool from the Eclipse Toolbar
Model copy/paste, original name is proposed as new name Paste is enabled on objects type folder in package
© 2013 SAP AG. All rights reserved. 37Public
SAP HANA SPS 07 – Modeling Productivity and Developer Enhancements New Validation Rules
Consolidated Model Validation Rules
• Validation Rules are evaluated, when saving and activating models
• Validation rules have been rewritten– Almost 20 dropped – Now part of 14 combined rules– Used with SAP HANA Modeler - and
SAP HANA Development-Perspective (Team Provider)
© 2013 SAP AG. All rights reserved. 38Public
SAP HANA SPS 07 - Unified Model Editor Enhancements SQLEditor Use
• SAP HANA System Toolbar- Is now always enabled (not only when catalog tree is used)
- Access to SQLEditor-Icon is enabled when working in the content tree
© 2013 SAP AG. All rights reserved. 39Public
SAP HANA SPS 07 – SAP HANA Studio
LogOff Behavior
Logon/LogOff Behavior SAP HANA Studio LogOff for SAP HANA connections can be explicitly set
– Global settings– Active LogOff from system connection
Logon-Dialog at connection initialization
© 2013 SAP AG. All rights reserved. 40Public
SAP HANA SPS 07 – SAP HANA Studio Enhancements
Renaming and Grouping of SAP HANA Studio Objects
SAP HANA Studio Eclipse Views
SAP HANA Studio Eclipse Perspectives
SAP HANA Studio Eclipse New-Dialog
SAP HANA Studio Eclipse Preferences
© 2013 SAP AG. All rights reserved. 41Public
SAP HANA SPS 07 – Other Enhancements and New CapabilitiesDecision Table Editor
Integrated Decision Table Editor Aligns with the SAP HANA Model Editor Enabled also in the SAP HANA Development perspective
© 2013 SAP AG. All rights reserved. 42Public
SAP HANA SPS 07 – Other Enhancements and New CapabilitiesAnalytic Privilege Validity
Analytic Privileges introduce new Validity Attributes
• Validity Attribute– Can be a/multiple time spans– If time span is not true, then no data is returned– Inclusion check for selected dates
© 2013 SAP AG. All rights reserved. 43Public
SAP HANA SPS 07 – Other Enhancements and New CapabilitiesAutodocumentation Enhancements
Autodocumentation Enhancements Adopting new validation rules New structure, Renamed sections and Order Icons used to visually identify objects Additional information
– General section: Fields like “Default Client”, ….– Label Column, Unit and Currency Column information– Column mapping details in Calculation Views– Filters on Columns
– Default Value expression
© 2013 SAP AG. All rights reserved. 44Public
Disclaimer
This presentation outlines our general product direction and should not be relied on in making a purchase decision. This presentation is not subject to your license agreement or any other agreement with SAP.
SAP has no obligation to pursue any course of business outlined in this presentation or to develop or release any functionality mentioned in this presentation. This presentation and SAP’s strategy and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.
This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a particular purpose, or non-infringement. SAP assumes no responsibility for errors or omissions in this document, except if such damages were caused by SAP intentionally or grossly negligent.
Thank youContact information
Christoph MorgenSAP HANA Product ManagementAskSAPHANA@sap.com
To get the best overview of what’s new in SAP HANA SPS 07, read this blog.
© 2013 SAP AG. All rights reserved. 46Public
© 2013 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
National product specifications may vary.
These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries. Please see http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark for additional trademark information and notices.
© 2013 SAP AG. All rights reserved. 47Public
© 2013 SAP AG. Alle Rechte vorbehalten.
Weitergabe und Vervielfältigung dieser Publikation oder von Teilen daraus sind, zu welchem Zweck und in welcher Form auch immer, ohne die ausdrückliche schriftliche Genehmigung durch SAP AG nicht gestattet. In dieser Publikation enthaltene Informationen können ohne vorherige Ankündigung geändert werden.
Einige der von der SAP AG und ihren Distributoren vermarkteten Softwareprodukte enthalten proprietäre Softwarekomponenten anderer Softwareanbieter.
Produkte können länderspezifische Unterschiede aufweisen.
Die vorliegenden Unterlagen werden von der SAP AG und ihren Konzernunternehmen („SAP-Konzern“) bereitgestellt und dienen ausschließlich zu Informationszwecken. Der SAP-Konzern übernimmt keinerlei Haftung oder Gewährleistung für Fehler oder Unvollständigkeiten in dieser Publikation. Der SAP-Konzern steht lediglich für Produkte und Dienstleistungen nach der Maßgabe ein, die in der Vereinbarung über die jeweiligen Produkte und Dienstleistungen ausdrücklich geregelt ist. Keine der hierin enthaltenen Informationen ist als zusätzliche Garantie zu interpretieren.
SAP und andere in diesem Dokument erwähnte Produkte und Dienstleistungen von SAP sowie die dazugehörigen Logos sind Marken oder eingetragene Marken der SAP AG in Deutschland und verschiedenen anderen Ländern weltweit. Weitere Hinweise und Informationen zum Markenrecht finden Sie unter http://www.sap.com/corporate-en/legal/copyright/index.epx#trademark.
top related