regarding ; Bex Development

[Former Member]

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

[former_member211907 · Accepted solution]

sreekanth-

When you open your query, go to the Columns

Create a selection. Give it the 0FISCPER time characteristic and the key figure (0AMOUNT or equivalent) that you want to report on. Restrict 0FISCPER with a variable for a single fiscal period.

Save the selection

1- Then copy the selection, and paste.

2- Change the new selection and right click on the variable for 0FISCPER, and choose "Set offset for variable". Offset it by -1 for the previous period.

Repeat steps 1 & 2 to offset by -12 periods for prior year, and -13 periods for prior year prior period.

do NOT forget to add a restriction for the appropriate Fiscal calendar type (We use K4 here, your use may differ) in your query, or you will have problems.

Offset is a nice feature. Play with it a bit.

[Former Member · Accepted solution]

Hi,

Thanks for your quick reply,

Actually when the user gives as I said earlier that it will be like 002.2009 with which the data selected from the data base will be for that month only

i think i need to create a exit in cmod, but i am not sure, if you have any other idea or the same is true please through some knowledge on the same with the idea of testing the same. I mean debug.

FI i have good skill in ABAP

[Former Member · Accepted solution]

Hi,

You are right in a way that this requirement can be fulfilled by writing CMOD code also. But I would say the option suggested by Charlie is simply and easy to do, you don't need to write any CMOD code.

If you are planning to do so, then based on the user input in I_STEP = 2 you can read the varable value i.e. User input period and based on it either you can create each variable for different range or again you can create single variable and use offset.

In the CMOD code you can populate e_t_data table with required value.

Regards,

Durgesh.