Interested to Buy Any Domain ? << Click Here >> for more details...
How can you improve performance in report studio level?
What is the difference between Cognos sql and Native sql?
How can you create cubes in framework manager?
- 7 Answers
- 35812 Views
- Genpact, iFlex, TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / neelima
by using simple case statements and minimising the complex
calculations and applying the frequently used filter
conditions at the framework level instead of applying them
in the report level we can improve the performance.By
implementing distributed configuration we can improve the
performance.
we can create IQD's in the framework level and use these
IQD's to create cubes in powerplay.
| Is This Answer Correct ? | 12 Yes | 3 No |
Answer / ushasree
report studio performance depends on net work spead,
complex calculations,using not in operator,outterjoin.
Cognos SQL and Native SQL are two different types of SQL
generated by cognos tool. Native SQL is sub set or same as
Cognos SQL.
Native SQL contains only the functionality that got
executed at database end, apart from this Cognos SQL will
have the Locally processed logic as well.
we can create package using cube.Cube is a data source here.
| Is This Answer Correct ? | 15 Yes | 10 No |
Answer / durga
The performance of a report depends on the network speed
and as a developer the following things should be taken
care. Use less number of complex calculations in the
report. Avoid using of conditional blocks and also avoid
unions in the reports.
To create a cube we need to create an iqd. and use this
iqd to create a cube.
| Is This Answer Correct ? | 5 Yes | 3 No |
Answer / s ali
DMR is similar to cube. Has all member functions and drill down and roll up features.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / sergio
I don't know exactly why but it seems that parameters in the
filters badly affect performances. Does anybody know why?
| Is This Answer Correct ? | 4 Yes | 7 No |
By using less number of filters, avoiding complex
calculations , and distributing configuration we can improve
performance in report studio ..........
cognos sql statement is created irrespective to database
but native sql statement is created respective to database
which is using .......
we can't create cubes in frame work manager ......there is
no other scope to create cube other than Power play
transformer....
If i am wrong ,point out me please...
It's madhoo
| Is This Answer Correct ? | 7 Yes | 11 No |
Answer / abc
u can create cube in FM using externalise property.
| Is This Answer Correct ? | 2 Yes | 11 No |
10. How many queries did you use in the complex reports? 11. How will you use the joins in the queries used in your report? 12. How many reports did you create in your project? 13. How many cubes did you create in your project? 14. How will you create .iqd file in FM. 15. Was your package multilingual or single language? 16. If you have created a single language package…and you have a client who need to access that in other language…how will you do that? 17. How many dimensions and facts did you use in your reports? 18. How will you use your package in Analysis studio? 19. Something like types of files in power play like pyi..i don’t remember this question. 20. If you want to create a prompt with 4 list, not containing any value using value prompt, which when we will see in the run time…if we will select any list, it should show us the data related to that list. 21. What all kind of packages you can create using FM. 22. In your project was your cube a relational or multidimensional? 23. I replied MD for the above question then they asked why did you use that? 24. How do you publish a cube? 25. Slicer and dicer….its use…where is it used? 26. Bursting…. 27. How many types of query subjects are there? 28. Difference between before and after aggregation?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
What are types of batch available in cognos?
how to merge 2 crosstabs thans
How can we create regular dimensions & measure dimensions?
1. Explain your project.
What is the difference between filter & Condition?
What is an open session command in cognos connection?what is it meant for?
The vice president of sales has requested a report that shows sales performance by representatives in each country for year 1998. He would also like to see the performance for reprasentatives in Asia in order to present an award to the top sellers when he visits next month.
---------------What is Dimension?
Explain what is the difference between microstrategy and cognos reporting tool?
What is the difference between static and dynamic conditions?
Teradata 
