Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Fixed Asset - Asset Depreciation real time

Accepted answer
31
Views
2
Comments
Pooja_123
Pooja_123 Rank 4 - Community Specialist
in Oracle Transactional Business Intelligence

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

Best Answer

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    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!

Answers