-
Generate reports without package.
How to generate reports without package?
shree_uday
- Aug 8th, 2008
Without package we can generate a reports in Cognos by using Query Explorer. Using QE, we can drag a SQL icon from the toolbox, and go to properties, there you can see the datasource tab, then double click, it will open SQL query window, there you can?type?the customized SQL query.
-
What is the process of Cognos Testing
Can u give me small example of cognos testing?
arunkiranrega
- Aug 11th, 2008
Cognos unit testing includes1) Data checking - you need to match against data exactly what you desired2) You need to check the data format - eg check number of decimal places,date format,time format 3...
-
How to limit the output in a report for testing?
Let us assume that I have to create a report whose output has 1 Million rows. When I create the report and run it may take several hours to show me the complete report. So can I limit the output to just 100 rows to save time while testing the report? Thanks in advance.
arunkiranrega
- Aug 11th, 2008
You can limit data by applying filter on some query item - for example if you have somany contract ids - you can apply filter contract id -1234
-
Cognos - Display Text Item every page
Hi All,I am new in Cognos, I want to display Text Item in every page but there is no option anybody know this answer please help me
-
What are complex reports?
Hello,what are complex reports and normally what issues do we face while creating complex reports in report studio?Please help me soon on this question.
arunkiranrega
- Aug 11th, 2008
Another report was likeIt had 5 to 6 joinsIn impromptu we have hotfiles and picklistsWhereas in c8 we dont have hotfiles so we need to create a separate query for the items coming from the hotfiles an...
arunkiranrega
- Aug 11th, 2008
My project migrates reports from impromptu to c8One of the complex reports has 128? items, 28 queries and it has?very lengthy calculated data items. Conditional formatting was appliedLayout is not a...
-
What is IQD?What is contained in IQD? How you create IQD In ReportNet FrameWork?
Amedhyaz
- Aug 12th, 2008
Impromptu Query Definition - Database metadata - Select the query subject items in FM that we want to export in the form of an IQD and select the right option from the contextual menu.
jyothsna
- May 12th, 2006
An .iqd file is typically created by Impromptu and contains the definition for a database query.PowerPlay Transformer can access relational data sources via Impromptu Query Definition files.If Impromp...
-
Factless Fact Table
Explain with an example for Factless Fact Table in Real Time Project ?
kranthi.kunta
- Aug 12th, 2008
Factless Fact Table: A fact table with a key section but without a measure section.? There are 2 types of factless fact table: 1. Event Tracking Tables: A table that records an event. Ex: A table ...
shree_uday
- Jul 19th, 2008
A Fact table, without any measures is called Factless Fact Table.For Ex.Survive Fact Table
-
Cognos 8 Balance Sheet
How to create a balance sheet in Cognos 8?
-
What is the Cognos report development life cycle?What are the phases involved in the report development?
angel987
- Aug 22nd, 2008
1. Getting the requirements for report creation. (could be any functional document)2. Tables creation.3. Working on the framework manager for data modelling4. Starting report development acc...
-
Cube Output Formats
What are the various cube output file formats? What are the diffrences between them?
-
Materialized view
If there is no calculations and the data is summerized, will you use Materialized view? Give Reason
angel987
- Sep 5th, 2008
They can be used to summarize, precompute, replicate, and distribute data.but if there are no calculations needed and the summarization is already been done then not sure if we need to use them..
-
Balanced Cubes and Sub Cubes
-
Remove or Deny access to Studio Link
How to Remove (or deny access) a particular Studio Link from Cognos Connection Screen for a User?
-
Drill through functionality
According to my exp i am explaining to u drill through will work in list and cross tab reports is fine.Can we use the Drill through functionality in Charts?
vidiyala337
- Sep 15th, 2008
You can apply drill through for charts only in Cognos 8, but it wont work in Report Net.
ksrinivas13
- May 13th, 2008
yes, we can use in charts also, in list and crosstab reports we will apply for a specific column but in charts we will apply for whole chart bec'z when we right click on specific column we wi...
-
Check Report Data
How to check the data in SQl whether the data is correct or not which is generated in the report. the link should be from cognos portal.
-
Cognos Explorer
What are the unique advantage of having 3 explorer in Cognos i.e 1) Page explorer 2) Query explorer 3)Variable explorer
fly2anshul
- Sep 18th, 2008
Here it goes: Page explorer: You use this to navigate through pages of a report (page by page). You can also use this to add more pages to your report.Query Explorer: You use this to view or modify th...
-
Various versions of Cognos
What are the various versions of Cognos showing year wise from the start to latest?
-
1.How will u implement drill-thru from powerplay to impromptu?2.How will u highlighting the data other than conditional formatting?3.What is 4-4-5 weeks in powerplay?Why r u using this?4.Why r u using multiple data source?and why cant u use single data source?5.How will u improve the performance of the cube?6.How will u relate the sources in transformer?7.Have u faced any errors while generating the models?8.What is uniqueness error?9.What is the use of Unique property?10.Why there is a property called move?what is its use?11.If u right-click one level u can see the properties?In that one drill thru property is there in source tab?What is the use of this?12.What is use of before rollup and after rollup?
ripirr
- Oct 10th, 2008
Try to limit the data in the iqds to the bare minimum, i.e., only fetch the data that is essentially required in your report via the iqds and check the 'auto-partition and passes' on the cubes...
ripirr
- Oct 10th, 2008
Why do we use multiple data sources?Ans - It is a good practise to separate the FACT and Dimension IQDs, the dimension iqds execute quickly while the FACT iqd takes longer time to generate data/popula...
-
Difference between filter & condition
What is the diff. between filter & condition? Explain with an example?
Mehul@DWH
- Oct 10th, 2008
Filter and condition are both the same things, when used in context of report creation, but if you mean condition with respect to report layouts, etc that apply to page design, then they do diffe...
avani_19
- Jul 25th, 2008
The major difference between query conditions and document filters is that a condition is applied to the query and limits the data retrieved from the database, whereas the filter is applied to the data in the document to hide information and display only the information that you want to appear
-
Framwork Manager
How to implement the Models in the FWM?
Cognos Interview Questions
Ans