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
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 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
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