Security Profiles in Business Objects – Information Design Tool

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

Information Design Tool – connection shortcut

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.


Read more

SAP Transaction Code (TCODE) and Description (TTEXT)

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

Compatible and Incompatible objects in Business Objects

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

Reporting on SAP HANA

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

1 2 3 4 9