-
How to use Lookup Command?
zecar
- Sep 19th, 2007
The syntax is as follows: LOOKUP (name) in (value1 --> value2) default (name)Name: the name of your columnvalue1: value you would like to be replacedvalue2: value you would like to replace it withd...
narender
- Jul 23rd, 2007
By using parameter map
-
-
What is refreshing of a cube and how can we do it
ravimantur
- Jun 12th, 2009
Refreshing the cube fetches the latest data to the cube. Which can be used to extract the latest reports out of it. Inorder to refresh the cube right click on the cube in powerplay transformer you will get an option refresh cube click on it and its done.
chinnuchaitu
- Feb 13th, 2007
Refreshing the cube means it just gets the latest data and there is a option Refresh to do so.
-
How can we create reports in query studio?
ASHOK1324
- Apr 23rd, 2009
We can access "Query Studio" to create and view simple reports via cognos connection after selecting the package that got imported from cognos content store. We can now select Required Query Items from different Query Subjects to generate ad-hoc reports.
Rajitha
- Dec 14th, 2006
Through Cognos Connection we can access the Query Studio After that we can select our Package(Which one u imported DataBase). We Can select Required Query Items generate the reports. Its Generate Adhoc Reports.
-
-
What is meant by dash boards/flash cards?
simik
- Feb 24th, 2009
Dashboards are reports created using graphs and charts as a mechanism of presenting information.Dashboards communicates complex information quickly. They translate information from your various corpor...
rkiranbedi
- Mar 5th, 2007
Dash Board reports are used to create many reports in one report like Gauge chart, Progress chart, Combination Chart and so on. It combines Multiple Queries into a same chart are multiple charts.
-
-
-
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...
Cognos Interview Questions
Ans