-
-
-
How to show the data reported horizontally:(For example:)employee skill1 a1 b1 c2 d2 e2 fReport result:1 abc2 def
Assuming 3 records per grouped item:1. Group on employee2. Create a running count based on the skill field.3. Create 3 calculated columns based on the count field.Call them skill1, skill2, skill3:if (count = 1) then (skill) else nullif (count = 2) then (skill) else nullif (count = 3) then (skill) else null4. Create 3 more calculated columns using the maximum function. Call them maxskill1, maxskill2,...
cognos10consultant
- Feb 25th, 2012
To achieve this you have to create list first ...from the source tab add employee..after that click on toolbox tab add repeater as 2nd column...from the source tab add skill to the repeater...then we ...
prabakar.bi
- Mar 31st, 2009
I feel we can use the tool functionality to achieve this as follows.1. Create a list report having employee column2. Create a cross tab - contains emp in row and skill in column3. Provide Master Detai...
-
Handling Empty Reports
Can someone help me with the question below?
How can we handle Empty reports other than using "No Data Contents" option in Report Studio?
This question was posed to me in an interview.aba.aguiar
- Feb 1st, 2012
Specify Not to Render a Page If It Does not Contain Data You can specify not to render a report page if the page does not contain any data when the report is run. Steps 1. In the report page, click a ...
-
What is timestamp, when and where do you use this?
Devi Archana
- Jan 26th, 2012
A few of the date fields have a time stamp attached to them... time stamp is nothing but the time in the format of HH:MM:SS:NN.... for example.. i have an update today at 9:30pm then time stamp would be 26 January 2012 21:30:15:11
sasikalyan
- Dec 26th, 2011
These are called delta attributes. You could define only one delta attribute while creating generic delta. 1. Time stamp - The field is a DEC15 field which always contains the time stamp of the last ...
-
School time table in report studio
In which type of report we can create school time table in cognos? [I want period numbers in rows like period 1, Period 2, period 3, period 4, period 5 and class numbers in columns like 8th class, 9th class, 10th class and subject names in cells] Generally school time table is prepared in crosstab report, but subject names are not measures and a crosstab cell can not contain non-measures. This is my...
Ana
- Dec 19th, 2011
We can actually use numbers to represent the subject names, use these numbers as a measure and then by using string variable we can show the subject names in the measure section.
-
What is the size of the cube in ur project?what is the complex report u created in ur project and explain?how dimensions u have in ur project and how many facts?I am new to this dwh. so can anybody give the answers to the above?
Administrator wrote on Monday, 21 May 2007 01:48:53:-- test
hi chandra mohan
- Dec 19th, 2011
Qube size is 2GB but in Cognos 10 qube size may be increased to 2.5 GB or 3 GB
-
Framework Manager Dimensions
How to create Regular and measure dimensions? How we will use these dimensions in the report?
Lokesh M
- Dec 10th, 2011
A regular dimension organizes the information. It is stored in a hierarchy, from the highest level of granularity to the lowest. It usually has multiple levels. Each level requires a key and a captio...
-
What is cardinality and what are the security types?
Aruna2008
- Dec 10th, 2011
Cardinality, a component of relationship. defines how query subjects are related. 1..1 one and only one record from this side of the relationship 1..n one or more records from one side of the relati...
-
Measure Dimension
What is Measure Dimension?
Lokesh M
- Dec 8th, 2011
A measure dimension is nothing but a collection of facts.
A measure dimension can be created for one or more query subjects provided they have a valid relationship between them.
-
What is cast function, when and where do you use this?
sadique_ghitm
- Nov 24th, 2011
CAST is a complex function that transforms one or more values from one data type into another. .- >--+-------------------+--+----------------------+--------------> '-CCSID--expression-' '-ENCODIN...
-
Deployment Process
What is procedure of deployment in Cognos installation?
Jimmy Zorald
- Nov 20th, 2011
After completing the preceding configuration procedures, you can deploy IBM Cognos Now! on the application server. Start the IBM WebSphere application server, if it is not currently running, and open...
Namrata Gade
- Aug 13th, 2011
1. Copy contents of attached notepad file i.e. XML code of the report. 2. Launch Report studio, select package Package Name. 3. Open Report studio as a blank report. 4. In Report Studio, go to Tools -...
-
What is the best way to convert Crystal Reports to Cognos ?
FantaGuy
- Nov 20th, 2011
Crystal Reports and Cognos are fundamentally two different technologies with very different solutions. As per my knowledge, there are'nt any such ready tool to do the conversion. Though Cognos offers...
-
Poor Performance of Cognos Reports
How will you analyze the reason for poor performance of reports in Cognos 8?
-
Cognos Text Box prompt Issue
Hi ,suppose if a report contains n pages like page1,page2, upto pagen, in a textbox prompt when we enter 1 page1 should display,when i enter 2 page2 should display,can anyone suggest the answer?
-
Bubble Charts
What is Bubble Chart? Give an example for the usage of Bubble Chart?
-
Recursive Relationship
What is a Recursive Relationship?
-
Content Store and Content Manager.
Hi Friends What is main difference between content store and content manager?Give me one example for these related ?
krishnachaitanyaa
- Aug 1st, 2011
Content Store: It is Cognos Database.
Content Manager: It is the application which controls the Content Store .kadarla
- Jul 25th, 2011
A content store is a data base which stores the meta data of the reports.when we publish the project from framework manager it will save in the content store. It is configured in database layer. ...
-
Framework Manager Relationship Cordinality
Explain Relationalship Cordinality with suitable example
shailendra32
- Jul 23rd, 2011
cardinality tells the relationship how many rows from one of the query subjects defined in the relationship are expected to match a row in the query subject on the other side of the relationship. The...
-
Aggregation and roll-up aggregation
What is the difference between aggregation and roll up aggregation
shailendra32
- Jul 23rd, 2011
Aggregate Function Specifies the type of aggregation to apply. The Automatic setting means that the application groups or summarizes based on the data type. The Summarize setting means that any sett...
Cogbnos
- Jul 17th, 2011
Aggregate Function: This function specifies what type of Aggregation to be applied on a data item. The Aggregation can be of the types "Total", "Average", "Minimum", "Maximum" etc. Roll Up Aggregatio...
Cognos Interview Questions
Ans