Best Business Intelligence

Test Hana Post2

2014-07-27T13:14:00.004-07:00

Test Hana Post2

Test Hana Post1

2014-07-27T12:51:00.003-07:00

Test Hana Post1

Sections Vs Breaks in Web Intelligence

2011-09-05T07:29:00.000-07:00

What are Web Intelligence Sections?

In Business Objects XI Web Intelligence sections are easily created and often even by mistake (drag a single object to the report and you will see what I mean). They can be made more complex and wider (taller) with greater scope. Sections apply to the entire horizontal area of page over which they are defined (best viewed/managed in Structure View). In other words, you can have multiple tables, graphs, cells in a section if you want. The section is also defined usually by a dimension so that each unique value of the dimension becomes an instance of the section in which all content placed in the section is repeated. All of the content in that instance is filtered to that unique dimension value.

So what are Breaks then?

A break is something that I rarely seem to get these days. No seriously, a Business Objects Webi report break has similar properties to those of a section. It is a sort of pivot around each distinct value of a dimension or formula. However, a break occurs only in a single table/block. Breaks cause the table to be broken up in instances of the break, sub-tables usually. These are easily created, usually by highlighting the desired dimension’s column and then right-clicking or section the top-menu icon.

A Distinction between the Two

Sections can be applied and formatted to function more or less like breaks; however, breaks can never function as sections do, they are limited to the scope of the block on which they are defined. I tend to prefer sections as they allow for greater flexibility and they seem to have more options. Nevertheless, breaks can be excellent for grouping relatively small amounts of data and then aggregating the measures at the bottom of the table.

Installing SAP Business Objects XIR 3.0 on Server-Client Architecture

2011-08-28T17:25:00.000-07:00

This post discusses the steps to install BO XIR 3.0 on a VMware server and connect to it from your laptop machine.
Note: I have used MS SQL Server 2008 as by back end database server for CMS and Audit databases.

VMWare Installation:
Install VMWare and use Bridged setting rather than NAT, you should be able to ping "from and to" the new virtual machine individually.

On the VMWare Server:
1- Create a user in SQL Server 2008 with read and write access to the database server.
2- Create CMS and AUDIT databases
3- Create ODBC connections for both CMS and Audit databases.
4- Install BO with the Web Application Server (by default Apache TomCat)

After the installation is complete make sure BO is working fiine.

On the Client Side (laptop machine):
1- Install client tools for Business Objects (by default, during the setup BO will ask you to install the client tools only)
2- Specify the CMS name (system name of your VMware server) to the client tools and connect to the server BO instance.
Eg. for Infoview to access the BO server, type http://CMSname:8080/InfoViewApp.
To access CMC, type http://CMSname:8080/CmcApp

3- So now for example you create a universe on the server side, and you also create are report on that and want the client machine to view the report. The server can export the report and the client will be able to see the report in Infoview. However, if the client machine wants to refresh or edit the report, there will be an error message displayed. This is becuase the client machine has no connection with the database.

So remember on the server machine you created an ODBC connection with the databases, that same ODBC connection needs to be created on the client machine as well, the name of the ODBC should remain the same.

Broadcast Agent in Business Objects

2011-08-22T13:08:00.000-07:00

Broadcast Agent Publisher Interview Questions

Broadcast Agent Publisher 5.5

What is Broadcast Agent (Latest version 5.5)?

BROADCAST AGENT empowers BO and Webi users to automatically process and publish their BO documents via the repository, an intranet, or an extranet open to the World Wide Web.

How do you send a document to BCA?

General tab: Allows you to specify the Server, document's priority and to write a description of the document.
Actions tab: Allows you to specify the actions that you want Broadcast Agent to perform, e.g., refresh and print, save in .rtf, .txt or .pdf format, publish on channels, Report busting etc
Categories tab: Allows you to select categories for the document you are sending.
Scheduling tab: Allows you to specify the document processing start date, expiration date, schedule and File Watcher.
Distribution tab: Allows you to specify who will receive the document and the method of distribution: via the file system, a web server, or the BusinessObjects repository.

What is File Watcher?

