Hi All I am Beginner in BI I need your Help in development
Cube; Contain Company, Year, Document number, Amount fiscal year/period as an objects(001.2009) and it contain some years of data like from 2008 to till date.
Requirement: user will enter the fiscal year period value when my out put should be derived from the given fiscal year period value (003.2011). With four Columns
Like: 1. Amount for the given fiscal year /period (003.2011).
2. Amount for previous period (002.2011).
3. Amount for last year same month period (002.2010).
4. . Amount for last year pervious month period (001.2010).