Can a Universe connect to multiple databases?

No. Universe will connect to only one database.

How do you define universe parameters?
The first step in creating a universe is to specify its parameters. These parameters include the definition of a universe, which is comprised of: the universe name, a description of the universe, a connection to an RDBMS. You enter universe parameters from the Universe Parameters dialog box. This dialog box also lets you set up database options, external strategies, graphic options, and print settings.

What is a database connection?
A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database. Designer provides three types of connections: secured, shared, and personal.

Read more »

What is a universe?

Universe provides a semantic layer between you and the database. It consists of classes and objects named in business terms. It is basically a mapping of table and the columns in the database to classes and objects respectively in the query panel.
Alternatively, It is logical mapping of data in business terms.

In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax.

Read more »

What is a macro?

A macro is a series of commands and functions that are stored in a Visual Basic for Applications module and can be run whenever you need to perform the task. If you perform a task repeatedly, you can automate the task with a macro. You create macros using the Visual Basic Editor.

Read more »

What are Enterprise and Workgroup modes?

Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository. The mode in which you save your universe determines whether other designers are able to access them. By default, a universe is saved in the mode in which you are already working. For example, if you launched a session in enterprise mode, any universe you save is automatically in that mode.

Read more »

What is ‘business objects’?

BUSINESSOBJECTS is an integrated query, reporting and analysis solution for business professionals that allow them to access the data in their corporate databases directly from their desktop and present and analyze this information in a BUSINESSOBJECTS document.
It is an OLAP tool that high-level management can use as a part of a Decision Support Systems (DSS).

BUSINESSOBJECTS makes it easy to access the data, because you work with it in business terms that are familiar to you, not technical database terms like SQL.

Read more »

Web Intelligence SP2: Input Controls

Web Intelligence SP2: Input Controls
With the release of XI 3.1 SP2 came quite a few new features for Web Intelligence. For the next few weeks, I will be presenting and discussing the features. In addition, I will try to provide my opinion on how the features can be used to improve the interactions with users (of the casual and power variety). For this post, I will be focusing on the new Input Controls available with Web Intelligence.

What are Input Controls?
The Web Intelligence input controls provide a quick and easy way for users to filter the content that is displayed within a Web Intelligence document. The use of filtering for a user allows them to not only cut through the information to get to what is important, but also aids the user in analyzing the information before them by determining insights that were not previously visible before a filter occurred. For example, if I am looking at a report that shows me all sales revenue by quarter and year for my many store locations then it is likely that I am not going to get to the information that I need quickly. I could use an input control available within the report to quickly filter the displayed content down to a specific year, quarter, region, or store. You could also use an input filter applied to a measure. This would allow you to use a slider control to easily see how the measure changes over time.

How do Input Controls work?
The screenshot below shows a report that displays all of the stores from the eFashion Universe with their 2005 sales revenue values in a table format. This report has been filtered using an Input Control.
more details.. Web Intelligence : Input Controls

visit new blog http://www.businessobjects-sapbo.blogspot.com

Read more »

SAP Network Blog: Bringing new innovations to the way we learn BI in 4.0

SAP Network Blog: Bringing new innovations to the way we learn BI in 4.0

Read more »