File Watcher is the Broadcast Agent feature that permits the processing of tasks when and only when a specified file is present in its specified location.

The File Watcher gives you control over when Broadcast Agent processes the document.

What kind of file can you use?
You can use - text, rtf, Business Objects files
Where can the file be located?
The file can be located wherever you want--on a server, on the client or on a file system--as long as the Broadcast Agent machine can access the file where it has been defined.
What happens if Broadcast Agent can't find the file?
If the Broadcast Agent can't locate the file at task execution time, it simply doesn't run the task.
What is Report bursting?

Report bursting means refreshing the document with the user profile of each recipient.

What is Broadcast Agent Publisher?

Broadcast Agent Publisher is a server-based product that allows you to broadcast information by email and to manage the delivery of the emails.

BROADCAST AGENT PUBLISHER adds functionality to BROADCAST AGENT, a product that allows BUSINESS OBJECTS and WEB INTELLIGENCE users to process and publish their business intelligence documents automatically via a repository, an intranet, an extranet and the Internet.

Business ObjectsBroadcast Agent Publisher provides fast, personalized, and intelligent information delivery allowing you to easily and quickly deliver subscription based information with the minimal amount of IT resources, to many thousands of information consumers, via email based distribution mechanisms.

Why is Broadcast Agent Publisher Needed?

BCA provides BO customers with several ways to update and share reports through:
1) The BUSINESS OBJECTS repository (2) A web site (3) A file server

What are the features of Broadcast Agent Publisher?

• Email-based broadcasting
The distributions of key information, or notification of its availability, by email Publications.
Ex: You can send a sales report to every member of the marketing department every Monday.
• Subscription-based publications
Recipients can subscribe to the publications that are the most useful to them, and can choose how often they want to receive them.
Ex: Your customers can receive personalized information by email every Monday morning.
• Mass mailing
Ex: With an extranet deployment, you can send a promotional message to every customer who spent more than $100 last month.
• Recipient groups
Grouping recipients makes it easier to manage the broadcasting of publications to a lot of email addresses.
Ex: If you decide to change the report that the sales department receives each week, you need only select a single group that contains all the email addresses
• Report scheduling
You can specify when you want publications to be sent, and allow the recipients to choose when they want to receive them.
• Single pass report bursting
The source document is refreshed against the database once, and then filtered for each recipient.
• Report personalization
From a single source document, you can tailor the publications you send so that each recipient receives only the data that is of specific relevance to him or her.

What is Publication?

Publication is an email that is distributed to a range of recipients.

Universe Designer Interview Questions

2011-08-22T13:06:00.001-07:00

Universe Related Questions

1) What is a Universe?
Universe is a semantic layer that isolates you from the complexities of the database. A universe maps to data in the database in everyday terms that describe your business situation. Universes are made up of classes and objects. For example, the objects in a human resources universe would be Names, Addresses, Salaries. Classes are logical groupings of objects. Each class has a meaningful name, such as Vacation (for objects pertaining to employee vacations). Each object maps to data in the database and enables you to retrieve data for your reports.

2) How do u export universe to repository?You make a universe available to Web Intelligence users and other designers by exporting a universe to the repository. When you export a universe the universe is: Moved to the selected universe folder on the repository file system and Created in the Central Management System (CMS). Each time the universe is exported to the repository, the universe version in the CMS is updated. Exporting a universe to the repository involves following steps:
1. Select File > Export. The Export Universe dialog box appears.
2. Select a universe folder from the folder drop down list box. (or) Click the Browse button and select a universe folder in the folder browser.
3. If you want to lock the universe, double-click the universe name.
4. Click a group in the Groups list box. This is the user group that uses the exported universe.
5. Click a universe in the Universes list box. The Universes list box shows the names of the active universes.
6. If you want to export other universes that are not open, click the Add Universe button, and then use the browser to select the other universes.
7. Click
3) What is Strategies?
A strategy is a script that automatically extracts structural information from a database or flat file. Strategies have two principle roles:
• Automatic join and cardinality detection (Join strategies)
• Automatic class, object, and join creation (Objects and Joins strategies)
Strategies can be useful if you want to automate the detection and creation of structures in your universe based on the SQL structures in the database. There exits two types of strategies:
-Built in strategy is the Default strategy shipped with Designer. Built in strategies cannot be customized.
-External strategy: User defined script that contains the same type of information as a Built in strategy, but customized to optimize information retrieval from a database.
4) What is a derived table?
Derived tables are tables that you define in the universe schema. You create objects on them as you do with any other table. A derived table is defined by an SQL query at the universe level that can be used as a logical table in Designer. Derived tables have the following advantages:
• Reduced amount of data returned to the document for analysis.
• Reduced maintenance of database summary tables. Derived tables can, in some cases, replace statistical tables that hold results for complex calculations that are incorporated into the universe using aggregate awareness.
Derived tables are similar to database views, with the advantage that the SQL for a derived table can include prompts.

