United States Department of Veterans Affairs
United States Department of Veterans Affairs

VA Northwest Health Network

VISN 20 Data Warehouse OLAP CUBE MetaData

Introduction
Manuals
Cube Definitions
Current Cube Status

Data Warehouse Navigation
Overview and History
MetaData
ER Diagrams
Research Requirements
Home

 

Introduction
Online Analytical Processing (OLAP) is defined by the * ProClarityPDF Document Getting Started Guide as; "... a way of analyzing data by interacting directly with data rather than by reviewing static paper reports." The manual goes on to say; "OLAP technology arranges raw data so that someone working at a computer can view the data in graphic formats that reflect a wide variety of relationships among the data. OLAP makes multidimensional analysis possible."

Access to the multidimensional cubes provided by the VISN20 Data Management Data Warehouse can be established by contacting Steve Schreiner at (541) 830-7405.

Manuals
PDF Document "Getting Started Guide" (PDF files must be viewed using Adobe Acrobat Reader)

Get Acrobat Reader

Definition Pages
Diabetes Cube Definition Pages
MS Word Document VISN Diabetes Results Cube Manual
MS Word Document VISN Diabetes VISN Cohort Cube

Encounters
MS Word Document VISN20 Encounters Cube Definition Page

Fee Basis
MS Word Document Fee Basis Cube Definition Page
MS Word Document Inpatient Fee Basis

Hepatitis C Cube
MS Word Document Hepatitis C Definition Page

Hypertension Cube
MS Word Document Hypertension Cube Manual

Ischemic Heart Disease
MS Word Document IHD Cube Manual

Non Vested Patients
MS Word Document Non Vested Category "A" Patients
MS Word Document Non Vested Category "C" Patients

Pharmacy
MS Word Document Narcotic Medication
MS Word Document Unit Dose
MS Word Document VISN20 Prescription Cube Definition Page

Prosthetics
MS Word Document Prosthetics New Devices

* Links will take you outside of the Department of Veterans Affairs Website. VA does not endorse and is not responsible for the content of the linked websites. The link will open in a new window.