LEARN WITH US : S/4HANA Analytics!!

What it is?

S/4 HANA stands for Simple 4th Generation Business suite solutions from SAP which will run on SAP HANA. SAP HANA is one of the preferred product among the companies seeking for an optimized enterprise solution because the product has come a long way from its previous predecessors which had its transaction processing and analytical processing in different platforms, that meant more time on data output and decision making.

It is very well known as The Next Generation Business Suite and it is greatest innovation since R3 and ERP from the SAP world. It unites the software and people to build businesses to run on real-time, networked and in simple way. It has got built-in analytics for hybrid transactional and analytical applications.

SAP HANA Analytical view

SAP HANA Analytical View

Now we will create an Analytic View which combines purchase order table data with the product attribute view we created in the previous step.
In your models package create a new Analytic View.

LEARN WITH US : S/4 HANA Analytics!!

What it is?

S/4 HANA stands for Simple 4th Generation Business suite solutions from SAP which will run on SAP HANA. SAP HANA is one of the preferred product among the companies seeking for an optimized enterprise solution because the product has come a long way from its previous predecessors which had its transaction processing and analytical processing in different platforms, that meant more time on data output and decision making.

It is very well known as The Next Generation Business Suite and it is greatest innovation since R3 and ERP from the SAP world. It unites the software and people to build businesses to run on real-time, networked and in simple way. It has got built-in analytics for hybrid transactional and analytical applications.

Using Multiple Values in Input parameter for filtering in Graphical Calculation View

In the previous blog SAP HANA: Handling Dynamic Select Column List and Multiple values in input parameter have shown on how to select multiple values for filtration using "Replace" function in procedure.

In that document, we went to procedure approach, since the user needs the dynamic output based on input conditions.

But if the output is static column list, you wouldn't want to use procedure, so in this blog will be explaining on how to achieve the same functionality of handling multiple values filter condition on a graphical calculation view using "Projection".

Problem Description:

Giving the flexibility of choosing the values he wishes to see in the report and then pushing the filtration logic to the lowest level possible.

SAP HANA: Handling Dynamic Select Column List and Multiple values in input parameter

In this document we will be discussing on how to handle multiple values passed in to filter condition using “REPLACE” Function in procedure and also Dynamic SQL using Execute Immediate.

Note: We followed this approach since our reporting tool is HTML5 web dashboards and we cannot consume Variables with "Multiple Values" for the same.

A) Problem Description:

--> How to handle multiple values in filter condition ?

Example:

If we have “Region” as a filtering criterion and we have 3 Regions namely: AMR, APAC and EMEA and the user want the flexibility to select the list of regions for which he wants to analyze the data.

SAP HANA: importing and exporting Landscapes in HANA STUDIO

In this document I would like to explain about, “export” and “import” of system “landscapes”.
In our project, we have different architectures for landscapes like” quality”, ”development”, ”production”. So this can be done by adding “multiple hana systems” which connects to different server instances.
1. This feature helps to monitor the systems from single hana studio interface. In this example you can see below, that I have 2 systems named DCC and DCD. Both are connecting to 2 different server instances. Now let us see how do we “export” and “import” our landscapes. In case if you want to use a new HANA studio installed and you want to get your existing landscapes into your newly installed “studio” you can use this feature.
As shown above, you can see 2 systems named DCC and DCD.

Now go to “quick launch” and select “export” and choose “landscapes” as shown below:

SAP HANA: Using Hierarchies

In SAP HANA, we have a choice of creating 2 types of hierarchies:

1. Level Hierarchy
2. Parent Child Hierarchy 

Level Hierarchy:
     Each level represents a position in the hierarchy. For example, a time dimension might have a hierarchy that represents data at the month, quarter, and year levels.Each level above the base (or most detailed) level contains aggregate values for the levels below it. The members at different levels have a one-to-many parent-child relation. For example, Q1-05 and Q2-05 are the children of 2005, thus 2005 is the parent of Q1-05 and Q2-05.
Hierarchies and levels have a many-to-many relationship. A hierarchy typically contains several levels, and a single level can be included in more than one hierarchy.

In our example, let us take “Level Hierarchy”.