BiLog: Brownies, Bronies and Adding LD to ROS
PamDenny 270000BXV7 Visits (5565)
One W separates brownies from bronies. Brownies are incredible, delectable chocolate goodness, while bronies are followers of a children's TV Show. Bronies and their collections of Little Ponies have become increasingly popular in the Software Development world thru their features in Wired Magazine.
While I’m not a bronie, whenever I hear about software and collections, my mind jumps over to data collection. Last week, I talked to a client about long descriptions, which are available in the various Maximo applications to collect large amounts of data. The client asked how he could include long description data in his ad hoc reports, which can be easily done by following the steps below.
To recap, Report Object Structures (ROS) are the building blocks of ad hoc reports. ROS define which database objects and attributes are available for the user to select to his ad hoc report. To enable your users to add the long description field to their ad hoc report, you must first add the Long Description object as a child to the ROS.
To illustrate this, the steps below detail an example of how you can configure the Work Order ROS to include the child Long Description object.
1. First, access the Database Configuration application and verify that a relationship exists between the parent Work Order and the child Long Description. In this example a relationship does not exist, so one was added as shown here.
2. Next, go to the Object Structure application and add the new child object of Long Description to the Work Order ROS. Make sure to specify the cardinality and type of database join properly.
3. Select Exclude/Include Fields from the Select Action menu to exclude any attributes from the Long Description Object that you do want to display to your users. For example, you may want to exclude attributes like LONGDESCRIPTIONID.
4. The Long Description Object is now available within the Work Order ROS for your users as shown here.
Additional details and screenshots can be found on this wiki page . More detailed information is also available in the V75 QBR Ad Hoc Reporting Guide here, or the V71 QBR Ad Hoc Reporting Guide here.
These 4 simple steps above illustrate how quickly you can customize your data collections by including long descriptions in your ad hoc reports. And as for bronies or brownies…I’m definitely going for the brownies…although they never last long enough to form collections!