If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Using MDL Script to add user group access rights

Started by robben, 21 Jan 2013 02:16:04 AM

Previous topic - Next topic

robben

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.