Hello ,
I hava a question on user access right of Cube:
the requirement is to create a hierarchy as following (screenshot1, created in transformer).
However when trying mdl script to create the same, the first level "GCPO-Beijing" cannot display (refer to screenshot 2)
Our mdl script is as following, and it's mandatory to make it via script according to the requirement...
OpenMDL "D:\EiSCognos\Models\AAPCube2.mdl"
SecurityNameSpaceMake "s7"SecurityNamespaceCAMID 'CAMID("s7")'
SecurityNameSpaceUpdate "s7"SecurityNamespaceCAMID 'CAMID("s7")'
ViewMake "GCPO-Beijing~User view"
Dimension "Orginzation"
ViewSecurity"Orginzation#2_GCPO-Beijing"
Apex "GCPO-Beijing"
CustomViewMake "GCPO-Beijing"
DimensionView "Orginzation""GCPO-Beijing~User view"
SecurityObjectMake'CAMID("s7:r:authid=1002338267")'
SecurityNamespace "s7"
SecurityObjectDisplayName"Orginzation"
SecurityObjectType SecurityType_Role
CustomViewList"GCPO-Beijing" EndList
PowerCubeCustomViewListUpdate Cube"AAPCube2" StartList
"GCPO-Beijing"
EndList
savemdl "D:\EiSCognos\Models\AAPCube2.mdl"
So, how to edit 'mdl script' to achieve the requirement, I need help, thanks in advance.