eazyBI - how to load report with current week by default

[Peter Bengov]

I'm using a lot the option to drop-down the week number to populate the report's data with. 

eazybi wwekly.PNG

However, in dashboards with multiple reports of this kind it could be very useful if the week shown is the current week. Can this be configured?

Also - a feature request: dashboard-level dimensions. Instead of picking a time or any other dimension per report cube, add the option to add that dimension into the whole dashboard so it could update all reports right away. 

Thanks

[Lauma Cīrule · Accepted solution]

Hi Peter,

1. You can create a 'Current week' calculated member with following calculated member formula (note that it has to be created in Time.Weekly hierarchy)

   Aggregate({[Time.Weekly].[Week].CurrentDateMember})

   Then you can use this calculated member instead of selecting the week in your reports - it will automatically always have the current week aggregated.

2. Thank you for suggestion, but there already is such a feature - you can make the report page as common dashboard page. When the common page is changed all the reports that use this Page filter in dashboard will have the common page selection. See more details here https://docs.eazybi.com/display/EAZYBI/Create+dashboards#Createdashboards-Commondashboardpagedimensions.

Let me know if there is anything else I can assist you with!
Kind regards,
Lauma / support@eazybi.com 

[Peter Bengov]

Thanks a lot Lauma for both answers. 

Regarding #1 - is there a way I can combine the ability to show Current week with previous weeks (selected using a drop-down)?

[Peter Bengov]

Also, is there a way to take the last 4 weeks into account? Like instead of Current week set the filter to last 4 week. I've tried using this in the Time dimension calculated section, as per https://docs.eazybi.com/display/EAZYBI/Calculated+members#Calculatedmembers-Timedifferencecalculations:

Filter(
  [Time.Weekly].[Week].Members,
  DateBetween([Time.Weekly].[Week].CurrentMember.StartDate,'4 weeks ago','today')
)

But getting this error after hitting Create:

Formula is not valid: 
Member expression 'Filter([Time.Weekly].[Week].Members, DateBetween([Time.Weekly].[Week].CurrentMember.StartDate, "7 days ago", "today"))' must not be a set

Thanks for the help

[Lauma Cīrule]

Yes, you are on the right track for the formula as well. It is only necessary to put the Aggregate(..) function around the set 

Aggregate(
Filter(
  [Time.Weekly].[Week].Members,
  DateBetween([Time.Weekly].[Week].CurrentMember.StartDate,'4 weeks ago','today')
))

Please make sure you create the formula in the Weekly Time hierarchy (you can select the hierarchy on the top of formula editing screen - next to the calculated member name).

[Adam Schultz]

Hello, to chime in an adaptation. 
Setting the page to a calculated "Current Date Member" works for keeping the Dashboard fresh. However, the drop down items are listed in Ascending order with the current week on top. Instead of that jarring effect of newest to oldest. It be great to list the weeks in descending order. I didn't have much luck with the Order function so created this calculated member:

Aggregate({
[Time].[Current Week], 
[Time.Weekly].[Week].CurrentDateMember.Lag(1),
[Time.Weekly].[Week].CurrentDateMember.Lag(2),
[Time.Weekly].[Week].CurrentDateMember.Lag(3),
[Time.Weekly].[Week].CurrentDateMember.Lag(4),
[Time.Weekly].[Week].CurrentDateMember.Lag(5),
[Time.Weekly].[Week].CurrentDateMember.Lag(6),
[Time.Weekly].[Week].CurrentDateMember.Lag(7),
[Time.Weekly].[Week].CurrentDateMember.Lag(8),
[Time.Weekly].[Week].CurrentDateMember.Lag(9),
[Time.Weekly].[Week].CurrentDateMember.Lag(10)
})

Given we are only looking back X amount of weeks, it's not terrible. Hope this helps. 
 

[Satish_Kumar]

EazyBI demo page has a simpler solution for WeeklyReverse order, check it out at https://eazybi.com/accounts/1000/cubes/Issues/reports/63909-issues-created-vs-resolved-by-priority

There is a calculated Time Dimension, WeeklyReverse order. The formula they have given is below & it seems to work well. Thanks eazyBI Team.

Aggregate(
Order(
[Time.Weekly].[Week].Members,
[TIme].CurrentHierarchyMember.StartDate, DESC))