If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Inventory report - Cumulative balance

Started by cognos05, 10 Aug 2021 03:46:30 PM

Previous topic - Next topic

cognos05

Hi ,
We have a fact table which has inventory movements data in fact and surrounded by dimension like product customer etc..

Not sure if we need to join time dimension which is at day level to the fact table because we would like to see the inventory at the end of specific period which should do a cummulative total  from the inception .

Example the inventory for July 2020 should take care of all the movements from inception July 2015 till july 2020.

Any suggestions or existing post that discuss about this use case for inventory reporting in cognos data modules .

Thanks