5) What is Join Path Problems?
A join path is a series of joins that a query can use to access data in the tables linked by the joins. Join path problems can arise from the limited way that lookup and fact tables are related in a relational database. The three major join path problems that you encounter when designing a schema are the following:
• Loops: Returns too few rows. Joins form multiple paths between lookup tables.
• Chasm traps: Returns too many rows. Many to one joins from two fact tables converge on a single lookup table. This type of join convergence can lead to a join path problem called a chasm trap.
• Fan traps: Returns too many rows. A one to many join links a table which is in turn linked by a one to many join. This type of fanning out of one to many joins can lead to a join path problem called a fan trap.
6) What is a Lookup Table?
A lookup (or dimension) table contains information associated with a particular entity or subject. For example, a lookup table can hold geographical information on customers such as their names, telephone numbers as well as the cities and countries in which they reside. In Designer, dimension and detail objects are typically derived from lookup tables.
7) What is a Fact Table?
A fact table contains statistical information about transactions. For example, it may contain figures such as Sales Revenue or Profit. In a universe, most but not all, measures are defined from fact tables.
8) What are Contexts?
Contexts are a collection of joins which provide a valid query path for Web Intelligence to generate SQL. Contexts are used in:
• Solving loops:

• Solving chasm traps.
• Assisting in some solutions for fan traps.
• Assisting in detecting incompatibility for objects using aggregate awareness.

9) How can we detect chasm trap?
Detect Contexts examines the many to one joins in the schema. It picks up the table that receives converging many to one joins and proposes contexts to separate the queries run on the table. This is the most effective way to ensure that your schema does not have a chasm trap.

10) How Do You Detect a Fan Trap?You cannot automatically detect fan traps. You need to visually examine the direction of the cardinalities displayed in the table schema. If you have two tables that are referenced by measure objects and are joined in a series of many to one joins, then you may have a potential fan trap.

11) How does a context resolve a loop?

A context resolves a loop by defining a set of joins that specify one specific path through tables in a loop. It ensures that joins are not included from different paths within the same SQL query.

12) How Do You Resolve a chasm Trap?
To resolve a chasm trap you need to make two separate queries and then combine the results. Depending on the type of objects defined for the fact tables, and the type of end user environment, you can use the following methods to resolve a chasm trap:
• Create a context for each fact table. This solution works in all cases.
• Modify the SQL parameters for the universe so you can generate separate SQL queries for each measure. This solution only works for measure objects. It does not generate separate queries for dimension or detail objects.

13) How Do You Resolve a Fan Trap?
There are two ways to solve a fan trap problem.
• Create an alias for the table containing the initial aggregation, then use Detect Contexts (Tools > Detect Contexts) to detect and propose a context for the alias table and a context for the original table. This is the most effective way to solve the fan trap problem.
• Altering the SQL parameters for the universe. This only works for measure objects.
14) What is a microcube?
When you create a measure you must specify the way the aggregate function will be projected onto a report. Returned values for a measure object are aggregated at two levels of the query process:
• Query level. Data is aggregated using the inferred Select statement.
•Microcube Level: A microcube is a conceptual way to present the data returned by a query before it is projected onto a report. It represents the returned values held in memory by a Business Objects reporting product. The block level is the 2 dimensional report that a user creates with the returned data. A user can choose to use all, or only some of the data held in the microcube to create a report. A user can also do aggregate functions on the returned values in the microcube (local aggregation) to create new values on a report.
15) What are @Functions?
@Functions are special functions that provide more flexible methods for specifying the SQL for an object. @Functions are available in the Functions pane of the Edit Select box for an object. @Functions are very flexible. Depending on what you want to achieve, you can use any @function in either a Select statement, or a Where clause.

