BIEE 通过地址栏外部登陆

一，设置Session初始化块。

select ':USER',
       'PASSWORD' as PASSWORD,
       decode(b.nodelvl, 3, 'GROUP_CITY', 2, 'GROUP_PROV', 'GROUP_ALL') as USER_GROUP,
       a.area as USER_CNTY_ID
  from sjzf.om_organization a, sjzf.om_area b
 where a.area = b.area
   and a.orgid in
       (select orgid
          from om_employee
         where userid = ':USER'
         )  

 

 

二，地址栏上的URL后面添加&UQUSER={userid}