[Datamart-News] Enterprise notification of exploring OBIEE successor

[WALLACE Aaron * DAS]

Datamart users,

We are starting the process to identify the next tool the Datamart team will use to access the Datamart and we would like your help updating the previous 'Datamart query tool preferences' list below. The list was created from suggestions by our Datamart user's when we transitioned from Hyperion to OBIEE.

To be clear, based on the current query tool state, we believe we can continue to use OBIEE for at least a few years. However, we plan to search for a suitable replacement to make sure we are in compliant with our query tool standards. Additional information about this topic will follow in the coming months.

Please review the below list and provide suggested updates. In addition, rate your top six most wanted items in order of priority (1 is the highest, 2 is next, and so on down to 6). Send the final info to 'Datamart.Support at das.oregon.gov' by November 4, 2024.


Datamart query tool preferences:

Category:
Features:

  1.  Works with all web browser applications (Edge, Chrome, Firefox, etc.).
  2.  Ability to query large volumes of data (over 1 million rows of data).
  3.  Ability to query other databases (including individual agency databases).
  4.  Easy to integrate with Microsoft Office Products (Excel, Access, etc.) Importing and exporting.
  5.  Dashboard features, drag and drop filters.
  6.  Conversion capability with old data queries.
  7.  Ability to join internal data sources with Datamart data.
  8.  Undo button.
  9.  Copy query to another file.
  10. Custom programming of fields (formula add).
  11. Easy documentation feature that allows you to describe how query/report was built. Put text anywhere not just on the dashboard.
  12. Ability to interface with applications like ORBITS to bring together many sources of information.
  13. Easily integrate with Acrobat both importing and exporting.
  14. Ability to import or connect to an .rpt or .pdf file.
  15. Being able to create a model that you build once, then open on any other similar file.
Query building:

  1.  Complex formulas in request fields along with in the Results section.
  2.  A way to subtotal pivots.
  3.  Append new data to existing results of a query ('Local Results').
Reporting capability:

  1.  Interactive reports, filters and parameters can easily be changed by the user, not the report creator.
  2.  Scheduler - schedule reports to run certain times of month, year, automatically run report and email reports to customer, web based.
  3.  Robust report format functionality and customization.
  4.  Repository of reports - statewide.
  5.  Forecasting and Modeling features.
  6.  Web data query capability.
  7.  The ability for the report server to produce output based on a URL request in an html viewer.

Other:

  1.  ODBC compliant connectivity
  2.  Long life expectancy of product.
  3.  If desktop based, has the ability to work with 64-bit based system.
  4.  The query tool program is similar to what other states are using.
  5.  Ease of agency technical staff to understand the connectivity.
  6.  Does the query tool company have a user group where users can learn from each other or a user manual/guide that can be readily accessed to troubleshoot items.

Thank you for your time and if you have any questions, please contact Datamart support.
Aaron Wallace
Sr. Datamart Business Analyst

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