-
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...
-
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 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.
Cognos Interview Questions
Ans