-
What is the usage of html object in tools box?
kiran_tsa
- Jul 22nd, 2009
By using HTML objects we can fulfill some requirement which is not possible directly by Cognos in built components. Example: If you want to know the report running time, Its not possible directly w...
ranganadh
- Mar 2nd, 2007
By using HTML object, We can insert multimedia file into report. At the run time we can see the file.Ranganadh,Bangalore.
-
What is a complex report, where it'll useful
simik
- Feb 24th, 2009
A complex report is a report that has multiple queries, variables, conditional formatting, advanced prompting, HTML items, JAVA scripts, images.
chinnuchaitu
- Feb 13th, 2007
Complex report is the one that shows a list chart, bar chart , product images etc to illustrate every thing whatever requirements are not predefined and are specific in a single report.Report Studio is a Web product for creating complex reports.
-
What is level span? How it is used in Cognos? what is the main advantage of level span.
mail2alert
- Dec 13th, 2007
Level span is used to eliminate duplictes in data, in cognos it is used repeat grouped item.using levelspan we can see the grouped data group by group.For example, when country and city are both group...
venu
- Sep 16th, 2007
Level Span is used to eliminate duplicates in a report which contains columns with one-one relationships. Usually we use grouping to eliminate duplicates when there is one to many relation. But if there is one-one relationship and still there are duplicates, then we have to level span.
-
How to Migrate reports from Cognos Impromptu 7.x to Cognos ReportNet
binduandme
- Mar 10th, 2009
From Impromptu to Reportnet we use a migration tool called cattoxml which you can find after installation in cer2/../bin folder go to command prompt and give the path of the tool and say cattoxml the...
g.malli
- Aug 23rd, 2007
I think in my view to migrate a report from impromptu to report net the administrator must configure impromptu on reportnet server with proper credentials then only we can open and logon, we should log on to both other wise we can't
-
Does Cognos 8.2 have the capability to mouse over a data field to allow a field definition to appear?
For instance, excel has a note indicator that signals to the user that there is a note or text item that is displayed if you hover over the cell. I am interested in adding a similar capability in my Cognos report design to help non-frequent data users to understand what they are looking at.
If this is a functionality, then please describe how it is done (i.e. Toolbox, etc.).bonniewade1
- Jan 14th, 2011
This can be done by adding a screentip to the data item in Framework Manager under properties.
sivabisani
- Nov 14th, 2008
Yes, Cognos 8.2 have the capability of mouse over a data field like tooltip, changing colors when ever mouse move to the dataitem. I am going to describe the tooltip. For example:Suppose we can take ...
-
How to create Cube from Power play transformer by using SQL Server Database(with out creating IQD file using Cognos Impromptu from SQL Server)
nilesh_tiwari
- May 28th, 2009
From the 8.3 version of Cognos you can use even a more wider variety of datasources than you could use previuoslyYou can just publish a package from Framework manager and use it as a source for creating cubes, no need of creating an IQDYou can also use any Cognos 8 Report as a source.
the_xxx
- Oct 16th, 2007
Power Play transformer supports wide range of Local Data Sources, you cannot connect to SQL Server Directly without creating IQD's. Below is he list of data sources which you can use as Data...
-
How can we use NVL function/Dataformat to resolve the Blank spaces in our report. Explain with navigation
binduandme
- Mar 10th, 2009
Yes this was the aproch in previous version but from Cognos 8 specifically from 8.3 you have no data option provided to handle missing values.
sivabisani
- Nov 14th, 2008
As per my understanding we need to put '0' i place of blanks that's correct?for this we can select the dataitems which have blanks and then goto properties pane then select the dataformat in that selc...
-
Restricted rows display to the report page which should divisible by 5
Hi Techies,
Need your help for achieving this requirement.
We have got a requirement to display a report in a page which should display max 20 rows but if a report is having totally 17 rows then in the 1st page it has to display 15 rows(divisible by 5) and the other two rows should appear in the next page. Similarly, If a report is having 23 records then in the first page it should... -
What different kinds of SQL you can write at the report level What is tabular SQL,Tabular Modal and Tabular Set
ranganadh
- Nov 23rd, 2007
1.Cognos SQLBy default, Framework Manager uses Cognos SQL to create and edit query subjects. Cognos SQL adheres to SQL99 rules and works with all relational and tabular data sources. Framework Manager...
Nageswara Rao Nandigam
- Nov 11th, 2007
There are two types of sql in Cognos Reportnet .They are Cognos Sql and Native SqlNative Sql used for single datasource to import the meta dataCognos Sql used for multiple data source to i...
-
Query Studio
Why we are prefer to query studio for simple reports and any extra feature is there in query studio other than report studio?
kempu
- Apr 30th, 2008
In cognos 8 we can open report studio report in query studio and conditonal formating also there in query studio
binay.bk
- Jan 24th, 2008
1)Query Studio is used create adhoc or simple reports where as Report Studio is used to create business & professional reports.2) You can open a Query Studio report in Report Studio,but u ca...
-
Import two data sources to Framework Manager in Cognos
please explain me How to import two data sources into Framework Manager?Can anyone tell me what is role of reporter writer in Cognos?
binay.bk
- Jan 24th, 2008
We can import two data sources to Framework Manager in the Run Metadata Wizard.Go to Run Metadata Wizard-->Select another database ( e.g. suppose SQL Server is choosed in prior attempt, then u can choose Oracle as new datasource).Then import it.
cognos.reddy
- Jan 11th, 2008
yes you can import two datasources in frame work manager like thisfor example you are having databases like "oracle,sql server" ok1) first you can import any one of the database(Ex. first i ...
-
Cognos Installation
How to install Cognos?
samirballal
- Mar 22nd, 2009
Go to the location where the report is saved on Cognos connection.Click on the name of the report. The report will run in the format already saved in the "Set? Properties" option.
velraj9
- Mar 12th, 2008
FOLLOW THE PROCEDURES1. a) Install SQL Server b) Then create Content Manager (New Database) In SQL Server c)Then apply securities such as Database login Id and user...
-
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.
Cognos Interview Questions
Ans