-
What is the use of Generated Prompt?
what is the use of Generated Prompt? Can u give Complete information with scenario
Cognos
- Jul 17th, 2011
The prompt should be used when you are not sure of which type of prompt best suits for requirement.
shailendra32
- Jul 15th, 2011
Generated Prompt is a kind of prompt which automatically chooses & display any of the other prompt(Text prompt,value Prompt etc) at run time according to the data type of the data item added for the f...
-
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 it will be work?What is difference between Cognos and Cognos ReportNet?How do you create cube in ReportNet?There are 10 facts are there.How will you connect all?
I need answer
fpaulraj
- Jun 17th, 2011
Macro is a object embeded with in the query or the sub query which can be executed while runing the query.
fpaulraj
- 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...
-
What is the limitation of Page Footer in Report Studio
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activities from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please let me know what's max. limit of the Page Footer. I tried with around 300 activities and page...
-
-
-
What type problems we can face in general at report runnig time
bonniewade1
- Jan 14th, 2011
1) Report performance - Prompt page takes a long time to load or the report takes a long time to generate.2) Data is not accurate in the report.3) Ambiguous columns4) Time/date filters do not match ...
Anindita Ghosh
- Apr 5th, 2006
the most common problems are -1.No Data Appears in the Report (to remove this check data source or package)2.Unexpected or incorrect values appears in reports , may be report is running with limited d...
-
Cognos connection
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?
bonniewade1
- 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...
angel987
- 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.
-
Framework Manager
What is significance of Framework Manager in Cognos Reporting
bonniewade1
- Jan 14th, 2011
Framework manager is used to create the data model and table joins. Prompts can be setup on the framework side as well as calculations. When calculations and prompts are setup on the f...
ananya18
- Jul 7th, 2008
The format that the column value uses. For example, if Display Type is set to picture, MIME Type could be jpeg. This property is for query items only. Note: The MIME Type property is not used by SAP BW.
-
What is the difference between Calculated Measure and Measure Folder?
bonniewade1
- Jan 14th, 2011
A calculated measure is data item values that have been transformed into one value.A Measure folder is a folder used to stored calculated measures.
-
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 ...
-
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.
-
Report Scheduling
How do you schedule reports in Cognos?
santhosh243
- Jan 12th, 2011
We can do by setting schedule in individual report properties or can be done using event studio.
-
FrameWork Manager Properties
Explain the limited local and database only properties in Framework Manager? Why do we use these properties?
itgowrishankar
- Dec 8th, 2010
"Limited locally" and "Database only", those are called as query processing methods. Database only: All queries are processed by Database instead of Cognos. If it is failed&n...
-
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.
-
Framework Manager
What is usage property? Where do we set usage property? What is usage property for fact and dimension tables. What are the properties of usage property?
sreenu007
- Oct 18th, 2010
Usage property means it identifies the intended use? for each reprasentation of the query items. Its different types are Identifier, Facts, Attributes and unkown. These are available under properties of query items.
ASHOK1324
- Apr 23rd, 2009
Frame Work Manager allows the users to model metadata and publish the packages.
-
Cognos Dashboards
How to create Dashboards in Cognos
kishore.g
- Sep 11th, 2010
select "file" menu click on newselect "blank" click okfrom "tool box" drag the table drop on blank layoutset the no.of coloumns: 2set the no.of rows: 2select show ...
-
Master Detail Report
What is advantange and disadvantage of Master Detail report?
kishore.g
- Sep 11th, 2010
The main advantage of master detailed report is two list reports can be merged using this report and there should be a common query item between the two list reports.
-
Create New Report
How can we create a new report using Cognos Impromptu?
sidney
- Jul 27th, 2010
Open Cognos Impromptu, select file>newBingoYou'll have to select the type of report you want to create list, cross tab etc
-
What is the difference between group and associate?
sreenu007
- Jun 5th, 2010
GROUP is used to suppress the duplicate values having one to many relations.Associate is used to suppress the values having one to one relations.
rkiranbedi
- Mar 27th, 2007
group is used to eliniminate Duplicates,Where as Association is used to make one to one relation ship between to columns.ProctLine ProductName &nbs...
Cognos Interview Questions
Ans