Assignee Calculated Member not reflected in Row totals

Questions & Answers
1

The Aggregated Calculated members within my Assignees have stopped working in tables.
Although the numbers show correctly in the table body, when the Row Totals are selected the Total is the All Assignees total not the Total of the issues shown in the rows of the Calculated Member

These calculated aggregated members have been working correctly until today. I am unsure what can cause them to stop working.

image
image1064Ă—709 86.8 KB

The aggregated calculated member I use is as follows it is an aggregation of other calculated members with individual assignees within them:

AGGREGATE({
[Assignee].[IBM Absence],
[Assignee].[IBM Compensation],
[Assignee].[IBM HCM],
[Assignee].[IBM Recruitment],
[Assignee].[IBM Talent & Performance],
[Assignee].[IBM Integrations],
[Assignee].[IBM Non Functional]
})

This was working correctly until this week.

2

Hi @Barbs

We did some improvements yesterday in the eazyBI cloud to improve some drill features.
Maybe it affected the feature “Total” as well, but then there was another upgrade later the same day.
Can you please try to run this report today ?
If the problem still persists reach out to support@eazybi.com and provide the definition of your report.

We were not able to repeat this behavior just now on the same report layout.
Martins / eazyBI

3

This is still not working for the calculated member mentioned in my question.
Thanks
Barbara

4

Actually, to be more helpful there.
If I have an aggregated calculated member that has assignees within it, the total is working fine.
For the aggregated calculated member that is a calculation based on other calculated members it is not working.

Barbs

5

@Barbs
Please export and share your report definition
https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Exportandimportreportdefinitions

Martins

6

