BI Query and the existing data warehouse will remain operational for a period of time after we begin implementing ODS and our reporting tool. We anticipate BI Query will remain until approximately December 2015.
Will the Data Warehouse go away?
The existing data warehouse will continue to be refreshed and operational for a period of time after we begin implementing ODS and our reporting tool. No further changes will be made to it. We anticipate the data warehouse to remain until approximately December 2015.
Can my existing queries and reports be transferred to the new tools?
Unfortunately, no. ODS and our reporting tool have a different structure and naming convention than the existing data warehouse. Therefore, all your existing queries and reports will have to be recreated. The BIC will redo the existing data warehouse admin reports.
How often will the data be refreshed in ODS?
ODS will be refreshed nightly, as is the current data warehouse. If you need 'real time' reports, you must continue to use Appworx to report against Banner.
Will our reporting tool replace Appworx?
Our reporting tool will replace BI Query. AppWorx will continue to be used to report against the Banner tables. 'Real time' reports will need to use AppWorx against the Banner tables.
Will my access change? Will I have less access to data?
With the implementation of the new tools and system, security is being reviewed. As part of this project, we are trying to broaden security so people have more access to data to do their jobs. CORE is a cooperative, open reporting environment and we are striving to meet that goal.