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()
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
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.