How can we improve performance in report studio level?
Answer / navneet singh sahni
Run the report in by applying the Query property to Limited
Local Processing, applying the appropriate Filter and
Prompt, not to create complex calulation in single Data
Item.
| Is This Answer Correct ? | 4 Yes | 0 No |
Why Star Schema is de-normalized? Please explain in detail probably with some examples.
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
Explain what is the difference between native sql and cognos sql?
Explain about embedded & standalone filters?difference between them
What is metric store database?
i would like enter some empty space after every 3 rows how is it possible....?
suppose if u r report having 1000 tables i want to dispaly alternate rows means 1,3,... how we specify that pleaes ans me
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?
Where do you edit cognos sql in report studio?
-----------------What is Determination Model?
How is cognos model organization works?
What is parameter maps & Session parameter?