Financial Data Financial Data Warehouse Warehouse Some day, on - - PDF document

▶
financial data financial data warehouse warehouse
SMART_READER_LITE
LIVE PREVIEW

Financial Data Financial Data Warehouse Warehouse Some day, on - - PDF document

Nov 17, 2023 131 likes •252 views

3/17/2016 Financial Data Financial Data Warehouse Warehouse Some day, on the corporate balance sheet, there will be an entry which reads "Information"; for in most cases, the information is more valuable than the hardware

slide-1
SLIDE 1

3/17/2016 1

“Some day, on the corporate balance sheet, there will be an entry which reads "Information"; for in most cases, the information is more valuable than the hardware which processes it.”

  • Grace Murray Hopper

Financial Data Warehouse Financial Data Warehouse

Updated 7-2015 Updated 7-2015

Log in to BusinessObjects Log in to BusinessObjects

  • Lect

Lecture & ure & Lab Lab

–Da Data ta Wa Warehou rehouse Ba e Backgrou ckground & nd & Overview Overview –Quer Query Tool y Tool –Terms and Def Terms and Definitions nitions –Fina Financia ncial Da l Data ta Overview Overview –Using Corp Using Corpora

  • rate

e Docu Documents ments –Building a Building a Query and Report in Business Objects Query and Report in Business Objects –work throu work through ex h exercises in ercises in the la the lab

Training Schedule Training Schedule

slide-2
SLIDE 2

3/17/2016 2

What is it? What is it?

  • Central

Central warehouse for fina warehouse for financial, person ial, personnel, l, etc etc.

  • Un

Unlim limited report ited report buildin building g capabilities pabilities

Background Background

  • Data

Data is is organized for

  • rganized for ad-hoc,

ad-hoc, reporting access not reporting access not transac transaction proc ion processing essing

  • Snapshots

Snapshots at variou at various s points points in time in time

  • Easy

Easy ac access with qu ss with query ery tools tools

  • Retention of

tention of ad additional historic tional historical al data ta

–Accounting Activity Accounting Activity from

  • m 1/2000 onward

1/2000 onward –Balances f Balances from 6/30/1998

  • m 6/30/1998 onward
  • nward

Data Warehouse Overview Data Warehouse Overview

ACCOUNT BALANCES ACCOUNT BALANCES FACTS FACTS DEPPS DEPPS Endowment Endowment BPS (PBL data) BPS (PBL data) PAPR, SCBAIMS PAPR, SCBAIMS P-Card/CTA P-Card/CTA WSU ORG WSU ORG END USER (YOU) END USER (YOU)

FINANCIAL DATA WAREHOUSE FINANCIAL DATA WAREHOUSE

Flow of Data Flow of Data

slide-3
SLIDE 3

3/17/2016 3

  • FACTS - Financial Accounting System
  • Complete Account Information
  • Codes, picklists, descriptions, etc.
  • BALANCES System
  • Accounting Transaction Detail
  • WSUORG
  • Endowment System
  • BPS - PBL - Permanent Budget Level data

Sources of Financial Data Sources of Financial Data

  • DEPPS - Personnel & Employee System
  • Employee
  • Position
  • Appointment
  • Funding

Sources of Employment Data Sources of Employment Data

  • PAPR - Purchasing, Accounts Payable, Receiving System
  • Vendor Information
  • Purchase Order Line Item Detail
  • Cost Distribution
  • SCBAIMS
  • Service Center Billing
  • Requisitions
  • Purchasing Card/CTA Card
  • Purchase Description
  • Cost Distribution

Sources of Purchasing Data Sources of Purchasing Data

slide-4
SLIDE 4

3/17/2016 4

  • Bu

BusinessObjec sinessObjects ts

–Comp Complete q lete query ery and rep d reporting tool rting tool

  • InfoBurst (Iburst)

InfoBurst (Iburst)

–Schedu Scheduler fo ler for r pre- e-defined rep defined reports rts –May May only

  • nly be used

be used with Business Objects with Business Objects

– https://iburst.wsu.e https://iburst.wsu.edu/Inf u/InfoBurst/lo rst/logo gon2 n2.asp .aspx?Re Retu turnUr Url=%2 %2fInfoBurst%2 st%2fDefau ault.aspx .aspx

  • InfoView

InfoView

–Use Use for for ma mana naging docu ging documents on ments on rep repository sitory –Use for Use for scheduling (apart scheduling (apart from from iBurst) iBurst)

