[Datamart-News] OBIEE Subject Area update

[Datamart Support * DAS]

OBIEE users,

Based on some great suggestions from users around the state, we have improved a few subject area in OBIEE.

The Tdate table in the Datamart is now a part of the Accounting Event (All, Archive, & Active) subject areas. It is now displayed within the 'Profile' folder of these subject areas. This allows for the joining of the main accounting data to the Tdate table.

The Tdate table is still a stand-alone subject area as well (SFMS - Profiles: Tdate), which has not changed.

The Tdate table is built using many formula which helps create the calculated fields within it. The field formulas are based off the 'effective date' field, therefore, the name of the new OBIEE folder is 'TDATE_Effective_Date'. This should help remind users how the values are being determined.

Please let me know if you have additional questions.
Thanks,
Aaron Wallace
Sr. Datamart Business Analyst

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20211027/cbc62501/attachment.html>