@Aggregate_Aware: The @Aggregate_Aware function allows an object to take advantage of tables containing summary data in the database. If your database contains summary tables and you are running queries that return aggregate data, it is quicker to run a Select statement on the columns that contain summary data rather than on the columns that contain fact or event data.

@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))

@Prompt: You can use the @Prompt function to create an interactive object. You use a @Prompt function in the Where clause for an object. It forces a user to enter a value for a restriction when that object is used in a query. When the user runs the query, a prompt box appears asking for a value to be entered. @Prompts are useful when you want to force a restriction in the inferred SQL but do not want to preset the value of the condition.

@Prompt(‘message’,‘type’,[lov],[MONOMULTI],[FREECONSTRAINED])

@Select: You can use the @Select function to re-use the Select statement of another object. When the @Select function is used in the Select statement of an object, it specifies the path of another object in the universe as a parameter of the @Select function, in the form Class_Name\Object_Name. This then acts as a pointer to the Select statement of the referenced object.

@Select(Classname\Objectname)

Note:
When you use @Select and @Where functions, one object now depends on another in the universe. You have created a new object dependency. When one object is deleted, the other object using the @Select or @Where function needs to be manually updated.

@Where: You can use the @Where function to re-use the Where clause of another object. When the @Where function is used in the Where clause of an object, it specifies the path of another object in the universe as a parameter of the @Where function, in the form Class_Name\Object_Name. This then acts as a pointer to the Where clause of the referenced object. Using the Where clause creates a dynamic link between two objects. When the Where clause of the original object is modified, the Where clause of the referencing object is automatically updated.

16) What is multidimensional analysis?
Multidimensional analysis is the analysis of dimension objects organized in meaningful hierarchies. Multidimensional analysis allows users to observe data from various viewpoints. This enables them to spot trends or exceptions in the data. A hierarchy is an ordered series of related dimensions. An example of a hierarchy is Geography, which may group dimensions such as Country, Region, and City.
In Web Intelligence you can use drill up or down to perform multi dimensional analysis.
17) What are external strategies?
An external strategy is an SQL script stored externally to the .UNV file, and structured so that it can be used by Designer to automate object or join creation, and table detection tasks in a universe. External strategies are stored in an external strategy file with the extension STG. External strategy files are in XML format. There is one for each supported RDBMS.

18) What is Aggregate Awareness? Aggregate awareness is a term that describes the ability of a universe to make use of aggregate tables in a database. These are tables that contain pre-calculated data. You can use a function called @Aggregate_Aware in the Select statement for an object that directs a query to be run against aggregate tables rather than a table containing non aggregated data. Using aggregate tables speeds up the execution of queries, improving the performance of SQL transactions.

The reliability and usefulness of aggregate awareness in a universe depends on the accuracy of the aggregate tables. They must be refreshed at the same time as all fact tables. A universe that has one or more objects with alternative definitions based on aggregate tables is said to be “aggregate aware”. These definitions correspond to levels of aggregation. For example, an object called Profit can be aggregated by month, by quarter, or by year. These objects are called aggregate objects. Queries built from a universe using aggregate objects return information aggregated to the appropriate level at optimal speed.

