cancel
Showing results for 
Search instead for 
Did you mean: 

Create a new Relative Selects for Dates

omkar_uthale2
Participant
0 Kudos

Hello,

I have a particular requirement where I have to develop various reports out of Opportunity Header Data source. Here we have a specific requirement on Selection screen where data need to be fetched on Start Date using Relative selects of 10 days, 21 days and few such custom relative selects.

At present, these values are not available by default.

I want to know if we can create relative selects in C4C.

Regards,

Omkar Uthale

Accepted Solutions (0)

Answers (2)

Answers (2)

omkar_uthale2
Participant
0 Kudos

Hello,

I found a way around to do my requirement by creating new calculated key figures.

As for it goes in creation of new relative selects, there is an option to do that. But due to lack of documentation around that area, I have not opted to go with it.

It is present under Business Analytics->Data Sources->Relative Selections.

Regards,

Omkar Uthale

Former Member
0 Kudos

Hi

you can do it when creating report with view - in wizard for that you should choose Start Date as charasteristic, and on next step "Characteristic Properties" choose this characteristic as a "Fixed Value Selection", and set relative select on it with button "Set Fixed Value Selections". Like below

but you might not find here all interested values.

Please also go through this:

omkar_uthale2
Participant
0 Kudos

Hello Radek,

Thanks for quick reply.

I have done all of the above steps to enable relative select for Start Date. But my problem is that in those relative selects, I don't find values like Last 10 days or Next 10 days etc. There are few standard defined values like Last 7 days, 14 days, 1 week etc. but these custom selects are not available.

Can we create such custom relative selects in C4C and use it in our report?

Regards,

Omkar Uthale

Former Member
0 Kudos

Please read link I provided - I guess you will need to raise incident in C4C.

BR
Radek