Displaying Week and Mindate and max date in a list report for DMR

[tgs728]

Hi All,

I have a cube based report.
Time dimension -> Year ,
weekofYearDate

[tgs728]

Hi All,

I have a cube based report.
Time dimension -> Year
                              weekofYearDate
                              Date
In list report i need to show as per below can any one help me on this.

Week of year   MIndate            Max date Wk-1               01-01-2017     07-01-2017 wk-2                08-01-2017     14-01-2017

[tgs728]

Hi All,

I have a cube based report.
Time dimension -> Year
                              weekofYearDate
                              Date
In list report i need to show as per below can any one help me on this.

Week of year   Mindate            Max date
Wk-1               01-01-2017     07-01-2017
wk-2                08-01-2017     14-01-2017

[Deep750]

If it is in the same hiearachy, and date is on the level below week, you can use lastChild() and firstChild-function.
These functions will pick the first and last child of the week.

[CognosPaul]

if you try to use first and last child in a list, you'll get no results. Essentially you'll be doing something like:

select date from table where date = '2017-01-08' and date = '2017-01-14'

You could do something like wrapping roleValue('_memberCaption',) around the first and last child, but that's ugly.

Instead, why not go back to the model and add "week start" and "week end" dates as attributes? That way you won't have any issues with conflicting family members.