Are you in search of Cognos ReportNet (CRN) Jobs? Then you are at the right place. We provide you with the complete Cognos ReportNet (CRN) interview Questions and Answers on our page. Cognos ReportNet (CRN) is a web-based software product for creating and managing ad hoc and custom-made reports. ReportNet is developed by the Ottawa-based company Cognos (formerly Cognos Incorporated), an IBM company. There are numerous leading companies that offer various job positions in Cognos ReportNet (CRN). Here's our recommendation on the key things to need to prepare for the job interview to achieve your career goals in an easy way. To avoid this confusion, we’ve framed Cognos ReportNet(CRN) job interview questions and answers to simplify your interview preparation. To know more visit our website Wisdomjobs.com.
Question 1. How To Drill Through From A Powerplay Cube To Reportnet?
Answer :
Setting up drill-through access from PowerPlay Web to ReportNet involves :
Question 2. How To Create Prompts In Report Net?
Answer :
Prompts is meant by the end user can be filter the data.
Question 3. Explain What Is Difference Between Query Studio And Report Studio?
Answer :
Query Studio:
Report Studio:
Question 4. What Is The Difference Between Powerplay Transformer And Power Play Reports?
Answer :
Question 5. Explain What Are Components Of Report Studio?
Answer :
Components of Report Studio:
Question 6. Explain What Are The Advantages Of Query Studio Compared To Report Studio?
Answer :
The query studio is used to create adhoc reports, it is easy to understand the bussiness user.The report studio is mainly used to create proffessional and corporate reports, it is not like query studio it is having mainly 3 explorers those are page explorer,conditional explorer and variable explorer by using these it is working.
You can view the output in the work area itself while creating the reports in QS but in report studio only when u run the report you can view the values ie the output.
Question 7. How To Generate The Cubes In Framework Manager?
Answer :
Question 8. Explain The Versions Of Reportnet?
Answer :
In ReprotNet have two vertions:
Question 9. Explain The Difference Between Native Sql And Cognos Sql?
Answer :
In cognos reportnet
Question 10. Explain Is There Any Comparison Available For Cognos Reportnet Vs Crystal Reports?
Answer :
There is a lot of difference between Crystal reports an Cognos Report net:
Question 11. Explain How To Generate Iqd File From Framework Manager?
Answer :
Create a Query Subject, from the properties pane select externalise,there we have 4 options in that select IQD
Answer :
Create 2 roles . One role can be given access to create reports in RS and the other role may be denied.
Question 13. Explain What Are Components Of Reportnet?
Answer :
ReportNet has a three-tier architecture, namely,
The tiers are based on business function, and are typically separated by firewalls. ReportNet user interfaces sit above the tiers.ReportNet user interfaces include
Question 14. Explain The Difference Between Dw And Bi?
Answer :
There may be a Feature film (movie) without a Trialer.But there will be no trialer without a movie.similarly Data warehousing is a concept related to extracting client's business data and applying business processing features on that data according to user needs and finally loading the processed data into a database,this database is what we call a warehouse or data warehouse.
After the completion of a data warehouse the business user ultimately want to view his data (a precise and summary data)but as a business person he may don't have knowledge of accessing a database( a computer person can access the database with SQL)..
so there comes olap toos(which help that person to access the database )we can call these olap tools as Business Intelligence tools(Intelligence in sense they generate sql queries internally and provide lot of facilities and privileges for a reporting developers in formating the data and presenting it in a higly convenient manner).
So data warehouse(movie) is a database and business intelligence tools(trialers) present the content of a database in an effecticient manner.
Question 15. Explain What Are The Various File Formats Involved In Reportnet?
Answer :
It has six (6) formats in report net. They are HTML, PDF, Excel 2000, Excel 2002, CSV, and XML format. We can see the types of formats in the report viewer on the right side
Question 16. How To Provide Security In Frame Work Manager For A Query Subject?
Answer :
procedure for providing security for query subject in frame work manager is:
select querysubject -> in properties pane select ->security filters(click on edit)a specify data security wizard appears->click on add groups -> cognosnamesspace(select users and groups wizard opens)
Question 17. What Is Prompt Types Of Prompts?use Of Prompts Syntax Of Prompt?
Answer :
Prompts act as questions that help users to customize the information in a report to suit their own needs.
The different types of Prompt are :
Using prompts is faster and easier than repeatedly changing the filter.Cognos Report Studio provides several ways to create prompts.
You can :
Answer :
We have a function called param Display Value. By using this function we can display the parameter value selected in prompt.
Question 19. Explain What Are Necessary Tasks To Install Reportnet Software?
Answer :
You need to do the following for a standard installation process:
Question 20. How To Test Report In Reportnet?
Answer :
If we wanna test the report in report net, first we can intially check by validating it in the report page.
After that we can test the out put of the report Using a sql anlyser and sql query.so here we will be comparing the sql analyzer output with the output of the report viewer.
Question 21. Explain What Is The Main Advantage Of Impromptu Over Cognos Reportnet?
Answer :
One of the advantage's of Reportnet, is:
By using ipromptu we can use multidimensional analysis to see the data in diff formates.i.e we have drillup,drilldown features in cognos impromtu,but it is not possible in reportnet.
Question 22. Explain What Is The Difference Between Powerplay Transformer And Power Play Reports?
Answer :
Answer :
Actually the it is not possible to make reports without packages and packages can be build in FM. So no way one can skip FM and create reports.Adding to it,we need metadata (created in FM) to create relations among tables or views and also creating objects which satisfies reporting need.
Question 24. How To Define A Cube?
Answer :
Its a multidimensional view of dimension and measures. It is used to analyze the data in various aspects, which is called slicing and dicing
Question 25. Explain What Is The Extension Of File To Save Template?
Answer :
Template extension is .imt
Question 26. What Is Difference Between Model & Package?
Answer :
Model:
Package:
Answer :
There isnt any need to copy the data before reporting on as long as the data is clean. But if the data is not clean it should be cleansed and so go for ETL process.
Adv of reporting directly against the database(OLTP): No need to sepertaley maintain a Database for it.(Space consumption is recduced).
Disadv of reporting directly against the database(OLTP): It slows down the process bcoz OLTP system is designed for the online application but a DataWarehouse application which requires to do analysis and hence takes the same data but takes a long time.
Answer :
Question 29. Explain The Difference Between Filter And Condition?
Answer :
The difference between Filter and Condition:Condition returns true or false Ex: if Country = 'India' then ...Filter will return two types of results
Question 30. Explain Can Report Net Connect Multiple Datasource At A Time In Report Creation Time?
Answer :
Yes it can connect multiple datasources at a time when the frame work manager has the metta data regarding that datasources.
Question 31. How To Limit The Max No Of Rows Retrieved In The Report?
Answer :
We can limit the maximum number of rows by setting the web page size option in the manage file tab in the report studio.
Answer :
Cognos ReportNet (CRN) Related Tutorials |
---|
IBM Cognos Tutorial |
Cognos ReportNet (CRN) Related Interview Questions |
|
---|---|
IBM Cognos Interview Questions | Broadcast Interview Questions |
SQL Interview Questions | IBM Cognos TM1 Interview Questions |
Data science Interview Questions | Soap UI Interview Questions |
Soap Web Services Interview Questions |
Cognos ReportNet (CRN) Related Practice Tests |
|
---|---|
IBM Cognos Practice Tests | Broadcast Practice Tests |
SQL Practice Tests | Data science Practice Tests |
Soap UI Practice Tests |
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.