BookmarkSubscribeRSS Feed
Calcite | Level 5

I want to have a from date and to date prompt for my report using olap cube as data source. When I try to create the date filter prompt, it dose not give me an option to create an individual date value prompt , i.e. let the user select a date from the calendar. Instead, it show a list of value base on the time dimension and the user need to select the dates from the long list. For example, if I want to see data from 11-15-2010 to 12-15-2010, I need to select all those dates from the list box.

Is there a way to use just two date prompts for a cube report? I noticed that this kind of prompt is available for reports that do not use cube.

SAS Employee
I was going to suggest creating two filters in Information Map (such as Start Time and End Time) however when selecting both of these within Web Report Studio a pop-up arises stating that only one filter per dimension can be used.

The other option is a SAS Stored Process where two prompts can be created. Note that the Stored Process code will need to include the proper MDX statements to select the range of members between the start time and end time prompt selections. Similar to the construct:
{([Time].[Month].[1] : [Time].[Month].[2] )}

~ Angela



SAS is headed back to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team.

Interested in speaking? Content from our attendees is one of the reasons that makes SAS Innovate such a special event!

Submit your idea!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Get the $99 certification deal.jpg



Back in the Classroom!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2 in conversation