topic Calculated dimensions in Management & Governance

Calculated dimensions

excelimpact_com — Sat, 16 Nov 2024 10:12:23 GMT

I am trying to create a calculated dimension from an excel file. The MetricFormula is as follows:

IF("Field Name"='My value', 1, 0)

The issue I'm facing is that once imported it says:

[IF("Field Name"='My value', 1, 0)] which is interpreted as a field name, rather than an expression. Any ideas how I can fix this problem?

Re: Calculated dimensions

sunny_talwar — Tue, 13 Dec 2016 23:44:57 GMT

May be add AS FieldName

IF("Field Name"='My value', 1, 0) as NewFieldName

Re: Calculated dimensions

sunny_talwar — Tue, 13 Dec 2016 23:56:39 GMT

I think you are doing this in the script. Would you be able to share a screenshot of the issue?

Re: Calculated dimensions

excelimpact_com — Thu, 15 Dec 2016 01:51:41 GMT

No Sunny, I'm using the Governed Metrics to put the formula as described above in an Excel File, and them I'm importing them using the Governed Metrics extension; however, when I import the formula, the brackets appear around the formula.

Re: Calculated dimensions

Fri, 16 Dec 2016 12:44:05 GMT

Rodolfo, I have a feeling this may be a current limitation in GMS. When I coded dimensions I think I'm populating field list only and not allowing for calculated dimensions which would stick the formula somewhere else in the definition.

I recommend opening an issue on Github here: Issues · eapowertools/GovernedMetricsService · GitHub

and I'll add it to the list of addressables. Expect an update of GMS in mid to end of January.

Jeff G

Re: Calculated dimensions

excelimpact_com — Fri, 16 Dec 2016 15:37:40 GMT

Issue created. Thanks Jeff.