1 / 6

Data Warehouse User Group September 23, 2010

Data Warehouse User Group September 23, 2010. Upcoming Changes to Cubes Future Cubes. Changes to Existing cubes. Utilization Addition of “PSA Dept” dimension

adina
Download Presentation

Data Warehouse User Group September 23, 2010

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Warehouse User GroupSeptember 23, 2010 • Upcoming Changes to Cubes • Future Cubes

  2. Changes to Existing cubes • Utilization • Addition of “PSA Dept” dimension • Listings for PSA Dept can currently be found under the “Div/PSA Dept/Campus Div/Cost Center” dimension, where it’s the level below Division. • New Dashboard reports created by medical group require PSA Dept to be a top level dimension. • Because it will be added below the existing dimension folders, the new addition should *NOT* create any problems for existing reports.

  3. Changes to Existing cubes • Lipay_Reject • Addition of “Rej1 ETM Task Name” dimension • Groups the denials into those that require follow-up and those that don’t. • Because it will be added below the existing dimension folders, the new addition should *NOT* create any problems for existing reports.

  4. Future Cubes • Charge Lag cube based on Transactions • Current Invoice_Lag cube calculates charge entry lag at the Invoice level and not for each Charge Line separately • Current methodology uses the 1st DOS entered on the first charge line of that Invoice – this works fine most of the time, but can be misleading when multiple Dates of Service are entered on one invoice, as the first DOS is typically the oldest • New cube attempts to replicate MGBS’ algorithm • Like MGBS’ reports, new cube will offer multiple and better ways to calculate “lag” • Receipt Lag: days between DOS and date of Receipt by billing agent (MGBS, PerSe) • Entry Lag: days between Receipt date and date batch was entered into TES • TES Lag: days suspended in TES before extracting to IDX; the difference between the TES entry date and the Invoice Creation date in IDX • Only IDX records are included in the cube, as most of the dates are not available from SMS

  5. Future Cubes • Charges “stuck” in TES at Month End • Snapshot of unique charges in “Edit” status at month end • Charge lines are subject to multiple edits, but only Unique Charges will be captured in the cube – i.e. Edits will not be a dimension • Purpose of the cube is to allow us to view Trends • Similar to AR Trends in that we’re attempting to show a Snapshot of TES Edits in time; i.e. on the last day of the month • Also similar to AR Trends cube in that the source table used to create it is of limited value as a stand-alone table • *NOTE* a general cleanup of TES was done in early August after it was confirmed that many edits had not been captured. • As a result, TES Edits were rebuilt from scratch beginning with all edit records which existed in the system on 7/1/2009. Every nightly incremental since then has been rerun.

  6. Upcoming Cognos Training • Next Cognos Training scheduled for October 21st and 22nd (Thursday and Friday). • Sign up deadline is October 14 • Schedule for CY 2011 is not yet finalized • Latest Training Schedule can always be accessed by clicking on the “training and class information” link from the main data warehouse page, or by going to https://www.intranet.medschool.ucsf.edu/medgroup/private/dwh/training.aspx

More Related