----------0Diff b/w Report Functions and Database functions?

Answer Posted / amar

Database functions nothing but Sql functions

Report functions nothing but Cognos functions.

While creating reports, Instead of cognos functions use sql
functions at Maximum. Because performance..

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the deployment requirements used in cognos?

1421


We can use a calculated field to dynamically create the burst recipients in Cognos 8. Can we do the same in Cognos ReportNet 1.1?

2293


What is the function of cognos dispatcher?

834


What is difference between page break and section report?

931


----------------Diff b/w Dimensional modeling and Relational modeling?

14330


if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

1707


What r the names of the reports that you prepared?

730


How to create model and how to test model?

786


How can we create a dynamic column name in cognos?

715


hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2143


What is meant by drill down?

722


Can you explain cognos planning?

855


Can you define set to be cardinality?

751


Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?

1893


Can we create 2 conditions in report expression of a single data item..Eg: I added 2 new dataitems each one should show revenue for Q1 and Q2..Pls advice

2323