1. 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 <= @AsOFDate

Group by ReportLine

Insert into #Results

Select ReportLine, Sum(Amount)

From FactCommitment As CMT

Where Fund = @FundKey and PostingDate <= @AsOFDate

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 <= @AsOFDate

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?