Skip to Content
0
Former Member
Aug 26, 2011 at 02:15 PM

regarding ; Bex Development

17 Views

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).

Advance Thanks