-
What are the steps involved in migrating CRN enviroment to Cognos 8
simmidear
- Nov 12th, 2008
migrate all at a time from ReportNet to Cognos8(Frame work Manager, Reports, Cube)------------------------------------------------------------------------------------------In ReportnetOpen content sto...
-
How to migrate report net to cognos 8
How to migrate reports from reportnet to cognos 8
sivabisani
- Nov 13th, 2008
Hi,In the cognos 8bin directory, there is a tool call RSupgrade.bat, we can use this command to convert Reportnet report spec to Cognos 8.NOTE: RSUpgrade.bat / RSUpgrade.sh is a standalone u...
-
Cognos security
How we will provide security to the reports in cognos8?
sivabisani
- Nov 13th, 2008
Hi,For reports we apply the security in Cognos connection.go to cc from the actions->setpropertiesicon->permissions->click the check box overide the permission and then set required properties to protect to ur reports.Let me know if u have any another solution.Thankssiva
-
List Report
How to create a list report with use of excel?
-
Framwork Manager
How to implement the Models in the FWM?
-
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
-
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...
-
Various versions of Cognos
What are the various versions of Cognos showing year wise from the start to latest?
-
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...
-
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.
-
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...
-
Remove or Deny access to Studio Link
How to Remove (or deny access) a particular Studio Link from Cognos Connection Screen for a User?
-
Balanced Cubes and Sub Cubes
-
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..
-
Cube Output Formats
What are the various cube output file formats? What are the diffrences between them?
-
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...
-
Cognos 8 Balance Sheet
How to create a balance sheet in Cognos 8?
-
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
-
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...
-
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...
Cognos Interview Questions
Ans