Dear Experts,
I am currently working on a dashboard design wherein I am faced with the below two concerns.
a) I need to compute the below KPI by using a business content cube as source.
- Days Inventory Outstanding ( for fiscal quarter or fiscal year )= (((BEginning Inventory + Ending inventiry )/2)/(COGS/day))
As this is for financial information: could you please let me know which Business content infocube I could get inventory balance information. As this is a financial report, i would ideally need this from any Financial Business content cube( if any), else could you point me to the right source?
b) I need to generate a report for revenue by region( continent) based on COPA standard cube 0COPA_C03. I notice that i do not have a continent infoobject, is there some way I could source the continent information from COPA cube ?
I cannot modify the standard BI content cube strucuture, hence the difficulty.
Rgards,
Solomon