- SAP IDT Tutorial
- SAP IDT – Home
- SAP IDT – Overview & User Interface
- SAP IDT – Resources
- SAP IDT – Creating Universe
- SAP IDT – .unv Universe Introduction
- Dealing With Published Universes
- SAP IDT – Projects
- SAP IDT – Managing Connections
- Managing Resources In Repository
- SAP IDT – Data Foundation Layer
- SAP IDT – Building Data Foundation
- SAP IDT – Qualifiers & Owners
- SAP IDT – Joins In Data Foundation
- SAP IDT – Business Layer
- SAP IDT – Business Layer Properties
- SAP IDT – Folders In Business Layer
- SAP IDT – Business Layer View
- Building Query In Query Panel
- Dependency Among Resources
- SAP IDT – Publishing
- SAP IDT – Security
- Running Query Published Universe
- SAP IDT – Format Editor Overview
- SAP IDT Useful Resources
- SAP IDT - Questions Answers
- SAP IDT - Quick Guide
- SAP IDT - Useful Resources
- SAP IDT - Discussion
SAP IDT - Building Query In Query Panel
You can use the query panel to create or preview queries on a Business Layer or on top of Universe published in the repository. The query panel allows you to add objects in the query and to preview the query results. A query panel can be opened using the following methods −
Go to Queries → Insert Query.
To select the objects that you want to include in the query, drag objects from the business layer on the right into the Result Objects pane.
For hierarchy result objects, select members to include or exclude in the results. To open the MemberSelector, click the arrow to the right of the hierarchy object name .
To filter the results of the query, drag objects from the business layer into the Filter Objects pane.
Selecting Named Sets
Named set are defined in Business layer while creating Universe. To select members by named set, your hierarchy should define minimum one named set.
Named sets are displayed when you click on metadata under the member selector. If you can’t find a named set folder under metadata, it means the hierarchy has no named set.
Selecting Calculated Measures
You can also use calculated measures with hierarchy but hierarchy should have minimum one metadata defined. They are defined in Business layer.
Like named sets, calculated measures are also displayed when you click on metadata under member selectors.