creating Date Range prompt in Analysis Studio

[cham]

Hi,

I have a requirement to create a date range prompt in Analysis Studio where business user can input the date range for which they want to see the analysis data.

Can anybody help me out how to create a date range prompt(where use can input the start date and the end date)?

thank you in advance.

[MFGF]

Hi,

This may not be exactly what you are looking for, but may be close enough:

Drag the Date hierarchy into the Context area in the top right corner, then click the down-arrow next to it and enable the option "Use as "GoTo" Parameter", then save the analysis.

This should result in a tree prompt being generated when the analysis is run via the Cognos Viewer.

Regards,

MF.

[cham]

Thank you MF for your response.

I know what you are suggesting. But for the tree prompt the user has to roll down to the lower level , and they don't want to do that. They want something like instant prompt which will ask them the start date and the end date both and after running the analysis it should show up the analysis details for that date range given. I know we can do the date range prompt in report studio, but not sure about analysis studio.

Please let me know if somebody knows about it.

[MFGF]

Hi,

From Analysis Studio, the above is all you can do, sorry.  The only other option would be to create the analysis in Analysis Studio, then open it in Report Studio to add the prompts.  This would then mean you could no longer edit it with Analysis Studio though.

Regards,

MF.

[cham]

Do you have any idea, if I can filter the data using a date range. I mean to say, if I create a filter like date > <start date> and date < <end date>. If this is possible or any other work around for this, please let me know. I really need this.

[MFGF]

Hi,

If the dates are used in the rows or columns of your analysis, you can set up filters using > and < - just select the relevant set of date members, right-click and use the option to define a custom filter.

Regards,

MF.

[cham]

Hi,

Can you please tell me the details step to create the filter for date range. In my analysis, the date is in rows. then I tried to create a filter on rows. But while creating it it is giving me option to choose for type(only measure and label). If I choose label, I don't see any operator for giving the rage like > and <.

So, please let me know the detail steps. May be I am missing something.

Thank you in advance.

[MFGF]

Yes - you are right - looking at this again, > and < operators are only valid for measures.

You would probably need to use the "begins with" and "ends with" operators inventively to get the correct date range you require (if this is possible), or else just drag in the set of dates you want to use directly from the package tree.  You might also try using the Search facility on the dimension to locate the required set of dates more easily.

Oh, and sending me two PMs in 13 minutes demanding an answer distracted me from putting together this reply while I read them, so in fact delayed your answer somewhat :)

MF.

[cham]

Hi MFGF,

Thank you for your quick response.

As per your suggestion, I tried to use begins with and ends with operators, it is not working as date range, it is working as individual filters.

I tried search facility , for that I have to choose each and every date to get into context filter which is very hectic for a date rage span for say 40 days or so. even the ctrl+shift key is also not working to select multi dates in one shot.

From package tree, if I have to select the date range then I have to expand the particular dimension, and it contains more than 2 yrs of date which is time consumption to expand it to that details.

Any suggestion on this?

thank you.

[cham]

Any help in this?