Creating a Smart Query
Create a Smart Query by defining one or more sets of members from the dimensions in an application.
To each member set, you can define and apply composite filters to further refine the data to be returned by the Smart Query. Using these sets and their filters, you can create a highly complex query by defining unions, complements, and intersections of data from the different sets.
Once a Smart Query is created, you can use it for ad hoc reporting and analysis. Use the ad hoc reports created from Smart Queries to submit data. Smart Queries can be saved, reused, and shared. Sets and filters can be saved individually for use in other Smart Queries.
You cannot submit data directly from a Smart Query.
Creating a Smart Query involves performing the following procedures: