SAP BW stands for Business warehouse (Data warehouse on SAP). The Business Information Warehouse (BW) is SAP’s architectural solution for data warehousing. It is a separate system from SAP transaction processing. No data is generated in SAP BW. It takes care of ETL and reporting both.
SAP BW History:
A group of security settings can be applied using Security Editor to a universe (.unx) which is published in the repository. Profiles are stored independently in repository from the universe and they are deleted when the universe is deleted.
There are two types of security profiles in SAP Business Objects Information Design Tool 4.x:
1. Data security and
2. Business security Read more
If you have multiple tables in your SAP Business Objects universe and you are pulling data from only two table which are linked through intermediate tables then your performance goes down as it would require multiple WHERE clauses or JOINS as it increases Join path. Shortcut Join is a join with alternative path between two tables. Read more
The shorcut connection (.cns) file is saved on local file system and it references a secured connection in a repository. It contains repository address, port number, type of connetion and an ID.
Connection shortcut is used for creating or modifying any business layer or data foundation that uses a connection stored in the repository.
There are 2 ways you can create connection shortcut.
1. File -> Publish -> Publish connection to repository.
While connection is published, it will ask you to create connection shortcut.
Five steps to create a basic univers in SAP Business Objects 4.0 using Information Design Tool (IDT)
1. Create a local Project
Use Project wizard to create universe.
Enter Project Name and Project Location
Transaction Code (TCODE) Description (TTEXT)
/SAPDMC/LSMW LSM Workbench: Initial Screen
/SAPTRX/ASAPLOG Appl. system log for event handling
/SAPTRX/ASC0AO Define App. Object and Event Types
/SAPTRX/ASC0AP Define application parameters
/SAPTRX/ASC0SCU Assign Scenario to Users
/SAPTRX/ASC0SD1 Define Solution / Scenario
/SAPTRX/ASC0SD2 Define Solution / Scenario Read more
Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. There are times when you want to run query againts summary tables rather then normal non aggregated tables because of the amount of data calculation is involved. Read more
In Web Intelligence or Desktop Reporting client sometimes it is not possible to use certain combinations of objects in data providers. These objects are called incompatible objects.
For example, Let’s say you have two contexts in your universe. Sales and Revenue and if you are trying to pull < Reservation Year > and < Revenue > objects from univese then you should not because they are incompatible as no revenue associated with a reservation. Read more
SAP IMC Studio (In-Memory Computing studio) Authorizations
SAP In-Memory Computing studio is also used for user provisioning. It allows you to create users, roles, role hierarchy and more. There are 3 Types of privileges you can create in SAP In-Memory Computing studio.
1. System privileges Read more
SAP HANA provides various interface reporting options
ODBO – (OLE DB for OLAP)
Requests are sent to the database via MDX (MultiDimensional eXpression language). Multidimensional reporting is available via Excel Pivot Tables. HANA ODBO drivers is available via the Other/Advanced option of the Data Connection Wizard.
ODBC – (Open DataBase Connectivity)
Requests are sent to the database via SQL (Structured Query Language). In early testing, Excel was *not* a good choice
for ODBC-based reporting since ODBC reporting is based
on MSQuery which has a limitation of 4,000 tables.
JDBC – (Java DataBase Connectivity)
Popular on Unix platforms Read more