SAP HANA variable creation example


Analytical view with parameter example

We will use a simple analytical view as an example which will guide us for the rest of the document.

The analytical view has been built from tables coming from a DWH sample schema.
The screenshots of the view and of the variable and parameters management have been realized with the HANA Studio release 1.0.25



The Customers attribute view contains information about customers of the company. The view also contains the last name, the customer country, city and education as attributes available at query time. The Customer_id is used as the key attribute for the join with the fact table. This view is defined on top of the Customer table.
The Products attribute view contains information about products. Will be presented only the product name and brand as attributes. Product_ID is the key attribute.
The fact table used here is the Sales_2006 table. There is the join between the Product_Id and the Customer_id with the attribute views and we exposed the Unit sales, Store cost and Store sales as measures.



Adding a parameter
Let's  use a couple of parameters to define a calculated measure where we can see the Store Sales in a different currency.
The target is to ask to the final user of the data to select in which currency the data has to be displayed.
First, in HANA Studio we open the Analytical view and we create a new variable.
The variable will be called “VARCURRENCY” of type currency and data type CHAR.




Finally let's define a new calculated measure called “Store_Sales_currency”.
This measure will be defined in the Expression Editor as the Store_sales measure which appears in the analytical view.



The Measure will refer to the parameter VARCURRENCY.



SAP HANA variables and parameters

Comments

  1. UnknownDecember 12, 2014 at 1:59 AM

    This comment has been removed by the author.

    ReplyDelete
  2. UnknownDecember 12, 2014 at 2:09 AM

    This article data was thus nice. that is incredibly abundant helpful on behalf of me and affected by reading. Your data is incredibly hip to full to SAP HANA ADMIN Learners. we have a tendency to area unit providing the simplest SAP HANA ADMINISTRATION on-line coaching with full-fledged IT college.Administrators will use the SAP HANA studio, for
    example, to start out and stop services, to watch the system, to piece system settings, and to manage users and authorizations. The SAP HANA studio accesses the servers of the SAP HANA info by SQL
    sap hana online training

    ReplyDelete

Post a Comment

Popular posts from this blog

SAP Dashboard Error - Cannot find the BusinessObjects Enterprise report source. (LO 26608)

<!-- Google tag (gtag.js) --> <script async src="https://www.googletagmanager.com/gtag/js?id=G-NL0CYP13VZ"></script> <script>   window.dataLayer = window.dataLayer || [];   function gtag(){dataLayer.push(arguments);}   gtag('js', new Date());   gtag('config', 'G-NL0CYP13VZ'); </script> Cannot find the BusinessObjects Enterprise report source. (LO 26608) Environment SAP BO XI 4.1 SP 5 two nodes Cluster Windows Server 2012 While refreshing dashboard (based on Live Office connection) from BI Launchpad with a no administrator user the above exception was erased. SAP says: Cause The document is not available; for example it does not exist, or it has been removed. Action Check the report path from CMS and use SetLocation in Live Office to re-define the report source. Otherwise, check if the user has sufficient rights to view the object. Solution In our case  we fixed this problem was to remo
Read more

SAP HANA Introduction

Image
SAP HANA:The future of database technology The capacity of main memory in servers has continuously increased over the years, whereas prices have dramatically dropped. Today, a single enterprise class server can hold several  terabytes of main memory. At the same time, prices for server main memory dramatically  dropped over the last few decades. This increase in capacity and reduction in cost makes it a  viable approach to keep huge amounts of business data in memory. This section discusses  the benefits and challenges. In few words you can understand SAP HANA plus  analyzing this evaluation: Typical access speeds Disk     4,000,000 ns Memory         0.4 ns Speed   10,000,000 Falling prices move processing from Disk/SSD to In-Memory In-Memory Computing The elements of In-Memory computing are not new. However, dramatically improved hardware economics and  technology innovations in software has now made it possible for SAP to deliver on its vision of the
Read more

SAP BusinessObjects 4.0 - Suite Presentation

Image
The latest Business Objects Suite, B.O. 4.0,  is suitable for every kind of user from top managers to simple clerk. It has a new  styling and unified look and feel in every tool of the suite. It garantees common query design experience across all data sources. It allows interactivity with shared charting, alerting, and search options. B.O. 4.0  has a new information design tool for heterogeneous access over all sources that represents  abstraction layer for multi-dimensional data sources. Beside it allows: A simplified, Right-Scale Deployment Enhanced scalability with virtualization and native 64-bit support Comprehensive system diagnosis and monitoring New auditing for compliance and usage analysis. New User Experience SAP BusinessObjects Mobile BI  Interactive Reports & Dashboards Allows to: Make informed decisions with instant access to personalized information Leverage existing BI investments & skills to quickly reach mobile users E
Read more