关于TM的权限问题

xiaoerp

我有一个疑问，就是TM中的custom views，如下图


假设如果有，20个custom views 去过滤各个机构，这样的cube又有50个，怎么办？
总不能一个一个添加吧，有没有批量法子？呵呵。

xiaoerp

OpenMDL "E:\cube_mdl\fs_15_02.mdl"   --   没有权限的MDL
SecurityNameSpaceMake "dbAuth" SecurityNamespaceCAMID 'CAMID ("dbAuth")'
ViewMake "43000600~UserView" Dimension "机构" ViewSecurity "43000600~CustomView" Apex "43000600"
CustomViewMake "43000600~CustomView" DimensionView "机构" "43000600~UserView"
SecurityObjectMake 'CAMID("dbAuth:r:43000600")' SecurityNamespace "dbAuth" SecurityObjectDisplayName "43000600" SecurityObjectType SecurityType_Role CustomViewList "43000600~CustomView" EndList
ViewMake "51000600~UserView" Dimension "机构" ViewSecurity "51000600~CustomView" Apex "51000600"
CustomViewMake "51000600~CustomView" DimensionView "机构" "51000600~UserView"
SecurityObjectMake 'CAMID("dbAuth:r:51000600")' SecurityNamespace "dbAuth" SecurityObjectDisplayName "51000600" SecurityObjectType SecurityType_Role CustomViewList "51000600~CustomView" EndList
ViewMake "8244444~UserView" Dimension "机构" ViewSecurity "8244444~CustomView" Apex "8244444"
CustomViewMake "8244444~CustomView" DimensionView "机构" "8244444~UserView"
SecurityObjectMake 'CAMID("dbAuth:r:8244444")' SecurityNamespace "dbAuth" SecurityObjectDisplayName "8244444" SecurityObjectType SecurityType_Role CustomViewList "8244444~CustomView" EndList
PowerCubeCustomViewListUpdate Cube "fs_15_02" StartList "43000600~CustomView" "51000600~CustomView" "8244444~CustomView"  EndList   -- 中间权限部分
SaveMDL "E:\cube_mdl\20091106_197\fs_15_02.mdl"  --  刷过权限的mdl保存位置

把上面的文本存成mdl后缀, 用transformer打开一下就行了