– https://busine https://businessobje ssobjects.wsu ts.wsu.edu/InfoV du/InfoVie iewApp/logon. wApp/logon.jsp jsp

Query Tool Options Query Tool Options

  • Universe

Universe

–a collection of a collection of information (e.g. information (e.g. a warehouse); A a warehouse); A sema semantic la ntic layer between you yer between you a and the da d the data taba base se tha that adds dds desc scriptiv ptive in information ation, se security ty an and e enab able les “smar s “smart” ” que querie ies. s.

  • Cl

Clas ass

–a set of related objects. a set of related objects. Cl Classes can asses can have have sub-classes to sub-classes to fu further rther gro group o

  • bjects to

jects togeth gether.

  • er. (

(ico con is a n is a fo folder) lder)

Terms and Definitions Terms and Definitions

  • Object

ject -

  • a dat

data it item em or

  • r form

formula ula

  • dimension - a data object (icon is a blue cube)
  • measure - an object that is numeric and can be used in a

calculation or is the result of a calculation (icon is a yellow battleship/histogram)

  • detail - a qualification of another object, provides more

detail on another object (icon is a green diamond)

  • Pre-defined Condition - a special kind of object that helps

to limit or filter the amount of data returned (icon is a yellow funnel)

Terms and Definitions Terms and Definitions

slide-5
SLIDE 5

3/17/2016 5

  • Do

Document ment

–a Busin a BusinessOb ssObjects ts file ile th that at ac acts ts as a c as a contain ainer f for repor ports s (.rep (.rep extension) extension) –Ca Can either n either be hou be housed on the BO rep ed on the BO repository or on sitory or on you your ha hard drive. rd drive.

  • Bu

BusinessObjec sinessObjects ts doc documents are ments are composed of mposed of 3 3 items: items:

–Da Data ta Provider

  • vider - the q

he query tha ery that retrieves retrieves da data ta fo for r rep reports. rts. –Data Data - the he raw raw data that wa data that was returned from the s returned from the data data pr prov

  • vid

