Forums
Lawson Business Intelligence/Reporting/Crystal
List of bursting rights, elements and users
Author
Messages
Donna
Veteran Member
Posts: 110
3/3/2016 8:02 PM
What tables have the bursting information fields?
Thank you.
Donna
Donna
Veteran Member
Posts: 110
3/3/2016 8:55 PM
Well, I answered my own question with a little help from the guru archives.
The tables are ERS_RULEMASTER, ERS_RULE DETAIL, ERS_ELEMENTS, ERS_STRUCTURE. There are additional tables in ERS but the ones listed solved my requirements.
Kelly H
Veteran Member
Posts: 167
3/29/2016 5:26 PM
Are these tables listed with your other Lawson tables? Or did you have to go to a different location?
Greg Moeller
Veteran Member
Posts: 1498
4/25/2016 11:22 PM
They are actually under the LBI schema (if you are running Oracle) They default to LawsonFS, LawsonRS, LawsonSN.. but your DBA could have named them anything.
MSSQL treats them a little bit differently... and they could really be anywhere.
Joan Herzfeldt
Veteran Member
Posts: 74
4/26/2016 12:03 PM
This might help. I prefer to create views and use crystal to format the data. Here is the view I created to pull our rights.
select
M.RULEID
, U.CONSUMERID AS USERORROLE
, M.RULENAME
, M.RULEOWNER
, M.STARTDATE --datetime field for CR
, M.ENDDATE --datetime field for CR
, D.STRUCTUREID, S.STRUCTURENAME
, D.ELEMENTID, E.ELEMENTNAME
, D.ELEMENTORDER
, V.SEQUENCEID
, D.OPERAND
, V.ELEMENTVALUE1
, D.ELEMENTVALUE2
, V.RULEGROUPING
FROM ERS_RULEMASTER M
JOIN ERS_RULEMAPPINGS U ON M.RULEID = U.RULEID
JOIN ERS_RULEDETAIL D ON M.RULEID = D.RULEID
JOIN ERS_RULEVALUES V ON D.RULEID = V.RULEID and D.STRUCTUREID = V.STRUCTUREID and D.ELEMENTID = V.ELEMENTID
JOIN ERS_STRUCTURE S ON D.STRUCTUREID = S.STRUCTUREID AND S.STATUS = 'A'
JOIN ERS_ELEMENTS E ON D.ELEMENTID = E.ELEMENTID
where M.STATUS = 'A' --active records
Joan
Donna
Veteran Member
Posts: 110
4/26/2016 8:41 PM
Nice
Lance Kelley
Advanced Member
Posts: 24
5/3/2016 6:59 PM
Thank you Joan.