Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


What is the disadvantages of using Database functions
instead of using Cognos Functions in Report studio?



What is the disadvantages of using Database functions instead of using Cognos Functions in Report s..

Answer / naresh

1)Its permitted to Perticular Database(like Oracle ,Sql
Server ,DB2 ..)so those function wil work until you are
using that databases ,

If you are using cognos functions even after you shifted to
another database also no need to change them.

2) Performance will be slow every time it will hit the
database and validate them ,so performance will be slow ,

If Cognos functions then once data extraction into buffer
area then it wil perform operations one time hitting of
database .

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Cognos Interview Questions

Define catalog in cognos and write its various types?

0 Answers  


How to create users and permissions in cognos?

4 Answers   IBM,


Types of Performance Tuning?

2 Answers   CGI,


What is an olap designer?

0 Answers  


how can you create a report like if country=india then true if contry=spain then false?

2 Answers   Syntel,


What are differences between Reporter report and Explorer report?

2 Answers  


How to create a cube in Transformer? What is the process? Please mention process thank u

0 Answers   Genpact,


is cognos 7 is better than cognos 8

0 Answers   TCS,


What is Parametermap?

2 Answers  


how many types of variables in cognos report net and cognos 8

4 Answers   HCL, Merrill Lynch,


What is conditional styling? a.format applied based on filter b.format applied based on user c.format applied based on on condition d.all the above 2. For a company X, actual revenue and budgeted revenue are captured in two tables Fact_Ac_Rev and Fact_Bud_rev. Both are at diff levels of granularity (Fact_Act is month and budget @ quarter leve )and there is one common Time dimension, A report is created to show the actual and budgeted revenue 2gther but the data for budgeted is wrong. Which should be doing for rectifing the error? a. create determinants for month and quarter b. join the two table facts into a single fact c. Create 2 time dimensions @ FM d. Need to create 2 separate reports as the required info cant be shown using a single report. 3. Template in a Query Studio? a. sample Data set b. CSS c. A standard that applies for all reports d. None of the listed options 4.you are a report author @ the Company, which sells sporting equipment 5. Sales person in different regions each need a report showing sales target for each country. which of the following is the best way to distribut? a. Email b. Bursting c. storing in public folders d. All the above. 6. I)A query subject behave as a dimensional in one query and fact in other query. ii) Queries with more than one fact results in stitched query. iii) Cognos identifies a query subject as Fact based only on the measure a. ii only b. i only c. both i and ii d. iii only 7. what is meant by pivoting? a. making a stacked set b. swapping rows into columns c. making column as filter d. none of the above 8. A report cant be viewed in which? a. CSV b. XML c. ASCII d. Excel 9.A user wants to retriv all products which are not sold for last X days. Which prompt is used? a. Time b. Value c. Text d. Interval 10. Dispatcher? a.routes request to appropriate services and start services b. routes request to appropriate services c.starts all service d. none of the abv Frenz Please help me out !!! :) Thanks in Advance

1 Answers  


what is crosstab space

1 Answers   IBM,


Categories