-
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...
-
Report Page Breaks
How page breaks work in the report?
sreenu007
- Jun 3rd, 2010
In Cognos8 version we have one option directly.see for eg if you break on country page breaks, first select that column and select structure tab, in that we have one option call 'page break'. select t...
-
1.diff between drill down and drill through?2. what is meant by roll-up?3.what is meant by external roll-up?how to create external rollup with example?4.what is meant by clean house command?5.what is meant by scope?what are types?explain them6.what is meant by cube groups?how to create cube groups?there is any simplest way to create cube groups?7.what is meant by alternate drill down with ex?8.how many cubes you are created till now?9.what is the size of the present cube?10.why you choose Ex-files and flatfiles instead of iqd?11.what is meant by partition?How To create?12.how to create time state Partition13.model contain ____________? cube contai___________?14.what is distinct measure?
Shwethadeepu
- Apr 13th, 2010
Answer to Qn. 4. Cleanhouse command removes all the categories generated during the cube build.
ravimantur
- Jun 5th, 2009
Drill down is like in time dimension from year to qtr to month to week etc., In drill through you cannot only drill down in a single dimension but you can go to the next dimension as well.EG take 3 di...
-
How to pass multiple values from picklist prompt to sub report filter
The sub-report only includes the first value."When the sub-report query runs, it checks for the first row in the Customer Name column and shows only information for that customer. If you want a sub-report to show information for another row in the column, place the main report in a form frame that shows only one row at a time. When you insert the sub-report into the form frame as well, it changes as...
cognos.kishore
- Feb 5th, 2010
Create 2 reports in do this actions in 2nd report(detailed Report)Create 1 prompt here 'Ex value prompt on Customer name 'Create one filter on date field 'like IS_CURRENT=?P_IS_CURRENT...
-
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
-
Run the Report
How can we run the Report without using "Run Report" option in Cognos
-
How can create users and permissions in cognos
vpulender
- Nov 27th, 2009
In Cognos Connections we can only able to create Groups,roles and contacts.But if we want to create new users we have to log on Cognos Access Manager there we can create users andWe can grant the permission based on their requets like for specific Folder or reports..
swift_s
- Jun 11th, 2009
Users and Permissions can be given in Access manager - Administration. Individual users can be created using their names or their Ids (if any) in Access manager and then be given permissions. This tool is loaded when you install Cognos 7.x in your machine.
-
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...
Cognos Interview Questions
Ans