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 |
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.
----------------Diff b/w Dimensional modeling and Relational modeling?
what are the limitations of cognos reportnet? What are the enhancements in reportnet ?
Define query studio?
Can you define slice?
Hi, In My Table i am having a Column Emp ASa Fullname In My Report I WAnt First name&Lastname?how I'll Get This One?Pls Ans Me
write a query to display to 10 max record from the employee table?
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
what is catalog and types of catalogs in cagnos and which is better?
fiscal year means what???
What is meant by alternate drill down with ex?
what is the difference between a data item and a query item?