Skip to Content
0
Feb 02, 2023 at 12:07 PM

Intended behaviour of Measure-Based Dimensions in analytic applications

118 Views Last edit Feb 03, 2023 at 07:06 AM 2 rev

Hi Experts,

I am currently working on a project where I want to use a measure-based dimension to show the status of a task.

The idea is to use a planning model where by changing the value of a measure for a given row, the text changes for the Measure-Based Dimension.

But I have come across an odd behaviour here, where I cannot change the value of the measure by script, when the Measure-Based Dimension is displayed in the table. I simply get an error saying:

image.png

The measure is also greyed out when I add the Measure-Based Dimension to the table and cannot be edited in runtime. The above message is displayed when I try to change it via a button, a hardcoded example can be seen below:

	var sel2 = {Version: 'public.Actual', <br>				'@MeasureDimension': '[Account].[parentId].&[Indicator]',<br>				'51279973-6382-4988-8250-223147599046': 'Request new forecast', //this is the Measure-Based Dimension<br>				Project_ID: '1', <br>				Project_Name: 'Project A', <br>				Plandate: '2000-01-01', <br>				Status: 'None', <br>				User: 'System'};<br>	var planning = Table_1.getPlanning();<br>	var val = "2";<br>	planning.setUserInput(sel2, val);<br>	planning.submitData();
If I remove the Measure-Based Dimension, the change can be done without issue (or if done to a seperate table with the same datasource).I have also tried expanding the script with a removedimension step before the above is executed and an adddimensiontorows step after.

However this led me to another curious observation, that I cannot add the Measure-Based Dimension to the table via scripting, I can however remove it. A workaround I did discover was to add a Calculated Dimension which refers to the Measure-Based Dimension. It will however not update directly, but if the remove/add operation is performed, as described above it will. I have not been able to find anything in the developer handbook regarding Measure-Based Dimensions, but I do not think this is the intended behaviour, or have I missed something?

Kind regards,

Rasmus

Attachments

image.png (9.5 kB)