Project Last updated date

Hi Team,

I am trying to create a report of projects and issues created to showcase the projects not being used. Also want to show Last Issue updated date against those projects like in the screenshot below
Can we get Last Issue updated date in eazybi reports by defining a Calculated Members.

Can you pls help me with the formula

Regards,
Vishwas

Hi @Vishwas,

Yes, you can get the last issue updated date with the following MDX function:

Tail(
Filter(
    [Time].CurrentHierarchy.Levels("Day").Members,
    [Measures].[Issues last updated] > 0
  )).Item(0).StartDate

Please make sure to use one of the date formatings for this calculated measure.

Lauma / support@eazybi.com

Hi Lauma,

Thanks for the formula.
But i am getting this error.

#ERR: mondrian.olap.fun.MondrianEvaluationException: Exception while executing function StartDate: java.lang.UnsupportedOperationException at mondrian.olap.fun.FunUtil$NullMember.getUniqueName(FunUtil.java:3595) at com.eazybi.mondrian.udf.DateUtils.periodStartDatesWithCache(DateUtils.java:310) at com.eazybi.mondrian.udf.StartDateUdf.execute(StartDateUdf.java:15) at mondrian.olap.fun.UdfResolver$ScalarCalcImpl.evaluate(UdfResolver.java:198) at mondrian.rolap.RolapEvaluator.evaluateCurrent(RolapEvaluator.java:823) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1153) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1304) at mondrian.rolap.RolapResult.executeStripe(RolapResult.java:1304) at mondrian.rolap.RolapResult.executeBody(RolapResult.java:1016) at mondrian.rolap.RolapResult.(RolapResult.java:504) at mondrian.rolap.RolapConnection.executeInternal(RolapConnection.java:651) at mondrian.rolap.RolapConnection.access$000(RolapConnection.java:53) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:602) at mondrian.rolap.RolapConnection$1.call(RolapConnection.java:600) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at java.lang.Thread.run(Thread.java:748)

Can you pls help

Regards,
Vishwas

Hi @Vishwas!

I imagine this could be that for some dimension level there are no issues. Please try to wrap the function in the following CASE condition.

CASE WHEN ([Measures].[Issues last updated], [Time].CurrentHierarchy.DefaultMember) > 0 
THEN 
Tail(
Filter(
    [Time].CurrentHierarchy.Levels("Day").Members,
    [Measures].[Issues last updated] > 0
  )).Item(0).StartDate
END

If this does not work, please export report definition and send it to support@eazybi.com (mention that we are discussing it in this community thread).

Lauma / support@eazybi.com

Thanks @lauma.cirule it’s working like charm.

Regards,
Vishwas

1 Like