CoolInterview.com - 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
COOLINTERVIEW.COM DATA WAREHOUSING INTERVIEW QUESTIONS REPORTNET INTERVIEW QUESTIONS 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
Source: CoolInterview.com
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.
Source: CoolInterview.com
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.
Source: CoolInterview.com
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.


Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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 query.so here we will be comparing the sql analyzer output with the output of the report viewer.
Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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.
Source: CoolInterview.com
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: CoolInterview.com
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.
Source: CoolInterview.com
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.
Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: Difference between filter and conditin



Answer: The difference between Filter and Condition:Condition returns true or false Ex: if Country = 'India' then ...Filter will return two types of results1.Detail information which is equal to where clause in SQL statement2.Summary information which is equal to Group by and Having clause in SQL statement Source: CoolInterview.com

1 2 Next



India News Network
Latest 20 Questions
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
"Holiday Packages" announced as an advertisement are an example of _________: (a) Offer (b) Counter Offer (c) Invitation to Offer (d) None of the above
A match fixing contract between a player and a broker is a: (a) Valid Contract (b) Unenforceable Contract (c) Void Contract (d) Illegal Contract
When a bookseller sells a book on cash payment then it is called as ___________: (a) Unilateral Contract (b) Bilateral Contract (c) Executed Contract (d) Executory Contract
____________ agreements are created by situation: (a) Written (b) Oral (c) Void (d) Implied
Cache = 0.03125 Seconds