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.
find function lastPeriods its Ok.
now cant find correct formula
this:
lastPeriods(1000, [#prompt('start_date','date')#])
not work >:(
i need to convert prompt date value '2015-09-29' into member and then use lastPeriod function.
It is possible?
#'lastPeriods(10, [' + prompt('start_date','token') + '])'#
work but wery slow :(
Quote from: en1 on 29 Sep 2015 09:18:59 AM
#'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.
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
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,
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.