Cognos8.3 BI自动刷新Cube简要配置(PDF)

Transformer是Cognos V8.3多维分析模型设计工具，经过前几个本版的演变，部分功能已经整合在Web Server服务中，没有独立的Powerplay视图工具，在7.3的版本有PPES服务，可以调整Cube视图展控件、样式、服务发布等功能。虽然Transformer在原有基础上做了简化，但相应的功能集成到了BI Web Server服务中，以致用户操作与调整配置相对繁琐。前些时间与Cognos技术工程师交流，也提到最版本存在缺陷是在所难免，往后版本中会更加人性化和美化界面。国内BI圈内很难找到Cognos全方位系统教学资料，因各行各业都在使用Cognos工具，从众多BI项目中，使用Cognos产品其中一部分功能组件。大多数BI分析系统在前端开发都是满足客户OLAP分析、报表、即席查询三大模块。

在Windows环境模型设计、手工运行比较简单，而对于一个庞大的数据仓库系统，按照业务部门需求来定义数据集市，根据需求设计不同类型的分析主题，同时设计的OLAP分析模型也增多。在设计阶段，感觉不到分析模型给系统的压力，必须考虑利用调度工具来自动运行，这样可以大大减少维护工作压力，可利用系统资源空闲时运行。

Cognos系统配置检查

打开Cognos Configuration配置，检查“Authentication”下的认证配置，如：dbAuth 是第三方认证登录域名。在下图中：A区 和 B区 的 “dbAuth”名字必须相同时，调用批处理命令行加载登录信息才能通过认证。

注意：“Authentication”下的登录认证域名可以自定义，但配置Transformer Cube刷新，同时又认证登录，必须要求名称一致。

Transformer设置

打开模型，在工具栏“View”下拉选择“Signons”，新建一个Signon，取名为“dbAuth”。

在Signon窗口，输入“dbAuth”，按下图填好配置，点击“确定”按钮，同时保存模型。

对于老模型，需要调用第三方认证的“dbAuth”管理，在Custom View窗口增加“dbAuth”域名下的角色，并限制机构权限。见下图：

确保参数配置下的日志已经打开。

AutoRun命令编辑

在Windows环境中，最好单独建立子目录来管理批处理命令，有利Cognos管理与维护。

Cube、案例如下：在服务器上创建一个D:\\GLIC-SQLSERVER_OLAP\\文件夹，用来保存模型、日志、数

据源文件等目录。

Mdl_AutoRun.bat代码如下：echo offcls

cd D:\\Program Files\\cognos\\c8\\bin

cogtr -c -n2 -mD:\\GLIC-SQLSERVER_OLAP\\Models\est_001.mdl -ldbAuth=admin/111111

********************************************************************************************自动生成Cube后，通过批处理程序自动把Cube更新到PublishCubes目录下，首先要停止Cognos 8服务。*再复制最新的Cube文件，之后启动Cognos 8服务。

*******************************************************************************************MoveCube_StopStartCognos8.bat代码如下：

echo offclsnet stop \"Cognos 8\"net stop \"Cognos Content Database\"cd D:\\GLIC-SQLSERVER_OLAP\\PublishCubesdel多元行销指标.mdccopy /Y D:\\GLIC-SQLSERVER_OLAP\\PowerCubes\\多元行销指标.mdc D:\\GLIC-SQLSERVER_OLAP\\PublishCubesnet start \"Cognos 8\"net start \"Cognos Content Database\"exit附Command Line Options Transformer supports the following Windows and UNIX/Linux command line options. Detailed explanations are provided in the subsections that follow.Command line options are case-insensitive. OptionMeaning-a Runs AutoDesign then creates a cube, opens PowerPlay (Windows), and displays the report.cogtr -a data_sourceRestriction: Use on Windows only, with -d, -f, -r, and -nologo options.-c Generates categories and creates cubes.-c -pfilename.py?|-mfilename.mdlRestriction: Use with -i, -m, or -p. -dOverrides the specified user preference setting.-dpreference_var=setting -pfilename.py?|-mfilename.mdl-e Updates the model structure but not the data.-e -pfilename.py?|-mfilename.mdlRestriction: Cannot be used with -c; use this option with -n and -o.OptionMeaning-fSpecifies the user-defined preference file.Can be used to publish PowerCubes in batch mode and include prompts in an XML command file us­ing the XML schema for preference files.-fpreference_file -pfilename.py?|-mfilename.mdl-iOpens the specified .py? model and restarts a failed process from the beginning.-i -pfilename.py?Restriction: On UNIX and Linux, cannot be used with -s.-hDisplays help for the command line.cogtr-h-kSpecifies database signon information for Series 7.-ksignon=userid/password -pfilename.py?|-mfilename.mdl-lSpecifies user authentication information for Cognos 8.-lsignon=userid/password -pfilename.py?|-mfilename.mdl-mOpens the specified .mdl file or accepts Model Definition Language (MDL) statements.-mfilename.mdlRestriction: On Windows, use with -n.-nRuns cogtr in batch mode.-ndisplay_state -pfilename.py?|-mfilename.mdlRestriction: Use on Windows only.-nologoOmits splash screen display when opening Transformer.-nologo -pfilename.py?|-mfilename.mdlRestriction: Use on Windows only. -oTurns off various model and cube creation actions.-o -pfilename.py?|-mfilename.mdl-oxDisables category creation and cube rebuild.OptionMeaning-ox -pfilename.py?|-mfilename.mdlRestriction: Use on Windows only. -pOpens the specified binary model file, .py?, where the question mark (?) is replaced by the charac­ter that is used in your version of Transformer-pfilename.py?Restriction: Not valid with an MDL file.-rSpecifies the level of detail for error-logging reports.-rlog_level -pfilename.py?|-mfilename.mdlRestriction: Valid levels are 0, 1, 2, 3, and 4.-sSaves the model.-s -pfilename.py?|-mfilename.mdlRestriction: On Windows, use with -n; cannot be used with -i or -p.-tSets the current period.-tcategory_code -pfilename.py?|-mfilename.mdlRestriction: On Windows, use with -n.-uGets the partition status for previously generated cubes.-upowercube_name -pfilename.py?|-mfilename.mdlRestriction: Cannot use this option with secured cubes. On Windows, use with -n.-vSpecifies the number of records for the test cube.-vdata_subset_numberRestriction: Use with -c, -m, or -p. -xUpdates the column and measure scales based on the data source.-x -mfilename.mdl-ySpecifies how Series 7 user-class security conversion is performed.•Use -y1 to preserve both the Series 7 user classes and custom views associated with the Series 7 model.OptionMeaning-y1namespaceName=username/password•Use -y2 to preserve only the custom view associated with the Series 7 model. cogtr.exe -n2 -ox -s -y2 -mfilename.mdl•Use -y3 to discard the Series 7 user classes and custom views associated with the Series 7 model. cogtr.exe -n2 -ox -s -y3 -mfilename.mdl