Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

To get Current,Last, Next months data for Efashion report

To Create a report with the user input prompt on Year and Month:

If user select year as 2005 and month as 2 (Feb), revenue should be displayed for previous Month (Jan) and next month (March) of selected year.

Sample output should looks as below.

Year : 2005

State

Prev Month - Jan

Current Month - Feb

Next Month - Mar

AAA

$100

$100

$600

BBB

$200

$400

$200

CCC

$300

$300

$300

I have created dimensions in universe premonth=(@Select(Time period\Month) -1) & Nextmonth=@Select(Time period\Month) +1) & taken 3 dataproviders from efashion universe .these are not working for year ends

Tags:
Former Member
Former Member replied

Hi

solution found, taken 3 data providers & added below filters for 2 &3 data providers

DP2

------

@Select(Time period\Year)=iif(@Prompt('Enter Month','N','Time period\Month',,)=12,@Prompt('Enter Year','A','Time period\Year',,)+1,@Prompt('Enter Year','A','Time period\Year',,))

@Select(Time period\Month)=iif(@Prompt('Enter Month','N','Time period\Month',,)=12,1,@Prompt('Enter Month','N','Time period\Month',,)+1)

DP3

-----

@Select(Time period\Year)=iif(@Prompt('Enter Month','N','Time period\Month',,)=1,@Prompt('Enter Year','A','Time period\Year',,)-1,@Prompt('Enter Year','A','Time period\Year',,))

@Select(Time period\Month)=iif(@Prompt('Enter Month','N','Time period\Month',,)=1,12,@Prompt('Enter Month','N','Time period\Month',,)-1)

Thanks

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question