Here it is
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Design Issues Weekly Dues against Priority”,
“folder_name”: “6. Design Workshop Reports”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[Issues due]"],“members”:null},{“name”:“Time”,“selected_set”:["[Time.Weekly].[Week].Members"],“members”:[{“depth”:2,“name”:“W02, Jan 10 2000”,“full_name”:"[Time.Weekly].[2000].[W02, Jan 10 2000]",“drillable”:true,“removed”:true},{“depth”:2,“name”:“W15, Apr 06 2020”,“full_name”:"[Time.Weekly].[2020].[W15, Apr 06 2020]",“drillable”:true,“removed”:true},{“depth”:2,“name”:“W30, Jul 20 2020”,“full_name”:"[Time.Weekly].[2020].[W30, Jul 20 2020]",“drillable”:true,“removed”:true},{“depth”:2,“name”:“W52, Dec 21 2020”,“full_name”:"[Time.Weekly].[2020].[W52, Dec 21 2020]",“drillable”:true,“removed”:true}],“bookmarked_members”:null}]},“rows”:{“dimensions”:[{“name”:“Assignee”,“selected_set”:["[Assignee].[IBM]","[Assignee].[NVS]"],“members”:null,“bookmarked_members”:null},{“name”:“Priority”,“selected_set”:["[Priority].[All Priorities]"],“members”:[{“depth”:0,“name”:“All Priorities”,“full_name”:"[Priority].[All Priorities]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false,“removed”:true}],“bookmarked_members”:null}],“nonempty_crossjoin”:true},“pages”:{“dimensions”:[{“name”:“Project”,“selected_set”:["[Project].[HCM Program]"],“members”:[{“depth”:1,“name”:“HCM Program”,“full_name”:"[Project].[HCM Program]",“drillable”:true,“key”:“HP”}],“bookmarked_members”:[{“depth”:1,“name”:“HCM Program”,“full_name”:"[Project].[HCM Program]",“drillable”:true,“key”:“HP”},{“depth”:2,“name”:“Group 1”,“full_name”:"[Project].[HCM Program].[Group 1]",“url_id”:14197,“parent_key”:“HP”},{“depth”:2,“name”:“Group 2”,“full_name”:"[Project].[HCM Program].[Group 2]",“url_id”:14198,“parent_key”:“HP”},{“depth”:2,“name”:“Group 3”,“full_name”:"[Project].[HCM Program].[Group 3]",“url_id”:14199,“parent_key”:“HP”},{“depth”:2,“name”:“Group 4”,“full_name”:"[Project].[HCM Program].[Group 4]",“url_id”:14200,“parent_key”:“HP”}],“current_page_members”:["[Project].[HCM Program]"]},{“name”:“Issue Type”,“selected_set”:["[Issue Type.By type].[Standard].[Enabler]","[Issue Type.By type].[Standard].[Task]"],“members”:[{“depth”:2,“name”:“Enabler”,“full_name”:"[Issue Type.By type].[Standard].[Enabler]"},{“depth”:2,“name”:“Task”,“full_name”:"[Issue Type.By type].[Standard].[Task]"}],“bookmarked_members”:[{“depth”:2,“name”:“Enabler”,“full_name”:"[Issue Type.By type].[Standard].[Enabler]"},{“depth”:2,“name”:“Task”,“full_name”:"[Issue Type.By type].[Standard].[Task]"},{“depth”:1,“name”:“Enabler”,“full_name”:"[Issue Type.By name].[Enabler]",“drillable”:true},{“depth”:1,“name”:“Task”,“full_name”:"[Issue Type.By name].[Task]",“drillable”:true},{“depth”:2,“name”:“Task”,“full_name”:"[Issue Type.By name].[Task].[Task]"}],“current_page_members”:["[Issue Type.By type].[Standard].[Enabler]","[Issue Type.By type].[Standard].[Task]"]},{“name”:“Label”,“selected_set”:["[Label].[Design Workshop_Labels]"],“members”:[{“depth”:0,“name”:“Design Workshop_Labels”,“full_name”:"[Label].[Design Workshop_Labels]",“calculated”:true,“drillable”:true,“dimension”:“Label”}],“bookmarked_members”:[{“depth”:1,“name”:“LWS”,“full_name”:"[Label].[LWS]"},{“depth”:1,“name”:“DIWS”,“full_name”:"[Label].[DIWS]"},{“depth”:1,“name”:“IWS”,“full_name”:"[Label].[IWS]"},{“depth”:1,“name”:“GWS”,“full_name”:"[Label].[GWS]"},{“depth”:1,“name”:“Integrations”,“full_name”:"[Label].[Integrations]"}],“current_page_members”:["[Label].[Design Workshop_Labels]"]},{“name”:“Resolution”,“selected_set”:["[Resolution].[All Resolutions]"],“members”:[{“depth”:0,“name”:“All Resolutions”,“full_name”:"[Resolution].[All Resolutions]",“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:"(unresolved)",“full_name”:"[Resolution].[(unresolved)]",“parent_full_name”:"[Resolution].[All Resolutions]"}],“bookmarked_members”:null,“current_page_members”:["[Resolution].[(unresolved)]"]}]},“options”:{“nonempty”:true,“total”:true},“view”:{“current”:“table”,“maximized”:false,“table”:{“cell_formatting”:{},“vertical_header”:true}},“calculated_members”:null}
} ],
“calculated_members”: [{“name”:“Design Workshop_Labels”,“dimension”:“Label”,“formula”:“AGGREGATE({\n[Label].[GWS],\n[Label].[LWS],\n[Label].[IWS],\n[Label].[DIWS],\n[Label].[Strawman],\n[Label].[General]\n})”,“format_string”:“StringFormatter”},{“name”:“IBM Compensation”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[MANMOHAN.DUBEY_EXT],\n[Assignee].[STEFAN.KAISER_EXT],\n[Assignee].[Thifane Albuquerque]\n})”,“format_string”:""},{“name”:“IBM Absence”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[Jo ann chua],\n[Assignee].[Chaitanya Chinta],\n[Assignee].[Manoj Naithani],\n[Assignee].[PUNITH.KUMAR_EXT]\n})”,“format_string”:""},{“name”:“IBM HCM”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[ANNABELLE.STOKER_EXT],\n[Assignee].[Divya Santhosh kumar],\n[Assignee].[Hilda Shalovinsky],\n[Assignee].[jasmine.quartey_owoo_ext],\n[Assignee].[JULIO.VILLAR_EXT],\n[Assignee].[Karen De Winter],\n[Assignee].[MADAN.JAGANNATHAN_EXT],\n[Assignee].[Parminder Singh]\n})”,“format_string”:""},{“name”:“NVS Recruitment”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[joschka_robert.siemer],\n[Assignee].[Kristyna Zborilova],\n[Assignee].[Nino Jangavadze]\n})”,“format_string”:""},{“name”:“NVS Absence”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[adriana.jedrasiak],\n[Assignee].[Emilie Fontaine],\n[Assignee].[Milan Soldan]\n})”,“format_string”:""},{“name”:“NVS HCM”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[David Campbell],\n[Assignee].[Carol Gan],\n[Assignee].[elzet.hattingh],\n[Assignee].[Estefania Angeles],\n[Assignee].[jana.milovanovic],\n[Assignee].[kunduz.almazbek_kyzy],\n[Assignee].[priscilla.hoong],\n[Assignee].[SUHANI MATHUR],\n[Assignee].[Viviana Barrera]\n})”,“format_string”:""},{“name”:“IBM Recruitment”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[Foong-Ming Tan],\n[Assignee].[Uzma Hossain]\n})”,“format_string”:""},{“name”:“NVS Compensation”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[Filip Sinagl],\n[Assignee].[oliver.kraus],\n[Assignee].[Santosh Gupta]\n})”,“format_string”:""},{“name”:“IBM Integrations”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[Pankhuri Garg],\n[Assignee].[anna.narizhna_ext],\n[Assignee].[olga-1.kucherova_ext],\n[Assignee].[Mithun Nair]\n})”,“format_string”:""},{“name”:“NVS Integrations”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[Manoj Naithani],\n[Assignee].[Valentin Filimonov]\n})”,“format_string”:""},{“name”:“IBM Non Functional”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[CHRISTIAN-1.WENDT_EXT],\n[Assignee].[Inge Kodden],\n[Assignee].[Katie Williamson],\n[Assignee].[Kakul Khan],\n[Assignee].[Hitesh Grover],\n[Assignee].[jaime.lascelles_ext],\n[Assignee].[matteo.belloni_ext],\n[Assignee].[MAXIME.WIELEMANS_EXT],\n[Assignee].[PIOTR.MACZKOWSKI_EXT],\n[Assignee].[Sarah Brewster],\n[Assignee].[SURYAKANT.SHUKLA_EXT]\n})”,“format_string”:""},{“name”:“NVS Non Functional”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[Adela Francu],\n[Assignee].[Andreea Dorcu],\n[Assignee].[SIDDHARTH.KRISHNAN],\n[Assignee].[Amit Agarwal],\n[Assignee].[amit.pangarkar_ext],\n[Assignee].[AUDITYA_VENKATA.VINNAKOTA],\n[Assignee].[Barbara Murray],\n[Assignee].[Carlos Ortega Alvarez],\n[Assignee].[Cristina Tigulschi],\n[Assignee].[Diana Sonus],\n[Assignee].[Elizabeth Scherer],\n[Assignee].[Fernanda Moraes],\n[Assignee].[gabriela.vesela],\n[Assignee].[GROSU GABRIELA],\n[Assignee].[Harsimran Kaur],\n[Assignee].[Idriss Bechir Outman],\n[Assignee].[jamal.hamzi],\n[Assignee].[JAYSHREE.AGARWAL],\n[Assignee].[jayeeta.chatterjee],\n[Assignee].[Joe Herman],\n[Assignee].[jonathan.parker],\n[Assignee].[Joy Bellefontaine],\n[Assignee].[karina.kim],\n[Assignee].[Kolja Hellmann],\n[Assignee].[KRZYSZTOF.LUCZAK_EXT],\n[Assignee].[Laura Zamorano],\n[Assignee].[Lenka Klusová],\n[Assignee].[Mary Hanghal],\n[Assignee].[Michael Bolan],\n[Assignee].[Michal Szapu],\n[Assignee].[Paul Kinehan],\n[Assignee].[radomir.adamek_ext],\n[Assignee].[ramakrishna.reddy],\n[Assignee].[RENATA.YOKOTA],\n[Assignee].[sapthagiri.chinthamani],\n[Assignee].[Sasa Djordjevic],\n[Assignee].[scarlett.stredel],\n[Assignee].[Shivendra Sharma],\n[Assignee].[Tamara Jelinek],\n[Assignee].[zanna.sarfa]\n})”,“format_string”:""},{“name”:“IBM”,“dimension”:“Assignee”,“formula”:“AGGREGATE({\n[Assignee].[IBM Absence],\n[Assignee].[IBM Compensation],\n[Assignee].[IBM HCM],\n[Assignee].[IBM Recruitment],\n[Assignee].[IBM Talent \u0026 Performance],\n[Assignee].[IBM Integrations],\n[Assignee].[IBM Non Functional]\n})”,“format_string”:""},{“name”:“NVS”,“dimension”:“Assignee”,“formula”:“Aggregate({\n[Assignee].[NVS Absence],\n[Assignee].[NVS Compensation],\n[Assignee].[NVS HCM],\n[Assignee].[NVS Recruitment],\n[Assignee].[NVS Talent \u0026 Performance],\n[Assignee].[NVS Integrations],\n[Assignee].[NVS Non Functional]\n})”,“format_string”:""}]
}

