Can we create Inventory transaction costs report?

Question

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,

Bhaskar Konar · Answer

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,

MandeepGupta · Answer

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.

sred · Answer

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