[Datamart-News] OSFA (Derivable query)

Datamart Support datamart.support at state.or.us
Tue May 1 07:41:50 PDT 2012


If you were unable to join me at the OSFA conference this year and view
the 'Derivable query' presentation, you are still in luck. We have
provided you an opportunity to download the 'Derivable Query Conversion
Notes', in pdf form, from our website. Derivable queries are a topic
discussed in the new intermediate Datamart training and a brief
introduction to this query building method was presented at OSFA this
year.

 

http://egov.oregon.gov/DAS/SCD/SARS/datamart.shtml#Datamart_Training

 

This pdf was a handout during the OSFA training. It describes how to
alter a current standard built query and turn it into a derived query.
The instructions allow a user to keep their original pivots, tables,
reports, and charts intact, while updating a query to run as a derived
query.

 

If you have any questions, please email the Datamart team at
Datamart.Support at state.or.us.

 

Thanks,

Aaron Wallace

Sr. Datamart Business Analyst

Department of Administrative Services

Data Classification: Level 1 - Published

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://omls.oregon.gov/pipermail/datamart-news/attachments/20120501/6db66165/attachment.html>


More information about the Datamart-News mailing list