Fixed Asset - Asset Depreciation real time

Question

Hi Team,

I am unable to see the data when joining the two SA. Fixed asset- asset depreciation real time and asset transaction real time.

I just simply need to pull the YTD Depreciation column in the report. Kindly suggest

Nathan CCC · Accepted Answer

Hi Pooja,

As a general rule of thumb you need a measure column (yellow ruler icon) from a fact in each subject area along with a dimension attribute column (blue icon) that is common which both facts join to at the same level. To work out if you have selected the correct presentation columns cut paste your logical sql from the advanced tab to page /analytics/saw.dll?IssueRawSQL then View Log to understand how the metadata repository database has generated the physical sql until you get a query that joins the way you expect it to. Good luck!