@Aggregate_Aware(sum(agg_table_1), ... sum(agg_table_n))
19) What are incompatible objects?
You must now specify the incompatible objects for each aggregate table in the universe. The set of incompatible objects you specify determines which aggregate tables are disregarded during the generation of SQL. With respect to an aggregate table, an object is either compatible or incompatible. The rules for compatibility are as follows:
• When an object is at the same or higher level of aggregation as the table, it is compatible with the table.
• When an object is at a lower level of aggregation than the table (or if it is not at all related to the table), it is incompatible with the table.
20) What is a restriction set?
A restriction set is a named group of restrictions that apply to a universe. You can apply a restriction set to a selected group or user account for a universe. When users connect to a universe, the objects, rows, query types, and connection that they use in the universe are determined by their applied restriction set. You can create, edit, and delete a restriction set at any time once the universe has been exported to the CMS. You can create multiple restriction sets depending on the query needs of a target user group.
21) What are linked universes?
Linked universes are universes that share common components such as parameters, classes, objects, or joins. When you link two universes, one universe has the role of a core universe, the other a derived universe. When changes are made in the core universe, they are automatically propagated to the derived universes.
22) What is a core universe?
The core universe is a universe to which other universes are linked. It contains components that are common to the other universes linking to it. These universes are called derived universes. The core universe represents a re-usable library of components. A core universe can be a kernel or master universe depending on the way the core universe components are used in the derived universes.
23) What are derived universes?
A derived universe is a universe that contains a link to a core universe. The link allows the derived universe to share common components of the core universe:
• If the linked core universe is a kernel universe, then components can be added to the derived universe.
• If the linked core universe is a master universe, then the derived universe contains all the core universe components. Classes and objects are not added to the derived universe. They can be hidden in the derived universe depending on the user needs of the target audience.
24) How are universes optimized?
Query time can often be shortened by optimizing a universe. There are several ways you can optimize a universe:
• Optimizing the Array Fetch parameter in the Universe Parameters.
• Allocating a weight to each table.
• Using shortcut joins.
• Creating and using aggregate tables in your database.

Table weight is a measure of how many rows there are in a table. Lighter tables have less rows than heavier tables. By default BusinessObjects sorts the tables from the lighter to the heavier tables. The order in which tables are sorted at the database level depends on your database. For example, Sybase uses the same order as BusinessObjects, but Oracle uses the opposite order. The SQL will be optimized for most databases, but not for Oracle where the smallest table is put first in the sort order. So, if you are using an Oracle database, you can optimize the SQL by reversing the order that BusinessObjects sorts the tables. To do this you must change a parameter in the relevant PRM file of the database.
25) Different ways to link universes?
The following approaches when linking universes:
• Kernel approach
• Master approach
• Component approach

Kernel approach: With the kernel approach, one universe contains the core components. These are the components common in all universes. The derived universes that you create from this kernel universe contain these core components as well as their own specific components.

Master approach: The master approach is another way of organizing the common components of linked universes. The master universe holds all possible components. In the universes derived from the master, certain components are hidden depending on their relevance to the target users of the derived universe. The components visible in the derived universes are always a subset of the master universe. There are no new components added specific to the derived universe.

Component approach: The component approach involves merging two or more universes into one universe. The Sales universe below was created by merging two universes: Part 1 and Part
26) Explain about detail objects?
Dimensions are focus of analysis in a query. A dimension maps to one or more columns, functions in the database that are key to a query. Detail Objects provides descriptive data about a dimension. A detail is always attached to a dimension. It maps to one or more columns or functions in the database that provide detailed information related to a dimension. One cannot drill on details nor link on details when linking multiple data providers. While Customer ID would be a dimension, customer name, address, phone and soon should be details.
27) What is business objects repository?
Business Objects Repository:
Ø It is a semantic layer which stores the BO Users and their privileges.
Ø Repository means set of database tables, Business object store security information e.g user, group, access permission, user type etc. , universe information e.g. objects, classes, table name, column name, relationship etc and document information.
Ø Repository contains data accounts with three domains in each one type. You can create the repository anywhere. The security domain has the user security info and other domains address.
28) What are domains?
Domain is nothing but logical grouping of system tables. There are three domains usually in a basic setup they are Secure, Universe, Document. In 6.5 Universe are situated in one domain, Reports in one domain and Supervisor.

29) When is the Repository created?
In 5i/6i versions repository is created after installing the software, whereas in XI version a repository is created at the time of installation.

Sections Vs Breaks in Web Intelligence

2011-08-22T13:03:00.003-07:00

What are Web Intelligence Sections?

So what are Breaks then?

A Distinction between the Two

Merged Dimensions in Web Intelligence

