Please find below the modelling requirement.
Geography dimension will include Region Type, Region, Country with country having a valid year to and from in a Region.
The transaction data is at country level in Infocube.
Country India (IN) can belong to several Region Types with a a validity period . The relationship is one to Many. This information is stored in a DSO currently.
Data in DSO is like Country (IN) belong to REGION TYPE (XYZ) with REGION (123) during 1999 to 2007 and then
IN is moved to REGION (456) within the same REGION TYPE (XYZ) from 2008 to 9999.
Infoset was used to join Infocube data and DSO data to use several Region types depending on the user choice.
But, the issue is , data for year 2008 for country IN is coming both in REGION 123 and 456, although it should be only in Region 456. The join to Year from infocube to DSO is not not working as the Year in DSO is a valid from year and valid to year
Is there a way to model this in BW?
Our source is Oracle, BW 7.1.
Thanks and Regards,
Edited by: Srinivas on May 16, 2011 6:32 PM
Edited by: Srinivas on May 16, 2011 6:33 PM