Cognos Interview Qs

I was going thru Cognos Forum yesterday. Some of the Cognos Interview Qs- below (which i found in the forum)

1. what is mean by lookup command? where we use it?
2. what is mean by RCD.
3. how to provide security in Framework manager?
4. What is stitched query?
5. What is mode filters in FM?
6. What is meant by Business Key and Determinant?
7. What is ragged dimension?
8. What is the difference between Conformed and Shared dimension?
9. What is the difference between business key, member key and member caption?
10. What is layout component reference?
11. what is report expression
12. which web server u r using?
13. how many documents u have prepared?
14. Performance tuning of a report & also database tuning?
15. Can we create any folder(we have public & my folder),& how?
16. where will be report will be saved.& how will submit to the end user?
17. if any errors occurred what u will do?& to whom u will report?

Migrating from Cognos ReportNet to Cognos 8

Last week i was trying to upgrade the model and publish a Cognos ReportNet 7.3 FM Model to Cognos 8. When i was trying to achieve that i have faced some issues regarding the installation.

Following things are required to check this example:

1) Cognos ReportNet 7.3 Server and Framework Manager 7.3 installed.
2) Sample Cognos ReportNet FM Model which we are going to upgrade.
3) Cognos 8 Server and FM 8 installed

I created a sample model in FM 7.3 and saved the model for upgradint it. I have opened the model in FM 8 to upgrade it. When i give upgrade model, it will verify the model - when verifying the data sources and security settings need to be similar to Cognos ReportNet server. If those ojects are not available, the we have to create in C8 environment and verify the model. If setup is available, there will be no errors regarding those missing setup. Then we have to makesure all the tables used in model are present and then we have to verify eacn and every object.

Following are some errors when i upgrade the FM model:

Verify Model Report
Object: [GOSL].[PRODUCT]
Severity: BMT-MD-3010 Object contains deprecated key and index information.
Error: BMT-MD-2031 This object contains deprecated key and index information.
Repair: BMT-MD-3510 Keys and unique indexes will be converted to determinants as long as the object does not already contain determinants.
________________________________________
Object: [GOSL].[PRODUCT]
Severity: BMT-MD-3004 The object status is invalid.
Error: BMT-MD-2008 This object has a status of 'Needs Reevaluation'. Unable to validate this object.
Repair: BMT-MD-3512 The query subject will be reevaluated.
________________________________________
Object: [GOSL].[INVENTORY_LEVELS]
Severity: BMT-MD-3010 Object contains deprecated key and index information.
Error: BMT-MD-2031 This object contains deprecated key and index information.
Repair: BMT-MD-3510 Keys and unique indexes will be converted to determinants as long as the object does not already contain determinants.
________________________________________
Object: [GOSL].[INVENTORY_LEVELS]
Severity: BMT-MD-3004 The object status is invalid.
Error: BMT-MD-2008 This object has a status of 'Needs Reevaluation'. Unable to validate this object.
Repair: BMT-MD-3512 The query subject will be reevaluated.
________________________________________
Object: [].[dataSources].[GOSL]
Severity: BMT-MD-3999 An unknown error occurred.
Error: BMT-MD-2036 The following error occurred while testing the integrity of the object: QE-DEF-0314 An error occurred while calling the content store for the database: 'GOSL' information. CCL-RCI-0004 Content Manager returned an authentication fault. CM-REQ-4159 Content Manager has returned an error in the response header.
Repair: BMT-MD-3500 There is no repair action available.

Cognos 8.3 New Features

Hi,

Today i was jst wondering what might be the upgrades in the next version of Cognos which my firend was told me(Cognos8.3) . Following are the few updates i got from the site.


Thanks,
Soma

C8 and C7 comparison

C8 and 7 comparison

I am just curious how the XML tag organization was different between the cognos 7 and cognos 8 version. Since my client is in the verge of migrating to Cognos 8 environment. I was just comparing both the XML tags for a simple report. For comparison to be simple, i created a simple list report with 4 to 5 columns both in cognos 7 and 8. First i took the Query section alone, which usually will come before the report layout.

1) Since tabular model concept was not there in Cognos 8 there is no tag named in cognos 8.
2) Cognos 8 report will directly access the data item from query, so Cube, dimension and factlist tags are not present in C8.
3) The hierarchy of Query in C8 is
Queries > Query > Selection > Data Item.

Whereas in Cognos 7
QuerySet > BIQuery > Cube > Factlist and Dimension
> Tabular model > data item
4) There is one tag called Source in the query, i need to explore this. Will do in upcoming blogs if i come to know any.

Thanks and Regards,
Soma