diff b/w grouping and aggregation
Answer / amar
grouping : it will sum up group wise.
Aggregation : it will sum up all in list.
EX - Grouping : country wise total.
Aggregation : all country's total.
| Is This Answer Correct ? | 1 Yes | 0 No |
what is drill down and slicing and dicing what are the difference between them?
I want to schedule the report as sysdate-1.....how to do
11. Which is a collection of data defined in Analysis Studio that can be saved and reused in the same analysis? a. Custom set b. Predefined set c. Level based set d. Measure set 12. In a list report in Report Studio there are 3 columns A,B,C and they are grouped by Col A. To show the values of Col A for every value of Col B , which of following steps should be taken? a. Ungroup b. Set Group span to Col A c. Set Group span to Col B 13. Which of following cant be set as a Governer in FM? a. no of tables to b selected in a query b. Left outer joins c. No of Columns to be selected in a query d. Cross Product joins 14. Purpose of analysis studio? a. To provide interactive reporting capability b. All the options c. To generate complex reports d. To help in more trend analysis 15.How to suppress Nulls in Analysis Studio reports? a. Choose the suppression as TOTAL > 0 b. Choose the suppression as TOTAL is NULL c. Choose the suppression as TOTAL is ZERO d. Choose the suppression as TOTAL is not NULL 16.Frame work Manager cant import Metadata from which of folowing? a. Decision Stream b. XML datasource c. Impromptu Catalogs d. Excel Sheets 17. In a report, to perform aggregation using aggregator expression, what should we use? a.Aggregation LIst b.Aggregation type c.Aggregation mode d. None 18. What is the role for gateways? Thanks in Advance
What is the difference between drill down and drill through?
10 Answers DELL, Deloitte, Systime,
I have 3 objects (list,cross tab and chart)in one page, when u run report display each object in each page. how can i do?
When we save a report in report studio with what extn it save?
How create measures and demensions?
what is stitch query in reportnet?
How you will do the estimation for a task?
What is the size of the cube?
plz giv ans . user1 developed some repot ,user2 modify the same report and user 3 also some updates in that same report ? how to indentify that report will be modified r not ?
how to hide a particular pages at time if you get blank pages