【转载】 Cognos资料库表描述

字数 5284阅读 3848评论 23赞 3

<DIV>一直对Cognos的资料库中存储的信息比较好奇。还曾经逐个表分析，想看下各个表之间存储的的内容，看看有没有对资料库的数据进行扩展的可能，不过之前一直没有找到类似数据字典之类的资料。</DIV>
<DIV>这两天在网上转悠找到一个国外Cognos牛人的网站，正好有一篇介绍资料库表描述的文章，特转过来与大家分享。 </DIV>
<DIV>本文来源：<A href="http://www.cogknowhow.com/">http://www.cogknowhow.com/</A></DIV>
<DIV>Cognos Content Store Database Tables Description </DIV>
<DIV>
<P>The Cognos content store tables are used by Cognos 8 as repository database. So a regular database backup is very important! All you folders, reports and security are stored in these tables. The table structure is created when the Cognos Cognfiguration Manager is started for the first time.<BR><BR>Table name   Descrition<BR><BR>CMSYSPROPS   This table has the Content Store Version.   <BR>CMOBJNAMES   This table has the names of all the objects in the content store.   <BR>CMOBJPROPS1   Users, Roles  Group Distribution list and contact information such as Email, phone number, Fax Given name etc are stored in this table   <BR>CMOBJPROPS2   Report scheduling information is stored. This table has fields like hour, day week etc   <BR>CMOBJPROPS3   Stores Screen Tip and Object description provided while creating the objects are stored here   <BR>CMOBJPROPS4   Stores the printer paper setting details like height and width of A3 , A4 , letter and 11X17 paper orientations   <BR>CMOBJPROPS6   Has the details of the all packages which were published using the FM.   <BR>CMOBJPROPS7   This table stores the XML of all reports and models. This is basically to maintain the metadata about the structure of the reports and models.   <BR>CMOBJPROPS10   Contact information is stored in this table. This table has columns like Contact Email and Contact.   <BR>CMOBJPROPS11   This table stores the data sources configuration details like connect string, the cube location etc.   <BR>CMOBJPROPS13   It stores the names of parameter passed to the range prompts   <BR>CMOBJPROPS14   Has details regarding the versions, creation time etc of the objects in the content store.   <BR>CMOBJPROPS16   This table provides the status of the multiple services of Cognos like LogService, MonitorService, ReportService, SystemService, JobService   <BR>CMOBJPROPS17   Stores performance details of each component like “query Studio, Analysis Studio, Event Studio” etc   <BR>CMOBJPROPS18   This table stores the drill path from the source to the final target report.   <BR>CMOBJPROPS20   Stores details regarding which are all the reports for which prompting has been enabled. And also has the details of which are the reports which has the                                  default report options overridden.   <BR>CMOBJPROPS24   Stores the printer configuration details   <BR>CMOBJPROPS25   Stores the data regarding the objects deployed, like the deployed folder, the reports, the number of folders present in the deployment archive, etc   <BR>CMOBJPROPS26   This table stores the data about all the packages imported / exported in C8, with the properties selected during the process.   <BR>CMOBJPROPS27   Has the details regarding the data source created in the content store using Cubes.   <BR>CMOBJPROPS30   Stores the registration , service description etc details about portlets in this table   <BR>CMOBJPROPS31   Has the custom logging level for each of the Cognos services, CMID can be be linked to CMOBJNAMES for the names of each of the services   <BR>CMOBJPROPS32   Has the details of the stored procedures used as the query items in the FM model.   <BR>CMOBJPROPS33   Detail related to users, user groups user roles.   <BR>CMOBJPROPS34   Has the details regarding the drill through parameters of the drill through reports. The parameter assign values are present in coded format   <BR>CMOBJPROPS36   Has the list of all the Models published using framework manager   <BR>CMOBJPROPS37   This table has the details of the routing sets configured for server / load balancing for each package published in the content store   <BR>CMOBJPROPS38   Configuration details about number of items to retrieve in studios, for a package are saved under this table.   <BR>CMOBJPROPS39   Has values for properties of reports and views. PROPID can be linked to CMPROPERTIES for property names   <BR>CMOBJPROPS52   Contains the properties for the connections   <BR>CMOBJPROPS55   Has the URI for icons for each entry in Cognos Connection   <BR>CMLOCALES        Has the locale ids associated with each language supported by Cognos 8   </P></DIV>

描述商业智能 cognos

著作权归作者所有

如果觉得我的文章对您有用，请点赞。您的支持将鼓励我继续创作！