Hi Team,
Can you please help me to create an MDX measure where I can sum the “Stroy Points” in the measure “Revised Target” which is in this report.
Report Definition:
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Build Earned Value Run Rate (NEW-WIP)”,
“folder_name”: “LDC - Build - IT”,
“result_view”: “line_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[Story Points Actual]”,“[Measures].[Story Points Planned]”,“[Measures].[Revised Target]”,“[Measures].[Story points Planned New]”],“members”:[{“depth”:0,“full_name”:“[Measures].[Story Points Actual]”,“format_string”:“#,##0.00”,“report_specific”:true,“name”:“Story Points Actual”,“calculated”:true},{“depth”:0,“full_name”:“[Measures].[Story Points Planned]”,“format_string”:“#,##0.00”,“report_specific”:true,“name”:“Story Points Planned”,“calculated”:true},{“depth”:0,“full_name”:“[Measures].[Story points Planned New]”,“format_string”:“#,##0”,“report_specific”:true,“name”:“Story points Planned New”,“calculated”:true}]}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:[“[Time.Weekly].[2022]”,“[Time.Weekly].[2023]”,“[Time.Weekly].[2024]”],“selected_set_expression”:“DescendantsSet({{selected_set}}, [Time.Weekly].[Week])”,“members”:,“bookmarked_members”:}],“filter_by”:{“conditions”:[{“expression”:“[Time.Weekly].CurrentHierarchyMember”,“operator”:“between”,“value”:“Oct 16 2023, Jul 26 2024”,“value_type”:“date”}],“others”:false}},“pages”:{“dimensions”:[{“name”:“Time”,“duplicate”:true,“selected_set”:[“[Time.Weekly].[All Times]”,“[Time.Weekly].[Current week]”,“[Time.Weekly].[Previous week]”,“[Time.Weekly].[Last 4 weeks]”,“[Time.Weekly].[Last 12 weeks]”],“members”:[{“depth”:0,“name”:“All Times”,“full_name”:“[Time.Weekly].[All Times]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“2022”,“full_name”:“[Time.Weekly].[2022]”,“drillable”:true,“parent_full_name”:“[Time.Weekly].[All Times]”},{“depth”:1,“name”:“2023”,“full_name”:“[Time.Weekly].[2023]”,“drillable”:true,“parent_full_name”:“[Time.Weekly].[All Times]”},{“depth”:1,“name”:“2024”,“full_name”:“[Time.Weekly].[2024]”,“drillable”:true,“parent_full_name”:“[Time.Weekly].[All Times]”}],“bookmarked_members”:,“current_page_members”:[“[Time.Weekly].[2022]”,“[Time.Weekly].[2023]”,“[Time.Weekly].[2024]”]},{“name”:“Status”,“selected_set”:[“[Status].[Status Work Item]”,“[Status].[Status Epic]”],“members”:[{“depth”:0,“name”:“Status Work Item”,“full_name”:“[Status].[Status Work Item]”,“calculated”:true,“drillable”:true,“dimension”:“Status”,“expanded”:false,“drilled_into”:false}],“bookmarked_members”:,“current_page_members”:[“[Status].[Status Work Item]”]},{“name”:“Issue Type”,“selected_set”:[“[Issue Type].[All Issue Types]”],“members”:[{“depth”:0,“name”:“All Issue Types”,“full_name”:“[Issue Type].[All Issue Types]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“Work Item”,“full_name”:“[Issue Type].[Work Item]”,“parent_full_name”:“[Issue Type].[All Issue Types]”},{“depth”:1,“name”:“Work Item Dev”,“full_name”:“[Issue Type].[Work Item Dev]”,“parent_full_name”:“[Issue Type].[All Issue Types]”},{“depth”:1,“name”:“Work Item INT”,“full_name”:“[Issue Type].[Work Item INT]”,“parent_full_name”:“[Issue Type].[All Issue Types]”}],“bookmarked_members”:,“current_page_members”:[“[Issue Type].[Work Item]”,“[Issue Type].[Work Item Dev]”,“[Issue Type].[Work Item INT]”]},{“name”:“Workstream”,“selected_set”:[“[Workstream].[Commercial]”,“[Workstream].[Procurement]”,“[Workstream].[Operations]”,“[Workstream].[Solutions]”,“[Workstream].[LDC - Workstreams]”],“members”:[{“depth”:0,“name”:“Commercial”,“full_name”:“[Workstream].[Commercial]”,“calculated”:true,“drillable”:true,“dimension”:“Workstream”}],“bookmarked_members”:,“current_page_members”:[“[Workstream].[Commercial]”]},{“name”:“Work Item type”,“selected_set”:[“[Work Item type].[Functional Specification]”,“[Work Item type].[Config Document]”,“[Work Item type].[Total Developments ]”,“[Work Item type].[Configuration Activities ]”,“[Work Item type].[All Work Item types]”],“members”:[{“depth”:0,“name”:“Functional Specification”,“full_name”:“[Work Item type].[Functional Specification]”,“calculated”:true}],“bookmarked_members”:[{“depth”:1,“name”:“OQS”,“full_name”:“[Work Item type].[OQS]”}],“current_page_members”:[“[Work Item type].[Functional Specification]”]},{“name”:“Issue Subtype”,“selected_set”:[“[Issue Subtype].[S/4HANA Total]”,“[Issue Subtype].[EDW]”],“members”:[{“depth”:0,“name”:“S/4HANA Total”,“full_name”:“[Issue Subtype].[S/4HANA Total]”,“calculated”:true,“drillable”:true,“dimension”:“Issue Subtype”}],“bookmarked_members”:,“current_page_members”:[“[Issue Subtype].[S/4HANA Total]”]},{“name”:“Release_Version”,“selected_set”:[“[Release_Version].[All Release_Versions]”],“members”:[{“depth”:0,“name”:“All Release_Versions”,“full_name”:“[Release_Version].[All Release_Versions]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“R2.0”,“full_name”:“[Release_Version].[R2.0]”,“parent_full_name”:“[Release_Version].[All Release_Versions]”}],“bookmarked_members”:,“current_page_members”:[“[Release_Version].[R2.0]”]}]},“options”:{},“view”:{“current”:“line_chart”,“maximized”:false,“line_chart”:{“area”:true,“stacked”:true,“swap_axes”:false,“data_labels”:false,“series_options”:{“Actual Completion”:{“type”:“column”,“color”:“#00875A”},“Baseline”:{“type”:“line”,“color”:“#F24B13”,“symbol”:“circle”,“dataLabelType”:false},“Revised Target”:{“type”:“line-Dash”,“color”:“#6F2DAA”,“symbol”:“diamond”,“dataLabelType”:“top vertical”},“In Progress “:{“type”:“column”,“color”:”#E74B71”},“Scheduled”:{“type”:“column”},“In Review “:{“type”:“column”,“color”:”#86DBA6”},“Backlog”:{“type”:“column”,“color”:“#274380”,“dataLabelType”:false},“Issues due”:{“type”:“column”},“Backlog New”:{“color”:“#930F34”,“type”:“column”},“Issues last updated”:{“type”:“column”},“Issues created”:{“type”:“column”},“Completed”:{“type”:“column”,“color”:“#006644”},“On Hold”:{“type”:“column”},“On Hold “:{“type”:“column”,“color”:”#FFD04D”},“In Review / Completed”:{“type”:“area”},“In Review/Completed “:{“type”:“area”,“color”:”#F24B13”},“Actual Completed”:{“color”:“#006644”,“type”:“column”},“Completed “:{“color”:”#006644”,“type”:“column”},“In Review/PQM Check/Completed”:{“color”:“#F24B13”,“type”:“column”},“On Hold”:{“color”:“#FFBC29”,“type”:“column”},“EDW dev in Quality”:{“color”:“#00C7E5”},“Screening”:{“color”:“#B31238”},“Target issue resolved”:{“type”:“line-Dash”,“color”:“#930F34”},“Linear trend In Review/PQM Check/Completed”:{“type”:“line”},“Target”:{“type”:“line-Dash”,“color”:“#FFA806”},“Target Issues”:{“type”:“line”,“separateAxis”:2},“Cumulative Complexity”:{“type”:“line”},“Cumulative Story point estimate created”:{“type”:“line”},“Cumulative Revised Target”:{“type”:“line”,“separateAxis”:2},“Cumulative Story point estimate due”:{“type”:“line”,“separateAxis”:2},“Story point estimate due”:{“symbol”:“diamond”},“PQM Check/Completed”:{“type”:“column”},“Cumulative Story Points due”:{“type”:“line”},“Cumulative In Review/PQM Check/Completed”:{“type”:“line”},“Story points Sum”:{“type”:“column”},“Story Point test”:{“type”:“column”},“In Review Story Points History”:{“type”:“column”},“Points Actual”:{“color”:“#F95E16”},“Story Points Actual”:{“type”:“column”,“color”:“#F95E16”},“Story Points Planned”:{“type”:“line”},“Cumulative Story Points Actual”:{“type”:“area”,“separateAxis”:2},“Story points new “:{“type”:“line”},“Story points Planned New”:{“type”:“line”}},“x_axis”:{“0”:{“labelOrientation”:“vertical”}},“y_axis”:{“0”:{“min”:0}}},“table”:{“freeze_header”:false}},“calculated_members”:[{“dimension”:“Measures”,“name”:“Backlog New”,“formula”:“IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[Backlog]),NULL)”,“format_string”:””},{“dimension”:“Measures”,“name”:“In Review / Completed”,“formula”:“IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[In Review]),NULL)+\nIIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[Completed]),NULL)”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Rolling predicted date”,“formula”:“-- annotations.group = Predicted by issues\nCache(CASE WHEN\n Cache(AVG(\n {[Time.Weekly].[Week].CurrentDateMember.Lag(100):\n [Time.Weekly].[Week].CurrentDateMember.PrevMember},\n ([Measures].[In Review/PQM Check/Completed],\n [Time].DefaultMember)\n )) \u003e 0\n AND\n ([Measures].[Issues due],\n [Time].CurrentHierarchy.Defaultmember) \u003e 0\nTHEN\n DateAddWorkDays("Oct 16, 2023", \n – remaining scope\n ([Measures].[Issues due],\n [Time].CurrentHierarchy.Defaultmember)\n / \n – average resolved issues per week in last 52 weeks\n Cache(AVG(\n {[Time.Weekly].[Week].CurrentDateMember.Lag(100):\n [Time.Weekly].[Week].CurrentDateMember.PrevMember},\n CoalesceEmpty(\n ([Measures].[In Review/PQM Check/Completed],\n [Time].DefaultMember),\n 0)\n )) \n * \n – workdays in week\n 5\n – expand to see either worse or best case\n – / 1.20 – for best case \n – / 0.80 – for worse case\n )\nEND)”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Target”,“formula”:“–annotations.group=Predicted by issues\nCase\nwhen\n DateInPeriod(\n ‘Oct 16, 2023’,[Time].CurrentHierarchyMember)\nthen\n NonZero((\n [Measures].[In Review/PQM Check/Completed],\n [Time].CurrentHierarchy.DefaultMember))\nWhen\n DateBetween(\n [Time].CurrentHierarchymember.StartDate,\n ‘Oct 16, 2023’,\n – predicted date by rolling period\n [Measures].[Rolling predicted date]\n )\n Then\n – current progress\n NonZero((\n [Measures].[In Review/PQM Check/Completed],\n [Time].CurrentHierarchy.DefaultMember))\n +\n – add pace for each day in future\n (AVG(\n {[Time.Weekly].[Week].CurrentDateMember.Lag(100): – should match the weeks in Rolling predicted date measure\n [Time.Weekly].[Week].CurrentDateMember.PrevMember},\n CoalesceEmpty(\n ([Measures].[In Review/PQM Check/Completed],\n [Time].DefaultMember),\n 0))\n – workdays per week\n / 1.27 )\n – axpand one of those two lines for additional scenarious\n – * 1.20 – for best case \n – * 0.80 – for worse case\n \n DateDiffWorkDays(‘Tomorrow’,[Time].CurrentHierarchyMember.NextStartDate)\nEnd",“format_string”:“”},{“dimension”:“Measures”,“name”:“Target Issues”,“formula”:“CumulativeSum(18.5)”,“format_string”:“”},{“dimension”:“Measures”,“name”:“PQM Check/Completed”,“formula”:“IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[PQM Check]),NULL)+\nIIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[Completed]),NULL)”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Story points Sum”,“formula”:“CASE WHEN\n DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0\nTHEN\n Sum(\n Filter(\n Descendants([Issue].CurrentMember,[Issue].[Issue]),\n Aggregate(\n {\n [Transition Status].[In Review],\n [Transition Status].[PQM Check],\n [Transition Status].[Completed],\n [Transition Status].[Done]\n },\n [Measures].[Issues history]\n ) \u003e 0\n ),\n [Measures].[Issue Story Points]\n )\nEND\n”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Story Points Actual”,“formula”:“IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Story Points history],[Transition Status].[In Review]),NULL)+\nIIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Story Points history],[Transition Status].[PQM Check]),NULL)+\nIIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Story Points history],[Transition Status].[Completed]),NULL)”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Story Points Planned”,“formula”:“Case when\n – show any past periods\n DateBeforePeriodEnd(\n "Oct 16, 2023",\n [Time].CurrentHierarchyMember) \n Then\nCumulativeSum([Measures].[Story Points due])\nEND\n+\n50”,“format_string”:“”},{“dimension”:“Measures”,“name”:“Story points Planned New”,“formula”:" – show any past periods\n [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember\n THEN\n Union(\n PreviousPeriods([Time].CurrentHierarchyMember),\n {[Time].CurrentHierarchyMember}\n )\n ELSE\n PreviousPeriods([Time].CurrentHierarchyMember)\n END\n\n * [Measures].[Story Points with due date]“,“format_string”:”#,##0"},{“dimension”:“Measures”,“name”:“Stroy points planned New Test”,“formula”:“CASE WHEN\n DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0\nTHEN\n Sum(\n Filter(\n Descendants([Issue].CurrentMember,[Issue].[Issue]),\n Aggregate(\n {\n [Transition Status].[In Review],\n [Transition Status].[PQM Check],\n [Transition Status].[Completed],\n [Transition Status].[Done]\n },\n [Measures].[Issues history]\n ) \u003e 0\n ),\n [Measures].[Issue Story Points]\n )\nEND\n”,“format_string”:“”}],“description”:“"Story Points Actual" is sum of Story Points in issues with Due Date on the particular Date. If the "Due Date" is changed for the issues, count of the Story Points will be decreased and increased based on the "Story Points" on that particular week. Story points added based on complexity as follows Low = 1, Medium = 2, High = 3, Very High = 5”}
} ],
“calculated_members”: [{“dimension”:“Measures”,“name”:“Issues history”,“format_string”:“#,##0”,“formula”:“Cache(\n NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),\n [Measures].[Transitions to]\n - [Measures].[Transitions from]\n ))\n + [Measures].[Transitions to]\n - [Measures].[Transitions from]\n)”},{“dimension”:“Time”,“name”:“Current week”,“format_string”:“”,“formula”:“Aggregate({\n [Time.Weekly].[Week].CurrentDateMember\n})”,“dimension_hierarchy”:“Weekly”},{“dimension”:“Time”,“name”:“Previous week”,“format_string”:“”,“formula”:“Aggregate({\n [Time.Weekly].[Week].CurrentDateMember.PrevMember\n})”,“dimension_hierarchy”:“Weekly”},{“dimension”:“Time”,“name”:“Last 4 weeks”,“format_string”:“”,“formula”:“Aggregate(\n [Time.Weekly].[Week].DateMembersBetween(‘4 weeks ago’, ‘today’)\n)”,“dimension_hierarchy”:“Weekly”},{“dimension”:“Time”,“name”:“Last 12 weeks”,“format_string”:“”,“formula”:“Aggregate(\n [Time.Weekly].[Week].DateMembersBetween(‘12 weeks ago’, ‘today’)\n)”,“dimension_hierarchy”:“Weekly”},{“name”:“Issue Story Points”,“dimension”:“Measures”,“formula”:“[Issue].CurrentHierarchyMember.get(‘Story Points’)”,“format_string”:“#,##0.00”},{“name”:“Story Points history”,“dimension”:“Measures”,“format_string”:“#,##0.00”,“formula”:“Cache(\n NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),\n [Measures].[Story Points change]\n ))\n + [Measures].[Story Points change]\n)\n”},{“name”:“Status Work Item”,“dimension”:“Status”,“formula”:“Aggregate({\n [Status].[Backlog],\n [Status].[Scheduled],\n [Status].[In Progress],\n [Status].[Screening],\n [Status].[In Screening],\n [Status].[In Review],\n [Status].[Testing],\n [Status].[PQM Check],\n [Status].[Completed],\n [Status].[Done],\n [Status].[On Hold]\n})”,“format_string”:“”},{“name”:“Revised Target”,“dimension”:“Measures”,“formula”:“/CumulativeSum([Measures].[Issues with due date])/\n\nSum(\n { PreviousPeriods([Time].CurrentHierarchyMember),\n [Time].CurrentHierarchyMember },\n [Measures].[Issues with due date]\n)”,“format_string”:“”},{“name”:“In Review/PQM Check/Completed”,“dimension”:“Measures”,“formula”:“IIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[In Review]),NULL)+\nIIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[PQM Check]),NULL)+\nIIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[Completed]),NULL)+\nIIf(DateDiffDays(Now(),[Time.Weekly].CurrentMember.Name)\u003c=0,\n([Measures].[Issues history],[Transition Status].[Done]),NULL)”,“format_string”:“”},{“name”:“Functional Specification”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Design]”,“format_string”:“”},{“name”:“S/4HANA Eco System”,“dimension”:“Issue Subtype”,“formula”:“Aggregate(\n\t{\n\t\t[Issue Subtype].[(none)],\n\t\t[Issue Subtype].[Integration-Topic],\n\t\t[Issue Subtype].[FCC],\n\t\t[Issue Subtype].[Business],\n\t\t[Issue Subtype].[Change-Impact],\n\t\t[Issue Subtype].[Data],\n [Issue Subtype].[Data Quality],\n [Issue Subtype].[Dependent Initiative],\n [Issue Subtype].[ERC],\n [Issue Subtype].[GAT],\n [Issue Subtype].[ISRM],\n [Issue Subtype].[LAT Query],\n [Issue Subtype].[Master Data],\n [Issue Subtype].[OQT],\n [Issue Subtype].[Others],\n [Issue Subtype].[PQT],\n [Issue Subtype].[S\u0026A],\n [Issue Subtype].[Transactional Data]\n})\n”,“format_string”:“”},{“name”:“S/4HANA Report”,“dimension”:“Issue Subtype”,“formula”:"/[Measures].[S/4HANA Report]/\n/[Issue Subtype].[R\u0026A]-[Label].[Exclude EDW \u0026 Regression \u0026 EA]/\n\n[Issue Subtype].[R\u0026A_ABAP]“,“format_string”:”“},{“name”:“S/4HANA Report”,“dimension”:“Measures”,“formula”:”[Issue Subtype].[R\u0026A]-\n([Label].[R\u0026A_EDW]-[Label].[R\u0026A_Regression])“,“format_string”:”“},{“name”:“S/4HANA Report - EA”,“dimension”:“Issue Subtype”,“formula”:”/[Label].[EA]*/\n\n[Issue Subtype].[R\u0026A_EA]”,“format_string”:“”},{“name”:“S/4HANA Total”,“dimension”:“Issue Subtype”,“formula”:“Aggregate(\n\t{\n\t\t[Issue Subtype].[S/4HANA Report],\n [Issue Subtype].[S/4HANA Report - EA],\n [Issue Subtype].[S/4HANA Eco System]\n})”,“format_string”:“”},{“name”:“Config Document”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[CSD]”,“format_string”:“#,##0”},{“name”:“Development Factory”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Development]”,“format_string”:“”},{“name”:“Other Core Developments”,“dimension”:“Work Item type”,“formula”:“[Work Item Type].[Dev Other]”,“format_string”:“”},{“name”:“Development EDW”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Dev EDW]”,“format_string”:“”},{“name”:“Development Integration”,“dimension”:“Work Item type”,“formula”:“[Work Item type].[Dev Int]”,“format_string”:“”},{“name”:“Total Developments “,“dimension”:“Work Item type”,“formula”:“Aggregate({\n[Work Item type].[Development Factory],\n[Work Item type].[Development EDW],\n[Work Item type].[Development Integration],\n[Work Item type].[Other Core Developments]\n})”,“format_string”:””},{“name”:“Status Epic”,“dimension”:“Status”,“formula”:“Aggregate({\n [Status].[Backlog],\n [Status].[Scheduled],\n [Status].[In Design],\n [Status].[In Progress],\n [Status].[In Review],\n [Status].[Ready For Approval],\n [Status].[Ready for PtQ],\n [Status].[Testing],\n [Status].[Ready for PTP],\n [Status].[On Hold],\n [Status].[Completed]\n})”,“format_string”:“”},{“name”:“Commercial”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Commercial],\n[Workstream].[COM-Customer 360],\n[Workstream].[COM-Evidence-to-Value],\n[Workstream].[COM-Lead-to-Quote],\n[Workstream].[COM-Order-to-Release],\n[Workstream].[COM-Quote-to-Contract],\n[Workstream].[COM-Release-to-Invoice],\n[Workstream].[COM-Strategy-to-Demand],\n[Workstream].[DAT-Commercial]\n})”,“format_string”:“”},{“name”:“Finance”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Finance \u0026 Procurement],\n[Workstream].[DAT-Finance \u0026 Controlling],\n[Workstream].[DAT-Customer],\n[Workstream].[FIN-Asset Accounting and Projects],\n[Workstream].[FIN-FC\u0026C (incl. Analytics)],\n[Workstream].[FIN-General Ledger and Period End],\n[Workstream].[FIN-I2C - Invoice 2 Cash],\n[Workstream].[FIN-Operations Finance],\n[Workstream].[FIN-Intercompany],\n[Workstream].[FIN-Revenue Management],\n[Workstream].[FIN-RDF],\n[Workstream].[FIN-Tax],\n[Workstream].[FIN-Treasury and Cash-Management],\n[Workstream].[FINP-Pillar: Finance]\n})”,“format_string”:“”},{“name”:“Procurement”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[DAT-Supplier \u0026 Procurement],\n[Workstream].[PUR-Accounts Payable and Supplier Experience (SLP)],\n[Workstream].[PUR-CE and Transactional Direct Procurement],\n[Workstream].[PUR-CE and Transactional Indirect Procurement and Front door],\n[Workstream].[PUR-Strategic Procurement and S2C],\n[Workstream].[SEP-Supplier Exp - Supplier Information Mgmt],\n[Workstream].[SEP-Supplier Exp- Supplier Data Quality]\n})”,“format_string”:“”},{“name”:“Operations”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Operations],\n[Workstream].[DAT-Material \u0026 Operations],\n[Workstream].[DAT-Product \u0026 Brand],\n[Workstream].[OPS-Manufacturing - Asset Management],\n[Workstream].[OPS-Manufacturing - Manufacturing],\n[Workstream].[OPS-SCM - Demand Planning],\n[Workstream].[OPS-SCM - External Manufacturing],\n[Workstream].[OPS-SCM - Intercompany Order Management / Customs and Trade Compliance],\n[Workstream].[OPS-SCM - Lifecycle Management and Implementation],\n[Workstream].[OPS-SCM - Logistics/Warehousing],\n[Workstream].[OPS-SCM - Production planning],\n[Workstream].[OPS-SCM - Supply Planning],\n[Workstream].[OPS-TRD - Clinical Supply],\n[Workstream].[OPS-TRD - Embedded],\n[Workstream].[OPS-Quality (incl. OBBR)],\n[Workstream].[OPS-DAT - Triggered Project],\n[Workstream].[OPS-SCM - Ariba SCC],\n[Workstream].[MOM - Masters of Material]\n})”,“format_string”:“”},{“name”:“LDC - Workstreams”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[Commercial],\n[Workstream].[Finance],\n[Workstream].[Procurement],\n[Workstream].[Operations],\n[Workstream].[Solutions],\n[Workstream].[DAT-Migration],\n[Workstream].[N/A],\n[Workstream].[Unmatch],\n[Workstream].[(none)]\n})”,“format_string”:“”},{“name”:“Solutions”,“dimension”:“Workstream”,“formula”:“Aggregate({\n[Workstream].[ALX-R\u0026A Integration],\n[Workstream].[DAT-Integration],\n[Workstream].[SOL-BPM],\n[Workstream].[SOL-Build Management],\n[Workstream].[SOL-Data],\n[Workstream].[SOL-Design Management],\n[Workstream].[SOL-Learning],\n[Workstream].[SOL-Platform Management],\n[Workstream].[SOL-Platform Management Basis],\n[Workstream].[SOL-Platform Management Integration],\n[Workstream].[SOL-R\u0026A],\n[Workstream].[SOL-Security \u0026 Authorization],\n[Workstream].[SOL-Solution Core \u0026 Integration],\n[Workstream].[SOL-Solution Methodology],\n[Workstream].[SOL-Technology \u0026 Architecture]\n})”,“format_string”:“”},{“name”:“Configuration Activities “,“dimension”:“Work Item type”,“formula”:”[Work Item type].[Config]”,“format_string”:“”},{“name”:“EDW”,“dimension”:“Issue Subtype”,“formula”:“Aggregate(\n\t{\n\t\t[Issue Subtype].[R\u0026A_EDW],\n [Issue Subtype].[R\u0026A_Regression],\n [Issue Subtype].[R\u0026A_PaPM],\n [Issue Subtype].[R\u0026A_Rollout]\n})”,“format_string”:“”}]
}