Bookshelf Home | Contents | Index | Search | PDF

Siebel Reports Administration Guide > Master-Detail Reports > Example—Creating a Report with Multiple Hierarchies >

Creating a New Report Object Definition in Siebel Tools

---

Only Step 1 from Example—Creating a Report with Multiple Hierarchies is described in detail since all other steps are identical to those explained in Creating a New Report Object Definition in Siebel Tools for developing a Master-Detail report.

To create a new report object definition in Siebel Tools by copying

Open Siebel Tools. Verify that the Account business object has Opportunity, Contact, and Competitor detail business components relative to the Account (master) business component. Also verify under Account business object that a link is defined for the Competitor business component between Opportunity and Competitor business components.

This confirms the hierarchical relationship among the business components under Account business object.

In this example, the Opportunity and Contact business components are at the child level, and the Competitor business component is at the grandchild level relative to Account business object.

Make sure that all the business components to be used in the master detail report are active in the associated business object.

A master detail report can be created with multiple hierarchy levels with as many business components as the user needs, as long as all of these business components belong in the same business object and are active. Further, each business component below the parent level should have a link defined with a parent level business component.

In this example, make sure that the competitor business component (which will appear at the grandchild level in the report) has a link defined with Opportunity business component.

Navigate to the Report object type in the Object Explorer. Expand this object type to reveal the child Sub Report object type.
Locate and select the Account Summary object definition in the Object List Editor window for reports.

Notice that this report has seven subreport components, including Opportunity, Contact, and Competitor. Any account report object definition with these latter three subreports would have sufficed. You will copy this report object definition and delete the unwanted subreport components.

Lock the Report project (choose Tools > Lock Project).
Select the Account Summary object definition and choose Edit > Copy Record.

A new report object definition is created with empty Name and Menu Text properties and a set of children and properties otherwise matching the original.

Change the following property settings in the new report object definition (the other property settings do not need to be changed):
Name. Multiple Hierarchy Report

This is the name used to refer to the report structure in Siebel Tools, for instance when you add the report to the Reports menu for a view.

Access Base DB Name. MULHIER

This specifies that Mulhier.rox will be the name of the report executable invoked when this report object definition is invoked from the Reports menu in a view.

Menu Text. Multiple Hierarchy Report

This is the text that will appear in the Reports menu for a view when this report is included in the view through the use of a view report object definition.

Template Name. MULHIER

Specifies the name to be used for the generated data supply library file when the Generate Actuate Report option is invoked for this report object definition.

Sort Specification. (blank)

By default, do not sort the account records into account name order, which is necessary for the group breaks to work correctly. Alternatively, you could specify a value of Account.

Navigate to the Sub Reports list in the Objects List Editor for the new report object definition.
Delete all the subreport object definitions (using Edit > Delete Record) except Opportunity, Contacts, and Competitor.

Notice that the position field indicated for Opportunity and Contacts is 1 and 2 respectively, while for Competitor it is 1.1. This indicates that Opportunity and Contacts are at hierarchical level 2 and Competitor is at level 3 under Opportunity.

The position is indicated relative to the main business component. Each hierarchy level is separated by a period, and the number indicates the relative position with respect to the associated parent. For example, position 2.3 indicates that the subreport is two levels below the main business component, and that it is a child, 3, of the business component designated with position 2.

Expand the Sub Report Fields object definition for the Opportunity subreport.
Add the following subreport fields if they are not already present: City, Close Date, Description, Name, Postal Code, Rep%, Revenue, Sales Rep, and Sales Stage.
Expand the Sub Report Fields object definition for the Competitor subreport. Add the subreport fields Threat Value, and Vendor if they are not already present.
Export to a data supply library file by choosing Tools > Utilities > Generate Actuate Report.

This generates a data supply ROL file, named according to the value in the Template Name property, in the C:\Siebeldev\rptsrc\enu\lib folder (or equivalent on your system).

If your installation uses a non-English version of Siebel eBusiness Applications, you do not have an \enu folder. Instead, you have a folder in the appropriate language code for your installation, such as \deu for Germany.

See Global Deployment Guide for a list of three-letter International Standards Organization (ISO) language extensions.

Unlock the Report project.
Navigate to the View object type in the Object Explorer.
In the Object List Editor, locate the Account List View object definition.
In the Object Definition, expand View and click on View Report. This is the My Accounts view in the Accounts screen.
Add a view report object definition in the Object List Editor.
Enter the name Multiple Hierarchy Report (match the spelling and spacing exactly) and a sequence number that is one higher than any other sequence number in the list.
Choose Tools > Compile and recompile the repository. Move the resulting SRF file to C:\Siebel\objects (or the equivalent location on your system).

Bookshelf Home | Contents | Index | Search | PDF