- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
Reportnet Interview Questions & Answers - Learning Mode

Reportnet Interview Questions & Answers - Learning Mode

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. The web-based reporting tool was launched in September 2003. Reportnet is both an information infrastructure and a new setup of functions to assist data and information flows resulting from reporting obligations.

Try Reportnet Interview Questions & Answers - Exam Mode

1 2 Next

Sort By : Latest First | Oldest First | By Rating

Reportnet Interview Questions & Answers - Learning Mode
Try Reportnet Interview Questions & Answers - Exam Mode
Question: What is the difference between Native SQL and Cognos SQL?

Answer: In cognos reportnet

Native SQL is used for the single datasource to import the meta data

Cognos SQL used for multiple datasources to import the metadata
Question: What is the main advantage of impromptu over cognos reportnet?

Answer: One of the advantage's of Reportnet, is

1. It is web-based reporting wherein, reports can be easily accessed from anywhere through a browser.
Question: 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.

1.Crystal report is a product of Business Objects where as Reportnet is of cognos.

2.Cryatal reports is for only low 2 midrange analysis and that to some even says tha they wont use this for analysis used to make proper strategic decision But report net yes it is for high end analysis.

3.In reportnet we can login through web and can create our own desired report through web.
Question: What is the Difference between PowerPlay transformer and power play reports?

Answer: 'Powerplay transformer' is an 'MOLAP' tool using which one can create multi dimensional structure called "CUBE".

'Powerplay for reports' is used to generate report from the cube.Only one report can be generated from one cube.If u want 'n' reports u must create 'n' cubes.

Question: What is 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 da Source:
Question: 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. Source:
Question: 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 Source:
Question: How can i 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 here we will be comparing the sql analyzer output with the output of the report viewer.
Question: What are necessary tasks to install reportnet software

Answer: You need to do the following for a standard installation process:
(1) Verify your system requirements like RAM Minimum: 512 MB, a Web server installed and started
(2) Review the ReportNet default settings like default ReportNet ports and URI settings.
(3) Create the database for the content store which means you must create the database that is used for the content store using either Oracle, Microsoft SQL Server, or DB2 UDB. ReportNet uses this database to store, organize, and retrieve< Source:
Question: Wht is the extension of file to save template?
What is the difference between drill through and masterdetail reports?

Answer: Template extension is .imt Source:
Question: How do you 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 Source:
Question: Report Studio allows you to create the data model from a query and thereby skipping Framework Manager. Given that this feature is available, in what scenarios would one want to skip Framework Manager? Is Framework Manager an un-needed overhead?

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. Source:
Question: What is difference b/w model&package?

Answer: Model is a representation of the metadata structures(imported from the soure datawarehouse).A model contains organized metadata objects(organizing depends on business needs).After the completion of a model(obviously in a framework manager environment) it has to submitted to ReportNet server.There enterts the object called Package.A Package compresses(or includes) the developed meta data definitions and publishes (forwards) it to ReportNet server.Then the reportnet server moves it into a content Source:
Question: What is the use of tabular model,tabular SQL,tabular reference in real time application?

Answer: Tabular model: It is the basic list query. It contain the data items, filters and child tabular objects.

Tabular SQL: We can write and edit our own SQL

Tabular ref: It is a shortcut to another tabular object somewhere in another query within the same report specification.

Tabular set: Tabular set object returns a single result set using union, intersect or minus operators Source:
Question: What are components of report studio?

Answer: Componenets of Report Studio:

1. Insertable Objects pane.

2. Properties pane.

3. Explorer bar - Conditional Explorer, Query Explorer, Page Explorer.

4. Report Viewer - Workarea, Report Layout Objects.
Question: How can we generate the cubes in framework manager?

Answer: You can create the IQD file from framework manager.

This IQD file will be used by Transformer to create the cube.
Question: What is the Difference between PowerPlay transformer and power play reports?

Answer: 'Powerplay transformer' is an 'MOLAP' tool using which one can create multi dimensional structure called "CUBE".

'Powerplay for reports' is used to generate report from the cube.Only one report can be generated from one cube.If u want 'n' reports u must create 'n' cubes.
Question: How do i allow a dynamic selection of a column for a measure in a chart,without using Variable

Answer: U can in do it in this way. first creat a list report in which u have a calculated item in the starting.

Then creat a prompt page with a value prompt.In value prompt creat static choice of which u want to be dynamically displayed.

Let the parameter of value prompt be ?Par1? and the choices as Revenue, Cost.

Now u write the expression of the calculated item in the report page as follows, "If ?Par1?=Revenue then Revenue else Cost.

Here Revenue,Cost should b dragged fro Source:
Question: What are the advantages and disadvantages of reporting directly against the database?

Do you always need to copy the data before reporting on it?(example, real-time & on-demand reporting is a requirement)

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 Source:
Question: How do we 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)

1 2 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 1.75 Seconds