What is a query set?
Answers were Sorted based on User's Feedback
Answer / kiran_pernaty
TO MERGE THE TWO QUERY SUBJECTS WITH SAME DATA TYPES BY
USING THE SET OPERATIONS.(EXCEPT,UNION,INTERCEPT)
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / vijay
QUERY SET IS MAINLY USED FOR MERGING TWO QUERY SUBJECTS WITH SAME TABLE STRUCTURE FROM ONE OR TWO DATA SOURCES. BUT IT IS MAINLY USED FOR MERGING QUERY SUBJECTS FROM TWO DATA SOURCES... USING THE SET OPERATIONS (EXCEPT, UNION, INTERCEPT, UNION ALL)
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / lakshmi reddy
query set option which is used to merge the 2 query subjects
which is having same query structure and having same
datatypes using union, except, intersection operators
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the abrevation of .PPR? (Power play report) or anything new?
wht is the reason for using sql queries in the report 1. inorder drag the items to conatiner we can use use packages but wht is the neccessity of using sql queries to drag the items into the container
Which lifecycle we will use for reporting?
difference between boxtype and visiable
How can we create regular dimensions & measure dimensions?
write a query to display to 10 max record from the employee table?
what is prompt variable
Can we provide Package level security to two different groups i.e for finace and HR depts should access only their data??
What are the different ways of adding data in Transformer?
what is the meaning of aggregation and rollup aggregation? Difference between layout calculation and query calculation? How do you hide the rows that have null values? why we use query studio? what is the use of query studio compared to report studio?
I have a value prompt in my prompt page.Now if I set the filter to required then I have to select a value from the list and I will get the respective data in the report page.But If I select nothing then I will get the complete data in the report page. I want that if I select nothing from the prompt list then nothing is displayed in my report page. How should I do this?
What is the difference between a cascading report and drill through report?