Skip to Content
0
Former Member
Dec 12, 2011 at 09:42 AM

BW content cube for inventory

54 Views

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