formula varible with replacement path not working

[Former Member]

Hi Guys,

I have two date field in CUBE finish date and Date.

I have created the selction input for date  as interval.  and created two formula variable start date with from value and End date with TO value.

these are working fine. But when I created the formula variable on Finish date with replacement path with single value it is not working

no error.

Please give some idea how it can be resolved.

[gleo_SRAM]

Hi Saini,

If Finish date in your query results area? It iwll have to be in your results area but you can set it to No Display.

Can you give us an idea of what's happening when you say it's not working?

With regards,

Gill

[Former Member]

Hi ALL,

My requirement is  I have a cube having fields   work finish date and date.

I have to create the selection screen input field Start date and End Date.

I did this on Characterstic restriction  on date and made this as interval.

and use From value and To value in creation of two formula variable Start date and End date.

I convert date in KF because I have to calculate the Cumulative work upto start date iand end date.

logic for cumulative:  sum of all work  where finish date is less than equal to start date.

I made formula variable with replacement path on finish date info object but it is not working

only Start date and end date is working. But I need Finish date also working for calculation.

Please guide.

[gleo_SRAM]

Hi Saini,

I understand your requirement.

What is not working on the Formula variable for Finish date?  Do you have Finish Date characteristic in the results rows of your query?

With regards

Gill

[KodandaPani_KV]

Hi saini,

as my understanding you performed the calculation only one start date and end date.

You have finished date as a char in rows level?

if you have convert to char to KF then perform the calculation using replacement path scenario.

Thanks,

Phani.

[yasemin_kilinc]

Hi Saini,

As I understand you are trying to make a report where you have two input variables: Start date and End Date. Acording to these inputs you restrict Date. You want to show in the report the difference between finish date and start date where the difference is greater than 0. You have created a formula variable with replacement path. Please check your definition, do you select the reference characteristic as finish date and in the replacement path tab, replace variable with "infoobject" and replace with "key" is selected. If this is so, then I think you are not adding finish date to your query. Replacement path variables don't work if you don't add the reference characteristic to your query. Add finish date to your query, you will see that it is working.

Hope it helps

Regards

Yasemin...

[Former Member]

Thanks Yasmin,

It is working now after adding it to ROW in the query.   Thanks for the help.

I have a Question:  can we aggregate the calculated key figure by formula.

its is giving me error .

[yasemin_kilinc]

Your welcome Saini. If you want to see the formula as cumulative, then you can check the "cumulative" check box in calculations tab. I have to ask again what exactly you want to do. I think using aggregation will not be a problem, what is the error you are getting?

[KodandaPani_KV]

Hi saini,

But when I created the formula variable on Finish date with replacement path with single value it is not working.

Why your are creating the formula variable?

you can create the char value variable then put char restriction column -> select variable represent - single values -> variable as - optional/mandatory.

if you create the formula variable you can perform the only calculations.

Thanks,

Phani.

[Former Member]

Yes , I need to calculate the some calculation.

like    sum of all work where finish date is less than or equal to start date.

.  Start date and end date are input ready

and finish date is without  input.

Please give some idea.

[yasemin_kilinc]

Hi Saini.

You don't need a formula variable for that.

Make a restriction on finish date. Use less than or equal to the start input variable.

Hope it helps

Regards

Yasemin...

[Former Member]

Hi Yasmin ,

Actually I need to  take the input variable as start date and end date. 

and then  compare with finish date.

Restriction on finish date will not work.

[yasemin_kilinc]

Hi Saini,

Will you please explain your exact requirement?

[former_member182343]

Hi  Saini,

If I am not wrong , you need to take Start date and End Date which are coming as variable input into calculations(need to compare with Finish date).

Here to get you can capture dates(Start date and End Date) which are passing as input parameters, into another variable of Type Formulae with Processing type Replacement path .

To test scenario Goto RSRT and select type List - then check Key Figure definition then you will come to know the variation,

Best Wishes, Vijay

.

[gleo_SRAM]

Hi Vijay,

Saini has those working - the issue is with the "Finish Date" Formula Variable which is not working.

From the explanation - Start & End date are based on the characteristic DATE and the characteristic FINISH DATE is where the issue is.

With regards

Gill

[Former Member]

Hi Gill,

Actually there are two info objects DATE & Finish Date

Start date and End date formula variable with replacement path is based on DATE info object only. (DATE restricted characteristic based on DATE as INPUT ON Screen )

Finish date variable with replacement path is based on the Finish date info object.

[gleo_SRAM]

Hi Saini

Are you able to tell us what is wrong with the Finish Date formula variable. It will help to resolve the issue if you can add a screen shot of what's wrong.

Regards

Gill