What is limited local? and the uses?
Answers were Sorted based on User's Feedback
Answer / agent
If you are using any functions which the database cannot handle, if you change it to limited local it will be handled at cognos application level.
| Is This Answer Correct ? | 7 Yes | 1 No |
Answer / amar
When database can not handle the query, then go for limited
local property. report server not able to handle the data
load, then go for limited local.
its used only for dimensional data and olap data sources
| Is This Answer Correct ? | 1 Yes | 1 No |
How you create IQD In ReportNet FrameWork?
1.How can we driil through from a page report having query1 to list report having Query2 in master detail relationship n Drill through? 2.In database i have 50 records but when it is displayed on the report i'm getting 100 record with duplictes.How can we solve this to eliminate duplicates? 3.Exact Diff B/W Filter n Condition? 4.Render Variable? 5.I have leftouter join when right table does not have any matched records with left table what will be the output of the report whether it will be dispalying Null or blank in that particular row? 6.How to test the reports i.e Unit Testing? 7.How canwe drill through when there is no common column between the parent n child report? 8.How can we do performance tuning? I kindly request all the experts to give reply with correct answers and if possible send me some examples regarding that at srini.madhala@gmail.com
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
in u r data u having duplicates how to fetch the latest data in our report?
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
What are the different types of important services used in cognos?
what do you mean by parallel execution of query?
How can we do the unit testing?
1.Can we use 2 packages in report studio at a time is there any alternative for this? 2. What are Star Dimensions and Star Facts? 3.What are dimensions and facts in project ? 4.What is difference between 3 NF and Star Schema ? 5. What Is Data Modelling? 6. How much time do u need to create a report ,if u have four dimensions and 1 fact ? 7. How do u create a Model ? 8. How do u connect a Parameter in a list ,such a way it has to show relative objects in Cross tab ? 9. To display region list in separate pages ,how do u do ?
WHAT ARE THE DISTNICT VARIABLES?
Can you define report item?
What is Report item