Skip to Content
0
Apr 04, 2014 at 06:40 PM

how to determine 0calday from 0fiscper field ?

90 Views

we have a requirement where the user will enter the calmonth variable in the user input, and need to get the amount for top 20 customer's on sales, in the report. The problem is we dont have calmonth in the infocube. we have only 0fiscper and 0fiscalyear , and -0calday.

0calday is mapped to the transaction date. No calmonth in the infocube and we cannot add it now. its too late.

The columns we need in the report are ( orange color are column names)


customer YTD DEC 2012 ( sales amount) ....for top 20 customers. like


customer 1 99999 900

customer 2 55555 200


...................................

......

customer 20 11111 234

sample data is as follows: ...what I want is user will input 0calmonth and 0fiscalyear. and I need to display the data for that month . Please advise how to achieve it. YTD - is 1st of jan of the current year till today's date right ? Irrespective of the user entry variable. Is that right ?

Attachments

Capture2.png (45.2 kB)