Added read_ssrs function to support user’s R pipeline retrieving data from SSRS reports.
Added new datasets for various service lines.
Minor bug fixes in SQL joins when there are duplicate columns from both sides.
phrdwRdata 1.0.0
Integrated olapR.
Removed deprecated packages like RODBCext.
Rebuilt handling SQL and MDX queries to supercede legacy functions.
Instead of one (or two) scripts per datamart, and one function per dataset, query information is tabulated and parsed by a single function (one each for RDB and OLAP).
This makes the control of information much easier to manage. and can be leveraged for helpful error messages.
Improved call time for SQL calls with dbplyr and optimization.