ider (d (datab atabase ase) an and d displaye splayed on

  • n th

the r repor port –Rep Report rt - the he fo forma rmatted tted resu results o lts of the q the query ery

Terms and Definitions Terms and Definitions

  • Ac

Accountability in tability in creating eating reports reports

  • Validate

Validate data in data in AIS – AIS – BALANCES, HEPPS, ALANCES, HEPPS, DEPPS etc. DEPPS etc.

Data Verification/Accuracy Data Verification/Accuracy

  • Safeguard ID

Safeguard ID an and d password password

  • Safeguard

Safeguard dat data an and d dist distribut ribution

  • n of
  • f report

reports

Data Security/Privacy Data Security/Privacy

slide-6
SLIDE 6

3/17/2016 6

  • Save *.rep

ve *.rep file on file on loc local or sh l or shared drive. ared drive.

–Be su sure to check check the bo e box “ x “Save fo ve for All All User Users” s”

  • Upload

Upload doc document to repository ment to repository

–Using InfoView Using InfoView –Using Deski Using Deski

  • Share d

Share docs cs wi with others th others

–Send to Users (puts Send to Users (puts in in repository repository inbox) inbox) –Send to Email (lea Send to Email (leaves an email trail) ves an email trail) –Save in public Save in public fold folders (requires ers (requires setup) setup) –Save on a shared file Save on a shared file drive. drive.

Managing Documents Managing Documents

  • Advan

Advantages ages of storin

  • f storing

g doc documents s in in th the e repository repository

–Safe and easily retrieved Safe and easily retrieved if if your your compute mputer crash ashes –Repository can Repository can be be passed on passed on to successors to successors in a position in a position

Repository storage Repository storage Corporate Documents Corporate Documents

  • To

To begin begin – start rt t the program e program, open

  • pen view t

view toolbars t

  • olbars to

selec select toolbars in toolbars in heading.

  • heading. Selec

Select all all bu but t “L “Large arge Bu Butto ttons” then d ns” then drag ag aro around nd to to arrang arrange. e.

slide-7
SLIDE 7

3/17/2016 7 Import Corporate Documents Import Corporate Documents

Go to File, Import From Repository, select “Categories” radio button then open “Corporate Categories” folder , “Financial” and then select the “budget statement.rep” and import.

Enter criteria and hit OK

Run Corporate Documents Run Corporate Documents

hit refresh icon Balance Snapshot Date – can be last night or last month end The message will appear on accounts that do not have revenue detail to report – just hit OK.

Run Corporate Documents Run Corporate Documents

slide-8
SLIDE 8

3/17/2016 8

Begin Building Your Own Report

1 2

Select from Available Universes

3 a b c d e f i h g j k

Query Panel Display Query Panel Display

slide-9
SLIDE 9

3/17/2016 9 Query Panel Query Panel

Top corner of Query Panel select all three boxes in the upper left corner. If you hover these will be “Show/Hide All Classes”, “Show/Hide Help on selected items”, “Wrap result objects.”

Building Your Own Report Building Your Own Report

  • Selec

Select resu result objec lt objects s - these are what c hese are what colu lumns of mns of data will be data will be retu returned rned from the database and from the database and display displayed d in in y your report ur report.

  • Bu

Build ild conditions nditions - these hese pu put limitations t limitations on the

  • n the

number of records that number of records that are returned from the are returned from the dat database. base.

–Use p Use pre-defined or e-defined or you your own

  • wn conditions a

conditions as mu much a ch as possible. possible. –If you don’t specify otherwis If you don’t specify otherwise, e, you will get ALL records. you will get ALL records. –Be careful Be careful when combining when combining da data from ta from multiple multiple classes classes

Building Your Own Report Building Your Own Report

slide-10
SLIDE 10

3/17/2016 10

  • A brief

A brief walk- walk- through hrough of each

  • f each class

class of dat

  • f data (folder)

(folder) in Bu in BusinessObjec sinessObjects ts

  • Descri

scribe e each ch cl class

  • High

Highligh light key key objec

  • bjects an

s and d pre- pre-defin defined c d condition itions (filters) (filters)

  • Things to

Things to watc watch for h for in eac in each class ass

Financial Data Overview Financial Data Overview

  • Set

Set as Master as Master creates a eates a master/detail master/detail report report

  • Can also

n also add breaks, totals, add breaks, totals, sorts, sorts, etc etc.

  • Ho

How to w to “S “Slic lice e and and Dic Dice” the ” the data ta

Formatting the Report Formatting the Report

Slice and Dice Panel

a. Show/hide the Available Variables box b. Apply breaks, filters, sorts, rankings and calculations c. Report Variables d. View all variables, dimensions only, measures only, or all variables by data provider. e. Show masters in master/detail reports f. Show the variables in the active table, chart or crosstab g. Show the name and type (table, chart or crosstab) of each block

slide-11
SLIDE 11

3/17/2016 11

  • If using more

If using more than one than one “snapshot” c “snapshot” class, ass, be be sure sure to to specify the specify the snapshot g snapshot gene neration on E ration on EVERY class ass

  • Use

Use A Acco ccount Sna Snapsho shot a and Acco ccount Ba Balance nce Sna Snapsho shot most of the most of the time. time.

  • Only

ly use Ac use Accoun untin ting Ac Activity tivity wh when en detail detail is n is needed or eeded or wh when en date date ran range is n e is not c t compatible atible with with sn snapsh apshot

  • t

dates dates.

  • ON

ONLY use Supporting use Supporting Data Data when when a list of a list of codes des is is required. required.

Tips and Techniques Tips and Techniques

  • Build

Build the the query to get query to get the data the data you want first, you want first, then then format the report. format the report.

  • Start with a small set of data,

Start with a small set of data, then then add add to it. to it.

  • Look
  • ok at

at eac each objec

  • bject to make sure

to make sure you have put you have put appropri riate co cond nditions o ns on e each ch cl class ss used.

  • Conditions are what limit the amount of data returned; use

them as much as possible.

  • Notic

tice the UPPE the UPPER R CASE SE obje

  • bjects;

s; they are they are the unique the unique identifiers for identifiers for eac each class. ass.

  • Watc

tch out

  • ut for duplic

for duplicate rows ate rows aggregat aggregation ion in in BusinessOb BusinessObjects. ects.

Tips and Techniques Tips and Techniques Save for all users

slide-12
SLIDE 12

3/17/2016 12

Contact IT to request an InfoBurst account. Log in to InfoBurst at https://iburst.wsu.edu

InfoBurst Access InfoBurst Access InfoBurst User profile set-up InfoBurst User profile set-up

  • WSU Data Warehouse web page:

http://infotech.wsu.edu/datawarehouse/

  • Financial Data Warehouse listproc

financial_dw@listproc.wsu.edu

How to learn more How to learn more