[Jira 6/EazyBI] Calculated member

[Jerome Renaud]

Hi All,

I'm trying to sum days spent for Projects Vs days spent for bugs, support.

First thing I want to filter projects via project code then by issue type. I'm a MDX newbie so I've done something like that

IIF ([Issue Type].currentMember <> [Issue Type].[Bug] 
AND [Issue Type].currentMember <> [Issue Type].[Customer Support]
,
Sum({
([Project Code].[TD Proj], [Measures].[Days spent]),
([Project Code].[BU All RM], [Measures].[Days spent]),
([Project Code].[BU All ND], [Measures].[Days spent]),
([Project Code].[BU huma RM], [Measures].[Days spent]),
([Project Code].[R&D projects], [Measures].[Days spent]),
([Project Code].[BU Transport RM], [Measures].[Days spent]),
([Project Code].[BU Transport ND], [Measures].[Days spent]),
([Project Code].[BU Waste RM], [Measures].[Days spent]),
([Project Code].[BU Waste ND], [Measures].[Days spent])
})
,0)

But of course it does not work. If I expand issue type the value is set to 0 as expected for "Bugs" and "Customer Support" but the total is including those issue types.

How can I do it? 

Thank you for your help.

[graemejohnson]

Hi, I'm trying to achieve something very similar to this.  Did you ever get it working?

[Jerome Renaud]

Nope. Had to to it differently...

[Ilze Leite-Apine]

Hi Jerome,

Could you please save the report, export the report definition (here is described how to do that: https://docs.eazybi.com/display/EAZYBI/Create+reports#Createreports-Exportandimportreportdefinitions) and send it to support@eazybi.com or paste here to find out why the formula doesn't work for you.

Kind regards,

Ilze, a colleague of Jānis

[JānisJ]

Hi Jerome,

I am truly sorry about the delay in answering you.
If I correctly understand your requirements, you need to create two Measure Calculated Members:
1. Days spent for Projects
with the formula:

IIF( 
  [Issue Type].CurrentMember.Level IS [Issue Type].[(All)], 
  Sum(
    Descendants([Issue Type].CurrentMember, [Issue Type].[Issue Type]),
    [Measures].[Days spent for Projects]
  ),
  IIF(
    [Issue Type].CurrentMember.Name = 'Bug'
    OR [Issue Type].CurrentMember.Name = 'Customer Support',
    0,
    [Measures].[Days spent]
  )
)

2. Days spent for Bugs/Support
with the formula:

[Measures].[Days spent] - [Measures].[Days spent for Projects]

To filter necessary projects, place Project Code dimension in Pages and then select multiple project codes in the dropdown.

Best regards,

Jānis.

[Jerome Renaud]

Hi Jānis, no sweat, happy to see someone :)

It's not working though, even fixing the type (line 5 [Measures].[Days spent for Projects] should be [Days spent], right?). If I use your formula for "Days spent for Projects" then "Days spent for Projects" = "total days spent"

any idea?

regards,

Jerome

[Jerome Renaud]

Ok it seems that EazyBI Team is no longer following this... too bad :(