What is Correlated sub-query? Please explain
Answer / harish
correlated subquery runs once for each row selected by outer the query. it contains reference to a value from the row selected by outer query row.
Is This Answer Correct ? | 1 Yes | 0 No |
diff b/w grouping and aggregation
What is Regular Dimension and Measure Dimensions and Diff b/w them ?
Cognos TM1 1. What are the different windows in Turbo Integrator? 2. What is the use of advanced window in Turbo Integrator? 3. What is TM1 Workflow. How do you create a process in that? 4. Where is Portlet used. What are differnt windows in portlet. How can you access TM1 web from portlet? Cognos 8. 1. What is Drill-on? 2.How do you implement row level security in Framework Manager? 3. How do you create tree prompt?
What is a dimension?
Which one is better among Value and select & search prompts,in terms of performance?
Create 12 columns for months by writing single case statement?
Can you define a catalog and types of catalogs in cognos?
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 ?
Define query items?
what do u mean by bridge group? where we r using this one?
Hi Techies, Need your help for achieving this requirement. We have got a requirement to display a report in a page which should diplay max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should display 20 (divisible by 5) and on other page it should display 3 rows. Please advice!
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?