calendar filter

[former_member539471]

Hello All,

I want to create a prompt for Calender in Universe designer.I want to just select calendar dates to and from.I do not wan to use any database date column for that....just only calendar.

any ideas on how to get this.

thanks,

Pali

Edited by: pali1010 on Oct 6, 2011 6:14 PM

[Former Member · Accepted solution]

Hi,

If you want to filter data on the calander you need to have time dimension in the database.Without that it is not possible

Thanks

[former_member539471 · Accepted solution]

Thanks,

But I just want a dummy calender date(date prompt ).This is what I did

@Prompt('Enter Calender Date (MM/DD/YYYY):', 'D', '', Multi, free,,,user:0) its not working.....

any inputs?

Thanks a lot

[Former Member · Accepted solution]

Every prompt in the Universe should have a Left Hand Side and a Right Hand side..

Something like this LHS = RHS

What is the other side in your prompt?

[Former Member · Accepted solution]

If you created an object, e.g. \[Prompt_date\], which you want to use in your query filter like:

[some object type date] = [Prompt_date]

you can do that by entering: @Prompt('Enter Calender Date (MM/DD/YYYY):', 'D',, Multi, free) within the select of the object properties.

Note: if you don't want a list of value then you need to get rid of the single quotes in the 3rd parameter.

Regards,

Harry

[MariannevL]

Hi,

Any date type object will automatically trigger the standard calendar prompt.

So if you have two prompts asking for a begin and end date (in date format),

the end user can use the calendar to select a certain date for each of those.

Hope this helps,

Marianne

[Former Member]

[See this blog post about date prompts in BO OLAP universes|http://pabloj.blogspot.com/2011/08/prompts-in-sap-bo-olap-universe-query.html]. Hope this helps.