use FI Posting date as a filter value, can I get YTD for current year?

[Former Member]

Dear Expert,

I work on a BI report which calculate the YTD key figure (restricted by 0CYEAR and =< 0CMONTH).

One of the requirement for the report is to allow user to enter a value for a date using FI Posting date (although this is optional).

Without entering the value for FI Posting date, my report works fine.

But once FI Posting date is entered, no data found.

I expect that when the value for the FI Posting date is entered, the YTD value will be calcuated starting from the Jan 1 of that FI Posting year to the FI Posting date entered.

But this seems not happen.

Could you help me to resolve this problem?

If there is a better solution, please let me know.

Very appreciated.

Arthur

[Former Member]

Hi,

The user input will be posting date let say VAR1 type user input. Define a selection using any KF and hide that in report.

Define a another variable(VAR2) of type exit on posting date and populate it in exit.

VAR2 will be 01 jan to VAR1 (the value entered by user) and create RKF with VAR2 and it will take care u r solution.

Thanks,

Debasish

[Former Member]

Hi Arthur,

Are you giving the FI Posting date variable in global filter ?? If so then its quite possible that the combination of restriction's that are in global filter lead's to no result or no output, what i exactly mean to say that for that particular combination there can be no data.

Now if your user wants the FI posting date entery also, Please provide the detail wether you want the effect of this to be shown on whole columns or its effect is for a one or two particular columns in query. If this is about for few column's then you can prompt that variable by creating restricted key figure's and use them in your query columns

If you can please provide the requirement and structure of query then that will be bit helpful to understand the requirement.

Thanks

Dipika

Edited by: Dipika Tyagi on Jun 6, 2008 6:39 AM

Edited by: Dipika Tyagi on Jun 6, 2008 6:40 AM

[Former Member]

Hi Dipika,

Thanks for your reply.

In my report, FI Posting date is a free characteristic, which user can optionally select it and fiter it for a specific FI Posting Date. Do you consider it as a global filter?

my query structure is as below:

rows: profit center, department, manager

columns: YTD for current year, YTD for Previous year, the difference betwwen the two

The requirement is when user enter a FI Posting date, use it to restrict the KF shown above.

For example, if the FI posting date is March 15, 2008, then YTD for current year should be restricted by the period between Jan 1, 2008 and March 15, 2008 and YTD for previous year should be restricted by Jan 1, 2007 and March 15, 2007.

Do you have any idea how to implement this requirement in term of FI Posting date?

Thanks and appreciated.

Arthur