Hi,
We are trying to do end-end automation of transformer security.We are in the process of updating the security table and user classes in content store using SDK and creating the custom views in transformer model using MDL scripts and then refreshing the cube.
Part of this process, we created a MDL script to create custom views at transformer model. But we could not associate this custom view to user class in cognos 8 name space.
Below is the MDL script code which we are using to create custom view.It is working fine. But the momment we try to include the userclass commands in the mdl, it is throwing us an error.
Can anyone help us regarding this?
Custom view mdl script:
ViewMake "Cards/Overdraft~View" Dimension "PRODUCT" ViewCustomView "Cards/Overdraft1" Apex "Cards/Overdraft"
CustomViewMake 12345 "Cards/Overdraft" DimensionView "PRODUCT" "Cards/Overdraft~View"
MeasureInclude "$ENR" Yes
MeasureInclude "$Total Unused" Yes
With the above command, we are able to create custom views successfully.
When we attach the below script to the above one, the mdl is throwing an error. Help is required to associate below script to mdl.
SecurityObjectMake "CAMID("":GAP:CGSUSR:CGSUSR_IPR"")"
SecurityNameSpace "Cognos" SecurityObjectDisplayName "CGSUSR_IPR"
SecurityObjectType SecurityType_Group CustomViewList 12345
Thanks in advance,
Sri.