Hyperion Planning RDBMS tables

To get Native USers Belonging to native groups in HSS
-------------------------------------------------------------------
select c1.name,c2.member_identity,c3.name  from css_groups c1,css_group_members c2,css_users c3
where c1.identity_id=c2.group_identity and c3.identity_id in c2.member_identity
order by c1.name


To Get users belonging to each native group in HSS
----------------------------------------------------------------
select c1.name,c2.member_identity from css_groups c1,css_group_members c2
where c1.identity_id=c2.group_identity
order by c1.name

Provision Report for Roles on Groups in HSS
-------------------------------------------------------
select p.application_id,p.createdtimestamp,c1.name,o.name,o.locale from css_provisioning_info p,css_groups c1,css_role_locales o
where p.member_identity in c1.identity_id and p.role_identity in o.identity_id and o.locale='en_US' and p.application_id like '%PLNAPP%'
order by c1.name

Object Types in Classic Application
Scenario=31,Account=32,Entity=33,Version=35

Object Types in EPMA Application
Scenario=134,Account=127,Entity=130,Version=155{Period=132,Year=157}