In SAP HANA we have 2 types of Hierarchy
1. Level Hierarchy
It’s rigid in nature, where the root and the child nodes can be accessed only in the defined order (ex: organizational sturctures)
To define a level hierarchy we need one attribute per hierarchy level.
2. Parent/Child Hierarchy
The hierarchy can be explored based on a selected parent, and there are cases where the child can be a parent. Read more
SAP In-Memory database requires the replication of data from a source system. There are three methods of data replication from source system to SAP IMDB.
If your source is ERP system then SAP recomments using SAP Landscape Transformation (SLT) Replcator. Source can also be non-SAP system. As name suggests it updates HANA system using database triggers.
While connecting to SAP source system Replication Server uses remote function call (RFC) network communication channels and for non-SAP source system it uses database connection. SAP HANA system and SAP LT Replication Server uses database connection for communication. Read more
You can use any the following approaches when linking universes:
– Kernel approach
Kernel is a German word. It means nucleus, core component or main component. As name suggests using Kernel approach core universe has all the common components and then derived universe will inherit all the core components and it will also have their own universe specific components.
Core Universe will have common data (ex: employee information) which can be used in all derived universes. Read more
You can link one or more universes which share common components such as objects, classes, joins and parameters. The univers which you link become core universe and the universe which contains a link to core universe is called derived universe. Any change made in core universe automatically propogated to the derived universe(s).
There are different ways you can link universes.
– Kernel approach
– Master approach
– Component approach Read more
In order to connect to SAP HANA database BI provides 2 types of connection drivers (ODBC and JDBC). You must first create relational connection using one of the driver. Once the connection is created and tested then you can use it to build the data foundation for your universe. Read more
New Business Objects 4.0 WEBI Features
– WEBI Interface has been redesigned
– You can copy variables, table and charts from one WEBI document into another
– Default reporting style provides additional control over formatting. Now it is stored as CSS document (WebiDefaultStyleSheet.css) Read more
Prompt for Hierarchical data : – We have a new feature in Business Objects 4.0. Now we can show hierarchical data in prompts. It makes easy for end user to see the data on same screen. When you use cascade prompts then you are dependent on previous prompts values to select the next prompt.
Image below explains all. Read more
As name suggests they are nested prompts, one prompt after another or i can also say series of prompts which will narrow the end user selection. Prompt values are dependent on previous prompt value (user selected) and only the last value is used in query.
For example: Let’s say we have heirarchy – Country -> State -> City and you want user to select city based of country and state prompt then its time to use cascade prompts. Read more
01. What is loop in Universe? Explain methodologies to resolve it.
02. What is CHASM trap and Fan trap
03. what happens if cardinality are not resolved
04. What are @functions Read more
Profitability Analysis (CO-PA)
It provides two forms of analysis. Costing based and Accont based and you can use both of these types simultaneously.
Operating Concern : It’s a multidimentional data structure for Profitability Analysis (product group, customer and region) Read more