Variable (query between two dates)

[erdem_sephanelioglu]

Hello everybody,

I am having two date info object

Startdate

Enddate

Based on a key date(user entry) on the opening screen the query will show the lines with the conditions as below

key date >= startdate

key date <= enddate

I wonder how i could achieve this on the front end

Thanks a lot

Eddy

[erdem_sephanelioglu]

Hello everybody,

replacement path works well but the KPI (Count) is not visible in the last column instead key date.

I would kindly appreciate it if any have an idea on that?

I see the description of Key Figure but not itself.

Regards

Eddy

[erdem_sephanelioglu]

Any idea?

[anshu_lilhori]

can you share the definition of count kf.formula ?

Regards,

AL

[erdem_sephanelioglu]

Ok. The problem was the structure 1. The Count formula Variable.

If i remove it from the view no bug.

But Can not i use a second structure ?

[konkasreenivasulu]

Hi Eddy,

First create input variable based on SPECIFIC DATE FIELD ( Eg : 0calmonth , 0fiscper  etc )  and name it as KEY DATE

NEXT

Right click on SPECIFIC DATE FIELD and choose restrict  and choose value ranges

and choose keyfield based on greater than option in value ranges

You can create another variable as same .

Regards,

Sreeni

[erdem_sephanelioglu]

It is allright.

How would i see the key date in the output, the data I input on variable

Thanks

Eddy

[anshu_lilhori]

Eddy if you had gone through the blog which i mentioned in my first reply then you would have got answers to all the queries.

Please check it once.Everything is mentioned in it step by step with the screenshot.

For your reference

Hope this helps.

Regards,

AL

[erdem_sephanelioglu]

Hi Anshu,

Thank you very much for your input. I actually tried it shortly however i get an error which is.

Systemerror in Programm CL_RSR_RRI2_LRECH and Form CHECK_CNTBIT_POSSIBLE_PARENT_01

[cornelia_lezoch]

Hi Eddy,

I am not sure about this error message, never had this one.

But Why should varibale 2 be a formula variable?

As I said above, I think you will Need char variables for start date and end date, so vraiable2 also Needs to be char variable type replacement path, replacement by variable1.

both variables then Need to be used in filter with <= and >=.

regards

Cornelia

[anshu_lilhori]

For displaying the date entered in input screen as output,you need to follow the step 3.

You are supposed to create a formula variable in columns panel.

Try the steps.If you get any error or issue,please share with us.

Regards,

AL

[erdem_sephanelioglu]

I followed the referred document step three. When I test I recieve the following error

CL_RSR_RRI2_LRECH and Form CHECK_CNTBIT_POSSIBLE_PARENT_01 when I test the query.

Design of the query is

Rows

   Structure 1

             Count

   SD Document
   Item

   Created Date

   Delivery Date

Columns

    Structure 2

         Key Date(variable)

[erdem_sephanelioglu]

Hello everybody,

My variable design is as below but i am receiving the following error if i want to check the query:

Systemerror in Programm CL_RSR_RRI2_LRECH and Form CHECK_CNTBIT_POSSIBLE_PARENT_01

Startdate - Object1

Enddate - Object2

Variable 1- Object 1 (Restriction Area)

-Characteristic Value

-Manuel Entry

-Single Value

-Input Ready

Variable 2 - Objekt 2(Based on Replacement Path) (Columns - Structure)

-Formula

-Replacement Path

-Single value

-Optional

Thanks in advance.

Eddy.

[Former Member]

Hello Eddy,

Variable 2 should also be in Restriction Area and it should be of type characteristic value.

BR

Ondrej

[cornelia_lezoch]

Hi Eddy,

I don´t see what the problem is.

You do exactly what you say in your question.

You create a variable for key date defined on infoobject 0date .

Then you set the filter

for startdate and end date as you say above.

regards

Cornelia

[erdem_sephanelioglu]

Hi Cornela,

Problem is actually hat I am not permitted to use same variable for two time characteristics, at this case Startdate and enddate.

Regards

eddy

[Former Member]

Hello Eddy,

You can create another date variable and fill it via replacement-path from first one.

Then you have two variables with same date to restrict two different characteristics.

BR

Ondrej

[cornelia_lezoch]

Hi Eddy,

usually it work even though the system give an error message.

But if the error message disturbs you - just create the replacement path variable, replace by first variable, use each one for just one of your data chars.

regards

Cornelia

[anshu_lilhori]

I remember doing the same thing long time back and covered it in one of my blog as well.

Please search with the term status of tickets based on their dates.

Might be useful and helpful in your scenario as well.

Regards,

AL