eg: To find cognos parent and child security group relationship information using sql query
SELECT rel.cmid parent_group_id, rel.cmid child_group_id, grp.CMID, cn.NAME AS child, cn1.NAME AS Parent FROM
cmreford1 rel
Inner join cmobjects grp on rel.refcmid = grp.cmid
Left join cmobjnames cn on grp.cmid = cn.cmid
Left join cmobjnames cn1 on rel.CMID = cn1.CMID where
grp.CMID in (948, 959) AND cn.mapdlocaleid = 24
|
Parent
|
Child
|
|
Country
|
State
|
|
State
|
City
|
SELECT rel.cmid parent_group_id, rel.cmid child_group_id, grp.CMID, cn.NAME AS child, cn1.NAME AS Parent FROM
cmreford1 rel
Inner join cmobjects grp on rel.refcmid = grp.cmid
Left join cmobjnames cn on grp.cmid = cn.cmid
Left join cmobjnames cn1 on rel.CMID = cn1.CMID where
grp.CMID in (948, 959) AND cn.mapdlocaleid = 24
Managing a business data is not an easy thing, it is very complex process to handle the corporate information both Hadoop and cognos doing this in a easy manner with help of business software suite, thanks for sharing this useful post….
ReplyDeleteRegards,
cognos Training in Chennai|Best COGNOS Training Institute in Chennai