7

@Barbs

I was able to locate your report “Design Issues Weekly Dues against Priority” on your eazyBI account.
And I don’t see there that the Total row is incorrect for any of the weeks.

For Aggregate of Aggregates there is a different method.
This would be the correct syntax:

AGGREGATE({
Childrenset([Assignee].[IBM Absence]),
Childrenset([Assignee].[IBM Compensation]),
Childrenset([Assignee].[IBM HCM]),
Childrenset([Assignee].[IBM Recruitment]),
Childrenset([Assignee].[IBM Talent & Performance]),
Childrenset([Assignee].[IBM Integrations]),
Childrenset([Assignee].[IBM Non Functional])
})

But that wasn’t changed yesterday in eazyBI.

Martins

8

hi, if you open up the individual calculated members e.g. IBM or NVS you will see that the items within them do not add up to the numbers you see on the screen.
e.g IBM shows for for W35 Aug but when you open it up there are none.

You will see that the numbers are exactly the same for both IBM and NVS, which they shouldn’t be, so maybe it is the calculated member that is not working correctly, sorry for misleading you

9

You would need to use CHildrenset for the second level aggregate.
See I made changes to your both your calculated members IBM and NVS
Please check the report now.

Martins

1 Like
10

Thanks very much for fixing that!
Is that a new thing as they worked before?
Anyway, I will use this method from now on.
Barbs

11

@Barbs
You are welcome.
This is not something new.
It had to work also earlier and It wasn’t changed yesterday.
I believe the “Total” could have been affected by yesterday’s upgrade in eazyBI, but then it was fixed later on the same day.
I don’t have a better explanation why your report (with previous calculated members) was working correctly before yesterday.

Martins