2011-08-22T12:57:00.000-07:00

Merged Dimensions is a feature introduced in Business Objects in XI R2 release. How does it help us?

Linking Universe in SAP Business Objects XI 3.1

2011-08-22T12:51:00.000-07:00

Business Objects can only link universes that are connected to a single repository or in other words BO can only like universes that are connected to a single database server machine. No two universe can be linked if the databases are different. Please see the error message prompted by BO when linking 2 universes from different physical databases.

In order to merge all the datasources , Data Federator can be used which merges all the datasource together and a universe can be created on the target virtual table. OR data can be merged at the WEBI, DESKI, Crystal reports, level.

In BO 4.0 Universe designer is embedded with Data Federator merging capabilities hence in BO 4 a Universe can be connected to multiple databases. Universe Designer in BO 4 is called 'Information Design tool'.

ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

2011-08-21T13:01:00.001-07:00

Symtompts of the Problem:
---------------------------
Whenever you try to conenct to database by providing SYS user name and password it retuens error.
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER

Cause of The Problem:
--------------------
This is because of the parameter O7_DICTIONARY_ACCESSIBILITY settings to FALSE.

Access to dictionary objects is restricted to the users with the system privileges SYSDBA and SYSOPER. Connecting as SYSDBA gives a user unrestricted privileges to perform any operation on a database or the objects within a database. Data dictionary objects is under SYS schema and is protected by O7_DICTIONARY_ACCESSIBILITY to FALSE settings.

Workaround Example:
---------------------
1)Try to connect by user sys without sysdba privilege.

SQL> conn sys/a
ERROR:
ORA-28009: connection as SYS should be as SYSDBA or SYSOPER
Warning: You are no longer connected to ORACLE.

2)Connect as sysdba and change O7_DICTIONARY_ACCESSIBILITY
SQL> conn / as sysdba
Connected.
SQL> SHOW PARAMETER O7_DICTIONARY_ACCESSIBILITY
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY boolean FALSE

SQL> ALTER SYSTEM SET O7_DICTIONARY_ACCESSIBILITY=TRUE scope=spfile;
System altered.

3)Since O7_DICTIONARY_ACCESSIBILITY is static parameter restart is necessary.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup
ORACLE instance started.
Total System Global Area 167772160 bytes
Fixed Size 2019288 bytes
Variable Size 109051944 bytes
Database Buffers 50331648 bytes
Redo Buffers 6369280 bytes
Database mounted.
Database opened.

4)Now connect as sys with only password.

SQL> conn sys/a
Connected.

SQL> show parameter O7_DICTIONARY_ACCESSIBILITY
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
O7_DICTIONARY_ACCESSIBILITY boolean TRUE
5)Though you are SYS user but you have not currently have SYSDBA privilege. So, you can't do SYSDBA privilege tasks.

SQL> shutdown immediate;
ORA-01031: insufficient privileges

SQL> show user
USER is "SYS"

Reference: http://arjudba.blogspot.com/2008/05/ora-28009-connection-as-sys-should-be.html

Password Protecting MS Excel 2007 Document

2011-08-07T15:22:00.000-07:00

In order to password protect MS Excel 2007 Document, follow the steps below:

Create your Excel 2007 spreadsheet.
Click the Microsoft Office Icon.
Click Save As and pick Excel Workbook.
Click the Tools button (in the lower left side of the Save as prompt).
Click General Options.
Set a password to open and modify your spreadsheet.
Click OK and reenter your password.

Always keep a back up of you excel sheet as it is not delete protected, only password protected :)

Download all Gmail account emails to Outlook

2011-06-14T13:05:00.000-07:00

