Can we create Inventory transaction costs report?

sred

Can we create Inventory transaction costs report using two subject areas Inventory Transactions real time & Costing standard cost time?

Item Name Transaction Date Inventory Organization Name Transaction Action Description Item Description Transaction Source Reference Transaction Quantity Transaction Type Created By Transaction Reference ; I need here active standard cost of an item too.

Thanks,

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24140/can-we-create-inventory-transaction-costs-report

Please check if below helps:

How to join Cost Accounting Real Time and Inventory Transactions Real Time in OTBI reporting? — Cloud Customer Connect

Check below MOS for more details on cross SA reports:

Fusion Applications OTBI: Guidelines for creating cross subject area analyses in Oracle Transactional BI (Doc ID 1567672.1)

Thanks.

RichardChan

I don't know about those specific Subject areas however the general rule of cross subject area queries is to include a common dimension element to effectively do the join

sred

Thank you Mandeep; It looks I dont have access to open it.

How to join Cost Accounting Real Time and Inventory Transactions Real Time in OTBI reporting? — Cloud Customer Connect

sred

Thank you Richard, here I am confused with what exactly dimension element?

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/comment/62130#Comment_62130

Hi,

You can check about the dimension elements from MOS note which I mentioned in my post. For other one customer connect, create an account on customer connect and provide CSI of your customer and you should be able to access.

Thanks.

Bhaskar Konar

Hi @User_X33RN,

Please find below the Best practices that need to be considered while developing a report using more than one subject areas.

• You should have common dimension in the subject areas used in the report.
• Add at least one Measure/Fact/Metric from each subject area on the report.
• Click on the Advance tab of the Analysis report --> Scroll down till you see Advance SQL clause --> Check the Dimensionality check box --> click on Apply SQL button.
• Go to the Results tab and test the results.
  

Additional things that need to be considered:

• You also need to consider the lowest grain at which the Subject Areas built.
• More them one subject area reports are complex reports, apply proper filters on the report.
  
• How to debug the issue:
  • create a simple report with one subject area, remember to add as many dimension columns from first SA and add at least one measure. Apply filters.
  • Add second subject area add required dimension columns and don't forget to add measure.
    (These Guidelines Apply to current FA/OTBI Custom Analysis requirements.)

Please follow cross subject area guidelines as documented in : Creating and Administering Analytics and Reports > How Data Is Structured for Analytics

How Data Is Structured for Analytics

Hope this help.

Cheers,