GeekInterview.com
Answered Questions

Cognos explorer

Asked By: raja29 | Asked On: Aug 25th, 2008

What are the unique advantage of having 3 explorer in cognos i.E 1) page explorer 2) query explorer 3)variable explorer

Answered by: fly2anshul on: Sep 18th, 2008

Here it goes: Page explorer: You use this to navigate through pages of a report (page by page). You can also use this to add more pages to your report.Query Explorer: You use this to view or modify th...

Answered by: angel987 on: Sep 17th, 2008

For the ease in accessing / arranging pages, queries and variables.

Drill through

Asked By: dontisuresh | Asked On: Jul 23rd, 2008

By using one drill through can we explore the four reports at a time ?

Answered by: bvsr007 on: Jul 17th, 2009

1) Create Drill through report to link two reports contain related information 2) You can access related and more detailed information in one report by using to select a value in another report. ...

Answered by: angel987 on: Sep 2nd, 2008

Its possible for eg: you click on any list column body and click on drill through.Over there you can add multiple new drill throughs and each drill through can open a new report. So when you run ...

What is reconciliation ?

Asked By: ahsan.nazia | Asked On: Jul 15th, 2008

Answered by: sindhusegaran on: Jul 29th, 2009

Reconciliations compares two set of accounts. It is usually the balance in two accounts to make sure that they are in agreement.

Answered by: angel987 on: Jul 21st, 2008

Suppose you have 2 types of balances A and B  reconcilaition is a process in which we compare if balances in A are equal to balances in B

Value prompt

Asked By: marge0513 | Asked On: Jun 12th, 2008

Hello everyone, I am using report studio in report net. I have a value prompt that I would like to display a code number and its description. As it is now, it will only display EIther the code number or the description, not both. Is there anyway I can display both with a space in the middle? Thanks!!

Answered by: angel987 on: Jun 24th, 2008

1)create a new data item in that concatenate code with the description
2) in the properties of value prompt select the display value to the new data item created.

Reportnet report studio & cognos8 report studio

Asked By: kranthi.kunta | Asked On: May 23rd, 2008

What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?

Answered by: kadarla on: Aug 17th, 2009

These are the differences between Cognos Reportnet report studio and Cognos 8 report studio: 1. In Cognos 8 we can use dimensional data for reporting.2. We can drill through from chart also in Cog...

Answered by: elizabethzen on: Apr 20th, 2009

Cognos 8 Report Studio is the reporting tool for ReportNet, the Web-based reporting solution.

What is the use of event studio, analysis studio and metric studio

Asked By: meenu naidu | Asked On: May 23rd, 2008

Please explain what is the use of event studio, analysis studio and metric studio and when and where we will use these studios

Answered by: angel987 on: Jun 26th, 2008

Analysis Studio - an application to analyze cubes and explore business data in a multidimensional manner. Mainly used by business analysts. • Metrics Studio - used for the scorecarding. The idea ...

How to limit the output in a report for testing?

Asked By: sreshty | Asked On: May 21st, 2008

Let us assume that I have to create a report whose output has 1 million rows. When I create the report and run it may take several hours to show me the complete report. So can I limit the output to just 100 rows to save time while testing the report? Thanks in advance.

Answered by: arunkiranrega on: Aug 11th, 2008

You can limit data by applying filter  on some query item - for example if you have somany contract ids - you can apply filter contract id -1234

Answered by: angel987 on: Jun 26th, 2008

In the run options set the data mode to limited data.

Cognos connection

Asked By: mohancognos | Asked On: Mar 7th, 2008

What r the components of cognos connection?What r the components of query studio?What r the components of report studio?What r diff between master detailed relationship and drill through report?

Answered by: bonniewade1 on: Jan 14th, 2011

What are the components of Cognos connection? Cognos connection is the single point of entry to all of the report writing tools. You can customize your pages and tabs. It contains cognos administr...

Answered by: angel987 on: Jun 27th, 2008

Cognos Connection is a single entry point to access entire functionality of the Cognos ReportNet, such as Report Studio, Query Studio, Reports, Server Administration, Directory Administration, System Administration etc.

Cognos report studio data containers

Asked By: madhumita1012 | Asked On: Mar 6th, 2008

What are the types of data containers in cognos report studio?

Answered by: piyush_prad on: Dec 5th, 2010

List 

Crosstab
Charts
Repeater 

and also Nested Objects like
Block
Table
Conditional Blocks

Answered by: angel987 on: Jun 30th, 2008

list, crosstab, charts

Suspense account

Asked By: kv040 | Asked On: Feb 22nd, 2008

Hi friends,i have a problem with suspense account. I been working for some organization and they have been getting this suspense account error since 2003. But its a big organization and they didn't consider it as a problem so far..But now-a-days this suspense account is increasing rapidly and decreasing...

Answered by: Hemant Balodia on: Jul 25th, 2011

I have worked for "Westpac Banking corporation" which is largest bank of Australia. I was in suspense team. In suspense accounts generally value comes when the values moves from sub ledger to ledge...

Answered by: raghunath on: Jul 23rd, 2011

To clear suspends account in oracle finance.we have to assign suspends account type in at our chart of accounts as liabilities account type.in values of account segment.then go to accounting setups op...

Master detailed relationship

Asked By: sathyajagadeesh | Asked On: Jan 26th, 2008

Can you apply the master detailed relationship between query studio report and report studio report? How?

Answered by: vishal_9009 on: Mar 17th, 2009

Master detailed relationship from query / Analysis studio report and Report Studio report can be created only with the use of Package level drill through.

Answered by: simik on: Feb 24th, 2009

Master detail relationships link information between two data containers (such as list, crosstab, or chart) within a report: a master data container, and a detail data container.Using a master detail ...

Materialized view

Asked By: sivakumar.bora | Asked On: Jan 11th, 2008

If there is no calculations and the data is summerized, will you use materialized view? Give reason

Answered by: angel987 on: Sep 5th, 2008

they can be used to summarize, precompute, replicate, and distribute data.
but if there are no calculations needed and the summarization is already been done then not sure if we need to use them..

How do you partition time dimension in cognos.

Asked By: nath | Asked On: Aug 19th, 2007

Answered by: angel987 on: Jul 1st, 2008

i guess by partitioning it in date, month, year, hours, minute, second.

What is the cognos report development life cycle?What are the phases involved in the report development?

Asked By: Sujit Murumkar | Asked On: Jul 9th, 2007

Answered by: angel987 on: Aug 22nd, 2008

1. Getting the requirements for report creation. (could be any functional document)2. Tables creation.3. Working on the framework manager for data modelling4. Starting report development acc...

What is meant by junk dimension?How do you perfom while running the report?Where will you see the time of running report?Size of the cube?What are the types of prompts in reportnet?What is macro and how...

Asked By: hakkim | Asked On: Nov 10th, 2005

I need answer

Answered by: fpaulraj on: Jun 17th, 2011

Macro is a object embeded with in the query or the sub query which can be executed while runing the query.

Answered by: fpaulraj on: Jun 17th, 2011

Junk dimension means, The dimension value which has absolute value in the dimensional hierarchy. and the lowest level of the the dimensions does not have corresponding measures in the face table. When...

Interview Question

 Ask Interview Question?

 

Career Counselling

 Have Career Question?

 Ask Chandra

 Ask Only Career questions.

Follow us: