-
Query Studio
What is the use of Query Studio?
How to use Query Studio? -
Fact less fact table
What is the fact less fact table? why we use this table?give me one example
chandrarekha
- Feb 13th, 2008
A fact table without measure is called a fact less fact table for negative analysis report we use this fact less fact table
praveenj6
- Feb 1st, 2008
If there are no facts(Measures) in a table then it is called as fact less fact table.
-
-
Cognos Report Studio Data Containers
What are the types of data containers in Cognos Report Studio?
piyush_prad
- Dec 5th, 2010
List CrosstabChartsRepeater and also Nested Objects likeBlockTableConditional Blocks
-
Tree prompt advantages
What are the advantages of tree prompt? Why tree prompt was included in Cognos 8?
lalithagaru
- Nov 23rd, 2010
A data driven prompt control that shows hierarchical information and allows you to select one or more members. If you take Order number, Product name, Return quantity the list will show products that were returned more than 30 days after the order date.
cgns.cgns
- Mar 24th, 2008
We use a Tree Prompt when working with dimensional data to prompt for hierarchial values.A Tree prompt returns a set of members from with in a hierarchy.Add a tree prompt to let users filter the level of detail they want to report on in a single hierarchy.
-
Drill through functionality
According to my exp i am explaining to u drill through will work in list and cross tab reports is fine.Can we use the Drill through functionality in Charts?
vidiyala337
- Sep 15th, 2008
You can apply drill through for charts only in Cognos 8, but it wont work in Report Net.
ksrinivas13
- May 13th, 2008
yes, we can use in charts also, in list and crosstab reports we will apply for a specific column but in charts we will apply for whole chart bec'z when we right click on specific column we wi...
-
How to limit the output in a report for testing?
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.
arunkiranrega
- 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
-
Performance improvement in cognos
How can we improve performance in framework manager level? How can we improve performance in report studio level?
4myfuture
- Jul 28th, 2008
A report performance in report studio depends on how well you design the model while creating package in framework manager. In my former answer I answered what point have to be considered first ...
4myfuture
- Jul 25th, 2008
Performance improvement in Cognos can be done by several ways:-1) Make sure all the "Joins" and "Join strategy" are correct.2) Check for the cardinality.3) Create summary tables (one of the best approach in increasing the performance)4) Use Power play cubes as data sources.
-
Prompts in framework manager
How can you create prompts in framework manager?
sandeep8000861
- Jun 19th, 2008
We dont actually create prompts in FM.There is a property known as Prompt for each Query Item (field/column name). You just set this property to the required prompt type.After the properties are set, ...
b.srilakshmi
- Jun 12th, 2008
it showed be done in Frame work manageras#prompt('Parameter','datatype')#
-
Challenging task in report studio
What are the challenging tasks in report studio?
mayank_sanghvi
- Aug 2nd, 2016
The answer for this question is based on your work. For example for me its using Cognos SDK to run the report from Java and .Net Code.
jaga
- Jan 6th, 2012
Challenging tasks in reports are using parameters, complex calculations, bookmarks and complex prompts
-
How do you test reports in Reportnet
What do you record in unit test documents?
Pavithracts
- Jun 29th, 2008
In Unit testing we will check the fontsize,Filters etc as per in the requirement document all these things are recorded in the document.Only in system testing using toad software will match the toad records with report output in cognos.
sathish.devireddy
- Jun 12th, 2008
Generally we are using toad software.it is a predefined tesing software
-
Row Level Security
How will you provide security?How will you provide row level security?
liladd
- Oct 5th, 2009
You can use session parameters to map a data item to one of the ldap user values.depending on what you authentication source is and if the necessary values are there. EX: Your ldap has employee #, you...
-
Drill Through
What are the differences between drill through and master-detail relation ship
mahesh.amk
- Jul 11th, 2008
Master detail relationship is used to include large amount of info in a single report output where as a drill thru concept uses navigation from one report to another report
richardson
- Jul 9th, 2008
Drill thru navigates the summery level information to detail level information from report to report. (Parent-Child) ...
-
Factless Fact Table
Explain with an example for Factless Fact Table in Real Time Project ?
kranthi.kunta
- Aug 12th, 2008
Factless Fact Table: A fact table with a key section but without a measure section.? There are 2 types of factless fact table: 1. Event Tracking Tables: A table that records an event. Ex: A table ...
shree_uday
- Jul 19th, 2008
A Fact table, without any measures is called Factless Fact Table.For Ex.Survive Fact Table
-
Difference between filter & condition
What is the diff. between filter & condition? Explain with an example?
Mehul@DWH
- Oct 10th, 2008
Filter and condition are both the same things, when used in context of report creation, but if you mean condition with respect to report layouts, etc that apply to page design, then they do diffe...
avani_19
- Jul 25th, 2008
The major difference between query conditions and document filters is that a condition is applied to the query and limits the data retrieved from the database, whereas the filter is applied to the data in the document to hide information and display only the information that you want to appear
-
Cognos Explorer
What are the unique advantage of having 3 explorer in Cognos i.e 1) Page explorer 2) Query explorer 3)Variable explorer
fly2anshul
- 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...
-
Balanced Cubes and Sub Cubes
-
Conditional Formatting
What is Conditional Formatting? What you used finally in the Condtional formatting?
bvsr007
- Jul 17th, 2009
You can define the condition to control, what the user see when they run the report.By three ways we are doing the conditional formatting1) Boolean variable2) String Variable3) Report Language Variabl...
bkamila
- Oct 24th, 2008
Enhance a report by adding conditional formatting. For example, use conditional formatting to identify exceptional data in a report.
With conditional formatting, you can
hide and show objects
highlight data
add multiple layouts
create a multilingual report -
Cognos List report
How many rows can you add above a selected row in a list report
friswana
- Jan 6th, 2010
Answer is infinite.. But its better to restrict the number of rows based on the requirement to avoid performance issues..
sivabisani
- Nov 13th, 2008
I tried with this query we set rows upto 10000 and?infinet also.(it is casuing perfomance issue more than? 1000).Thankssiva
-
Report Studio Task
What is the most challenging task you have faced while working with report studio?
bonniewade1
- Jan 14th, 2011
Having to use a query that has 100 fields and 60,000 rows and getting maximum performance out of it.
Cognos Interview Questions
Ans