The Business Intelligence|Results page enables you to define result members for your query. Result members define what data to include in the results of your BI query.
When creating a new query, a default set of result members displays based on the type of BI object.
|
Information For example, the default result members for a customer BI query include Customer Number, Default First Name, Default Last Name, Default Address. You can modify these default result members and/or add new ones based on your requirements. |
If you will be saving your BI query to a folder for use elsewhere in the application, some folders require certain result members.
Once you have added result members to your BI query, you can specify whether to sort, group or total the member, create an aggregate function, and/or develop more complex results such as pivot extracts.
The following sections describe how to work with BI result members:
▪Adding New Result Members to a BI Query
▪Sorting, Grouping or Totalling Result Members
▪Sorting Results by Data Not Included as a Result Member
▪Defining an Aggregate Function
▪Creating a Pivot Extract (Display Types)
oExample Pivot Extract -- Customers with Same Last Name in Same City
