Archive

Archive for February, 2011

CREATING HYPERLINK IN WEB INTELLIGENCE

1.      Create two reports in Web Intelligence and export both to the Central Management Server. Since the object has to be passed to the second report, create the second report with user prompts which is going to get the objects that are sent from the first report.

1

Fig1.1 Hyperlink1.WID (First Report)

 

2

Fig1.2 Hyperlink2.WID (Second Report)

The First report (Hyperlink1.WID) shows the sales revenue and quantity sold for all states and second report (HyperLink2.WID) shows the sales revenue detail for the particular selected state achieved using Query Prompts.

2.      To create Hyperlink in first report, open Business Objects Enterprise Java Infoview and open the WebIntelligence document (Hyperlink1.WID). Select the Object that is to be linked with the second report then RIGHT CLICK –> Hyperlink –> New…

Fig2.1 Creating Hyperlink

3.      A new window will open for creating hyperlink as shown below, select Link to document tab

4

Fig3.1 Create Hyperlink Window

4.      Click Browse, select the second report (Hyperlink2.WID) and select ok.

15

Fig4.1 Selecting Document

5.      Select Refresh on open option from Hyperlink properties in Create Hyperlink Window and select the options as in following screenshots below.

6

Fig6.1 options

7

Fig6.1a Options

6.      Then the report will look like what is shown below, as hyperlinks for the object that is selected.

8

7.      Click the link from Infoview, which leads to second report after a confirmation from default web browser. Click Ok.

9

8.      For instance, when Texas link is clicked it will go the second report, showing the state wise sales details of efashion for Texas alone.

11

Scheduling in Business Objects xi 3.1

Scheduling:

Introduction:

This feature from business objects is used to schedule reports to run at particular time and destination.This would be useful for the users in times if they don’t want to sit before the system and run the reports each and every time. There are many options on how scheduling can be done.We can specify the objects and times individually through scheduling options. Objects in the sense, it can be a crystal reports, web intelligence reports, desktop intelligence reports, and publications etc.

Scheduling Options:

Whenever a schedule occurs accordingly an instance will be created, instance title is the first option in scheduling, where we enter the title for that instance.

Recurrence option is used to set the recurrence pattern on how to run the objects repeatedly over a period of time. The recurrence options are like NOW, ONCE, HOURLY, WEEKLY etc. whenever we choose these options corresponding day and time settings will come as sub options, where we can set the time and day of week.

Notifications can be done whether the scheduled job has been run successfully or failed to run. The notifications can be an audit or an Email.

Formats available for output may differs for different object like , in crystal reports formats available are more than the output formats of web intelligence Report.

Destinations may be user’s inbox, a file location, FTP server and through email recipients. Each destinations can be configured individually or can take the option as “use the job server’s default” where it can take the setting from corresponding job server’s destinations.

Scheduling can be also done through events and calendar; where there are three events namely,

  • File
  • Custom
  • Scheduled

These options are used to trigger the schedule when some particular event happens. The other one calendar is used to schedule on custom days and months.

Events:

Events can be created in three types in business objects Enterprises 3.1 , as mentioned in scheduling they are

  • File
  • Custom
  • Schedule

Custom: This type of events is used for manual triggering from the user side. To create a custom event,

In CMC go to Events

Click new à new Event, select the typeand click OK.

File: This event keeps track of particular directory, when the file which is specified in the file event properties is created, the event will be automatically triggered.

For Example, C:/sample/test.txt is the file name specified in file event, if a file named “test.txt” is created in this directory will trigger the event.

Schedule:This type of event is used on some conditional basis like dependency reports.

For example, if report1.rpt runs successfully then run some group of reports.

Instance Manager:

This tool is used to view all the instances which are created on running a scheduled object by the job server.

The instances can be viewed on its status:

  • success
  • failure
  • pending
  • running

The instance can also be viewed in specified time and date, by using the “completion time” option from instance manger, where we can specify the time and date the object that has completed successfully.

The other way of viewing the instance is by selecting the history of individual objects, like for a report if history is selected, it will show the instance for that report alone.

Calendars:

This tool from CMC is used to create a basic custom calendar which would be used for scheduling purposes.

To create a new calendar and open calendars in CMC then,

Click Manage > New > New Calendar.

Type a name and description for the new calendar and Click OK

Run dates can now be added to the calendars. Add the new dates and save the calendar, now it is ready to be used for scheduling based on custom calendars.

Rolling calculations in web intelligence by row wise

In webi  we can calculate the rolling sum by using two functions as per my knowledge,

In the following example, i have used efashion  sample universe from Business Objects

They are RunningSum() and Previous(self) functions

while using RunningSum() function we have three arguments in this, which is RunningSum([Measure];Row|Col;([Reset Dimension]))

here we can control the flow of calculation by row using second argument (Row|Col)

=RunningSum([Sales revenue];Row;([Year]))

img1

the alternate way of doing the same is by using Previous(self) function

by

=[Sales revenue]+Previous(Self)

img2

there also should be some other way to achieve this one using formula.

if you find any,  share it here >….

%d bloggers like this: