date compare (dimensional)

[en1]

Hi!
I have standart date dimension (hierarchy). How can select members (days) dates before '?start_date?'  without use filter function?
I try PeriodsToDate but its something other result.

[en1]

find function lastPeriods its Ok.
now cant find correct formula

this:

lastPeriods(1000, [#prompt('start_date','date')#])

not work  >:(

[en1]

i need to convert prompt date value  '2015-09-29' into member and then use lastPeriod function.
It is possible?

[en1]

#'lastPeriods(10, [' + prompt('start_date','token') + '])'#

work but wery slow  :(

[MFGF]

#'lastPeriods(10, [' + prompt('start_date','token') + '])'#

work but wery slow  :(

This really shouldn't be slow - it is retrieving only 10 members, and directly from your cube. It ought to be far more efficient than a filter() function. Can you create a new report using this as a query calculation and see how it performs in isolation?

MF.

[en1]

Final version (maybe help somebody)

DataItem1
#
'[Cube].[Date].[Period].[Day]->:[PC].[@MEMBER].[' + prompt(
'paramDay',
'token',
'some default value') +
']'#

DataItem2
lastPeriods(10,[Data Item1])

work fast, in my case was problem on server java process use huge memory size

[srinu_anu2007]

Check if its useful.

lastPeriods (8,parent (#prompt('Param_Month','MUN','[rp_gcrs].[rp_period].[rp_period].[Month]->:[TM].[rp_period].[rp_period].[@MEMBER].

Thanks,

[en1]

it seems wrong results. i test lastPeriods on date 2009-01-01 and get 2011 year and 2012 year dates. Meanwhile function periodsToDate can be used and work fine.