Cognos 10 - Active Reports
What are active reports in Cognos 10 BI ?
These are the disconnected and interactive reports developed for the employees, buisness parterners and business managers who are not connected to intranet and need anlaytical information for quick and better decision and actions.
IBM Cognos Active Report produces reports that are an extension of existing IBM Cognos Report Studio values and the IBM Cognos Platform. Users continue to benefit from the enterprise value of one version of the truth, and new interactive control types in IBM Cognos Report Studio serve as building blocks for creating active reports.You use active report controls to create the layout of an active report and to filter and sort data in the report.
What are active reports in Cognos 10 BI ?
These are the disconnected and interactive reports developed for the employees, buisness parterners and business managers who are not connected to intranet and need anlaytical information for quick and better decision and actions.
IBM Cognos Active Report produces reports that are an extension of existing IBM Cognos Report Studio values and the IBM Cognos Platform. Users continue to benefit from the enterprise value of one version of the truth, and new interactive control types in IBM Cognos Report Studio serve as building blocks for creating active reports.You use active report controls to create the layout of an active report and to filter and sort data in the report.
Cognos HotFile
A HotFile is a flat sequential file. It acts as a separate local data table that can be added to your
catalog or used in a report as if it were a database table. Both the data and the definitions are
stored in the HotFile.
Once created, a HotFile is independent of the database columns from which it was created, and
you can use it in any report or catalog. You can join a HotFile to database tables, reports, or other
HotFiles.
Limitations of HotFiles
Below are some limitations surrounding the use of HotFiles:
- It exist on the client side.
- They are not indexed, and thats why, joins may takes longer execution time. Also,Impromptu must use Sort/Merge and sequential scan to filter.
- HotFile size is limited. However, it should not be used to store very large query results as they could slow computer performance.
A HotFile is a flat sequential file. It acts as a separate local data table that can be added to your
catalog or used in a report as if it were a database table. Both the data and the definitions are
stored in the HotFile.
Once created, a HotFile is independent of the database columns from which it was created, and
you can use it in any report or catalog. You can join a HotFile to database tables, reports, or other
HotFiles.
Below are some limitations surrounding the use of HotFiles:
catalog or used in a report as if it were a database table. Both the data and the definitions are
stored in the HotFile.
Once created, a HotFile is independent of the database columns from which it was created, and
you can use it in any report or catalog. You can join a HotFile to database tables, reports, or other
HotFiles.
Limitations of HotFiles
Below are some limitations surrounding the use of HotFiles:
- It exist on the client side.
- They are not indexed, and thats why, joins may takes longer execution time. Also,Impromptu must use Sort/Merge and sequential scan to filter.
- HotFile size is limited. However, it should not be used to store very large query results as they could slow computer performance.
well explained .Keep sharing Cognos TM1 online training Bangalore
ReplyDelete