filter in report studio using cube as source

[phanicrn]

we are creating reports in report studio from transformer cube as source.I have time dimenion(create date) & we created relative time categories based on time dimension like current quarter,prior quarter,qtd, prior qtd, ytd, prior ytd, current month, prior month. Now in report studio i want filter in my report studion as

createdate.quarter <= relativetime.current quarter and create.quarter >= prior quarter

but no data returns.. I tried filter(), caption()

[kado]

Did you ever get a resolution for this? Or find any good resources? I am having a similar issue acquiring relative dates based on a prompt ... ?MonthPar? ...

I want to filter from the cube similar to a dateadd(month, -1, ?MonthPar?) in SQL .... I also tried using the Parallel_Period function without success ....

It looks like I should try the 'caption' syntax based on your and others posts (but it doesn't look too promising)

thanks

[david.stachon]

If you're using relative time categories in your PowerPlay cube there's no reason you need to use a filter....

In your Query, from your "Insertable Objects" pane, just drag in your relative time period members.

For example, under the MTD hierarchy, expand "Members" ...then you should see "MTD" (as a member, not as a hierarchy) ...just drag that into your query and onto your report.