Answer Posted / amar
Outer join means, Suppose we have two tables like A and B.
Outer join returns Non Matching columns from both tables.
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
explain how to create powerplay reports?
describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?
what are the dimensions that you have in your current project?list them?
What is the deployment requirements used in cognos?
I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?
what are the special features in cognos reportnet?
What are the components of report net?
What is the importance of having monitor service in cognos?
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these
What are the main services provided by application tier?
how you create security to reports?
Can you explain cognos planning?
Synchroness 1.What are hash prompts? Ans: Tree prompts in which hierarchies can be seen,they can be said as hash prompts. 2.User wants to see 5 more coloums in the report.We have package and data base,how will u implement using it in report.? Ans: 3.What is automatic optimization?what is optimization?what are the properties you set for optimization in report studio? 4.what is command to display first 10 records from a table? IGATE 1.In FM if we change a fact symbol to attribute,will it effect the report? 2.If a report is slow in generating output. How do u perform tuning? How do u reduce joins in sql? Using left outer join is it going to improve the report performance? IBM 1.How do you configure ? 2.How do you drill through report from RS to Analysis studio?
How to deploy from one server to another server?