4. The query the report uses looks something like this:

Alter Stored Procedure spv_Report

(@Fund varchar(100), @AsOfDate datetime)

As

Begin

Create Table #Results

( Reportline varchar(100),

Amount decimal(28,12))

Insert into #Results

Select ReportLine, Sum(Amount)

From FactGL As GL

Join AuxReportLineMatrix ARLM

on GL.AccountKey = ARLM.AccountKey

Where Fund = @FundKey and PostingDate

Group by ReportLine

Insert into #Results

Select ReportLine, Sum(Amount)

From FactCommitment As CMT

Where Fund = @FundKey and PostingDate

Group by ReportLine

Insert into #Results

Select ReportLine, Sum(Amount)

From FactMemo As Mem

Join AuxReportLineMatrix ARLM

on MEM.AccountKey = ARLM.AccountKey

Where Fund = @FundKey and PostingDate

Group by ReportLine

Update #Results set Amount = Amount *.12 From #Results R

Join AuxReportLineMatrixFx ARLM

on R.ReportLine = ARLM.ReportLine

Where ARLM.CurrencyCode = 'disc'

Delete from #Results where Amount = 0

Select * from #Results

End

How do you find out where the Other Assets is comes from in the database tables?

_____________________________________________________________________________________

5. If you found that this query is the only part of the procedure that returns or changes the Other Assets line.

Insert into #Results

Select ReportLine, Sum(Amount)

From FactGL As GL

Join AuxReportLineMatrix ARLM

on GL.AccountKey = ARLM.AccountKey

Where Fund = @FundKey and PostingDate

Group by ReportLine

How do you get more detail on what makes up the query?

_____________________________________________________________________________________

6. If in looking at more detail you find these values, and you suspect that you should eliminate reversals how would you do it?

Report Line

Amount

Reversed

Entry No_

Other Assets

100,000

0

1

Other Assets

-70,000

1

2

Other Assets

70,000

1

3

Other Assets

-70,000

1

4

Insert into #Results

Select ReportLine, Sum(Amount)

From FactGL As GL

Join AuxReportLineMatrix ARLM

on GL.AccountKey = ARLM.AccountKey

Where Fund = @FundKey and PostingDate

Group by ReportLine

____________________________________________________________________________________

7. Software Development Lifecycle:

A. What are the steps of the SDLC?

B. In the scenario we just discussed what phases of the SDLC did you just do?

C. What steps in the SDLC do you need to complete in order to complete this request and explain how you would do it?

D. How would a support role follow all the SDLC steps to change a clients report?

4. The query the report uses looks something like this: Alter Stored Procedure spy Report K@ Fund varchar(100), @AsOfDate datetime) As Begin Create Table #Results Reportline varchar(100). Amount decimal(28.12)) Insert into Results Select ReportLine. Sume Amount) From FactGL As GL Join AuxReportline Matrix ARLM on GL AccountKey = ARLM.AccountKey Where Fund - @FundKey and Posting Date la AsOfDate Group by Report Line Insert into Results Select ReportLine, Sum(Amount) From FactCommitment As CMT Where Fund @FundKey and PostingDate a AsOFDate Group by Report.inc Insert into #Results Select ReportLine, Sum(Amount) From FactMemo As Mem Join Aux Reportline Matrix ARLM on MEM.AccountKey = ARLM.AccountKey Where Fund FundKey and Posting Dates a AsOFDate Group by Report Line Update #Results set Amount = Amount 12 From #Results R Join Aux ReportLine MatrixFx ARLM on R. Report Line EARLM.Report Line Where ARLM.CurrencyCode = 'dise! Delete from #Results where Amount = 0 Select * from #Results End How do you find out where the Other Assets is comes from in the database tables? 5. If you found that this query is the only part of the procedure that returns or changes the Other Assets line. Insert into Results Select ReportLine. Sum(Amount) From FactGLAS GL Join Aux Report Line Matrix ARLM on GL AccountKey = ARLM. Account key Where Fund - FundKey and PostingDate ce AsOfDate Group by ReportLine How do you get more detail on what makes up the query? 6. If in looking at more detail you find these values, and you suspect that you should eliminate reversals how would you do it? Report Line Amount Reversed Entry No Other Assets 100,000 0 Other Assets - 70,0001 Other Assels 70,000 Other Assets-70,000 2 3 4 Insert into Results Select Reportline. Sum Amount) From FactGL As GL Join Aux Report Line Matrix ARLM on GL AccountKey = ARLM.Account key Where Fund - FundKey and Posting Date Ja AsOfDate Group by Report Line 7. Software Development Lifecycle: A. What are the steps of the SDLC? B. In the scenario we just discussed what phases of the SDLC did you just do? C. What steps in the SDLC do you need to complete in order to complete this request and explain how you would do it? D. How would a support role follow all the SDLC steps to change a client's report