To download all emails from Gmail account, goto the Gmail account settings, Forwarding and POP/IMAP, check Enable POP for all mail (even mail that's already been downloaded).

Now goto Outlook and you will be able to download all the emails from your Gmail Account.

Creating a user in Oracle 10g

2011-05-30T17:58:00.000-07:00

Create user Username Identified by Password Default Tablespace Tablespacename temporary tablespacename account unlock;

Grant connect, resource username;

Commit;

How To Block Ads in Google Chrome

2011-05-20T09:10:00.000-07:00

Download ADBLOCK from https://chrome.google.com/webstore/detail/gighmmpiobklfepjocnamgkkbiglidom#

CELogonToken In Xcelsius

2011-05-19T13:40:00.001-07:00

CELogonToken is a variable that stores the session token generated by BOE (Business Objects enterprise) generates when a user successfully logs in. Xcelsius consumes this session token using CELogonToken. When ever an Xcelsius dashboard is invoked from BOE(Infoview) the session token is passed to the dashboard from BOE by default.

Why is CELogonToken required?

Both QaaWS and LiveOffice require the presence of a session token in the dashboard to be fired. Meaning, if a user opens a dashboard from within Infoview, the session token is automatically passed to the dashboard, the queries in the dashboard require this session token to fetch data into the dashboard.

However, if the dashboard is opened outside the BOE then in that case the queries inside the dashboard will require the session token but will not find it, in that case a login dialog box will appear which will ask for logging into BOE, once logged in a session token will be passed to the dashboard and queries will get fired to fetch data into the dashboard.

How is CELogonToken passed to Xcelsius:

CELogonToken is passed to Xcelsius dashboard using Flash Variables.

Below is an OpenDocument URL that contains the CELogonToken:

This has been taken from excel sheet of Xcelsius:

="http://sam-pc:8080/OpenDocument/opendoc/openDocument.jsp?

iDocID=AUGXrzBjiQBPifI5QCjLYtc&sIDType=CUID&sType=swf&sKind=Flash

&lsSTestVar=testvar&lsSYear="&Sheet1!K1&"&lsSState="&Sheet1!K2&"&lsSCELogonToken="&Sheet1!A1

In this sample OpenDocument URL, CELogonToken is highlighted in color, its value is present in cell Sheet1!A1. Firstly a Flash Variable is created, CELogonToken is the name of the range created which is mapped to cell Sheet1!A1. When ever the dashboard is invoked from outside of BOE using the OpenDocument URL, the session token which would be generated from the login dialog box will be placed in cell Sheet1!A1.

CELogonToken is required in scenarios where a Web Intelligence, Crystal reports are to be opened from a dashboard or when a child dashboard is to be opened from within the parent dashboard.

Another good article:

http://ryangoodman.net/blog/index.php/2008/01/21/xcelsius_single_sign_on_with_celogontoke

CELoogonToken can also be generated using Java or .NET:

http://davidlai101.com/blog/2010/11/18/xcelisius-dashboards-outside-of-infoview-with-the-help-of-celogontoken/

http://infosolblog.com/tag/celogontoken/

Slide Show Component In Xcelsius

2011-05-19T12:16:00.000-07:00

http://ryangoodman.net/blog/index.php/2006/12/15/passing_data_from_a_parent_to_child_swf

http://ryangoodman.net/blog/index.php/2008/02/14/adding_a_pre_loader_in_xcelsius_dashboar

Flash Variables In Xcelsius

2011-05-19T08:33:00.000-07:00

http://ryangoodman.net/blog/index.php/2007/09/26/flash_variables_in_xcelsius

http://myxcelsius.com/2010/10/26/passing-data-from-a-parent-to-child-swf-flash-variables/

http://inovista.com/samples/imtSlider/DataShare.html

http://www.whitworth.org/2009/01/31/xcelsius-june-newsletter-advanced-topic-using-flash-vars-with-crystal-xcelsius/

Improving Performance of Xcelsius Dashboard

2011-05-19T07:25:00.000-07:00

In this article I will explain the different methods of improving the performance of Xcelsius 2008 dashboard. Performance here means loading time. My manager emailed me a dashboard and told me to have a look at it as I will be updating it. I was more than happy to do what was being asked, however he also mentioned that the dashboard was taking 40 - 45 seconds to load.... I had to cut down that time as well. Before actually getting my hands wet, I decided to do some research which I will jot down in this article. Oh! not to mention the dashboard was using LiveOffice connections no QaaWS connections.

I'm using Xcelsius 2008 Service Pack 3 Fix Pack 3.5

Steps to improve loading time of the dashboard:

1- Avoid using 'Refresh on Load' option for all the Live Office Connections. Make other LO connections dependent on user's actions. Place a selector component Eg. Combo Box that lets user choose a value and then trigger the other LO connection based on that trigger.

2- Limit the size of your dashboard to less than 1 MB.

3- Usage of Parent - Child approach. If you dashboard is huge (close to 1 MB). Use SWF Loader component for this approach. Note: In order to access a dashboard that is in Infoview use the OpenDocument syntax otherwise use DocumentDownload syntax, if your dashboard swf file resides somewhere else.

4- Avoid calculations on Excel sheet - you must utilize the calculation power of WEBI so use Live office for that.

5- Avoid certain components - List Builder, Panel component.

6- Play around with themes - some themes also tend to slow down the performance of the dashbaord (strange but true)

Change Login Banner or LOGO in Business Objects Infoview

2011-05-18T15:24:00.000-07:00

We can change the login picture or logo, in the infoview and central management console.

Here i will show, how to change that logo,

Goto your Business objects installation directory

like this is my directory,go to exact path which i have mentioned below

\Program Files\Business Objects\Tomcat55\webapps\InfoViewApp

Then you will find two folders,

1. res

2. WEB – INF

Under res folder there is another folder named schema.blue , this is where we are going to paste our own GIF pictures which you wanted to change. so paste your favorite picture in this directory

\Program Files\Business Objects\Tomcat55\webapps\InfoViewApp\res\schema.blue\

the second folder, WEB – INF you will find a web.xml file where the location of the picture in defined.

\Program Files\Business Objects\Tomcat55\webapps\InfoViewApp\WEB-INF\

EDIT that web.xml and add the name of your picture in the following area.

under

<——-File resources—–>

img.banner.logo
*login_banner_SAPBOBJ_logo.gif

After the name of the picture to your picture. like below (Sasuke vs Itachi.gif)

img.banner.logo
*Sasuke vs Itachi.gif

Most important thing is, dont forget to take a copy of that web.xml file because in case any mistake happens we can replace the same with this file. Then the changes can be reverted as the old one.

After Editing save the file and RESTART the SIA and Tomcat Services in CCM. Then open Infoview

it will look like this,

Similarly every pictures that you see in infoview and in CMC can be changed. Enjoy working and share your knowlege

Reference: http://rdineshkumar.wordpress.com/

How To Use Business Objects XI OpenDocument URL Command

2011-05-18T13:31:00.000-07:00

http://www.businessobjectstips.com/tips/infoview/opendocument-an-introduction-to-a-powerful-tool/

http://resources.businessobjects.com/support/communitycs/TechnicalPapers/boe_xi_opendocument.pdf

Common LiveOffice Xcelsius Error

2011-05-17T11:00:00.000-07:00

The most common error received by all new Xcelsius developers when using LiveOffice to retrieve data is:

To solve this easy problem, Go to Data -> Connections

Delete the and type in your Business Objects server name and leave the port number same as before. This will work.

Xcelsius Liveoffice Tutorial

2011-05-17T10:12:00.001-07:00

http://myxcelsius.com/2008/12/23/part-i-live-dashboards-using-bo-liveoffice-introduction/

Xcelsius Tutorial Videos

2011-05-17T10:00:00.000-07:00

http://www.datapigtechnologies.com/XcelsiusMain.htm

http://www.forumtopics.com/busobj/viewtopic.php?t=81978

Xcelsius 2008 FixPack 3.5 Now Available

2011-05-17T08:56:00.000-07:00

Xcelsius 2008 FixPacks downloads are available at:

https://websmp230.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm

Another good xcelsius website:

http://www.hackingsap.com/blog/5-xcelsius-scdd-sap-crystal-dashboard-design-tips-to-start-2011-right

What is a Measure Objects in Business Objects Universe?

2011-04-12T18:44:00.000-07:00

A measure object is any object that conforms to the contexts in a report. It is defined with an aggregate function. There are two types of functions present in a measure objects:

Aggregate function - added to the Select clause of the SQL generated for the object. This calculation/aggregation is done at DB level.
Projection funciton - used for the report level contexting. Applied at report level.