How to exclude specific issues in eazyBI formula

[hirok]

Hi all,

I'm pretty new in eazyBI and I guess my request is very simple.

I defined a calculated members in Columns's Measures like below to create a curve of issue total.
This looks fine.
However I'd like to exclude some issues which were created before May 23 2013.

----
[Measures].[Created Toatl] =

CoalesceEmpty(NonZero(Sum(
-- time periods from start of time to current period
{ Generate(StripCalculatedMembers(
Ascendants([Time].CurrentHierarchyMember)),
IIF([Time].CurrentHierarchyMember IS
[Time].CurrentHierarchyMember.FirstSibling, {},
{ [Time].CurrentHierarchyMember.FirstSibling:
[Time].CurrentHierarchyMember.PrevMember } ) ),
[Time].CurrentHierarchyMember
},
(
[Measures].[Issues created],
[Issue Type].[Bug]
)
)))
----

How can I modify this formula to exclude those items?
Any comment would be helpful for me.

Thanks,
hiro

[Lauma Cīrule · Accepted solution]

Hi Hiro!

You can count all bugs created after May 23 2013 with formula

NonZero(count(Filter(Generate(NonEmptyCrossJoin(
      [Issue].[Issue].Members, 
      [Time].CurrentHierarchyMember), [Issue].CurrentMember),
    [Measures].[Issue type] = 'Bug' AND
    DateCompare(DateParse([Measures].[Issue created date]), 
      DateParse('23 May 2013')) > 0
)))

This filters out all issues that have issue type 'Bug' and their creation date is greater than May 23 2013; and then counts them.

Kind regards,

Lauma

[hirok]

Hi Lauma,

Thank you so much!
Your formula works great.

I was able to create a graph that I wanted.

Thanks again,
hiro

[Emmanuel Boukandoura]

Hi I've applied this formaula on a cube with > 8000 issues, and EazyBI plugin does not achieve to compute it in less than 60 seconds. I must add we followed your suggestions regarding PostgreSQL server setup and we run it on a decent server (8 cores, 8 Gb or RAM 4 of which are allcoated to JIRA heap)

Any idea to make it usable?

Many thanks,

Emmanuel

[Lauma Cīrule]

Hi Emmanuel,

8000 issues cube should not be a problem. It could be though that report has some other complicated calculations. Could you please specify what other dimensions you are using on rows, columns and pages?

You can also contact me with these details directly over e-mail support@eazybi.com

Kind regards,
Lauma

[Emmanuel Boukandoura]

Hi Lauma,

As suggested, I'll carry on with this discussion by mail.

Thanks,

Emmanuel