Thank you, Chris. I took a look at the sample formulas in the What's New model for 2020.4, and this is exactly what I was looking for. Great job on getting this done! I will definitely make good use of this. I don't care about the Rule Editor UI coming later, since I generally don't need that anyway. The only thing missing now is to add some more statistical cube rule functions to take better advantage of this powerful new calculation capability against granular data values from custom cube slices. Two obvious cube functions to add would be standard deviation and variance, which would be powerful in highlighting outliers on reports and dashboards. Not all of these would be applicable to cube functions, but here are some more from Excel, which I included in my link below: https://support.microsoft.com/en-us/office/statistical-functions-reference-624dac86-a375-4435-bc25-76d659719ffd?ui=en-us&rs=en-us&ad=us
Hello, this is exactly how subset in Rules work. The Subset returns a list of elements for a specific array of cells, which enables you to use MIN,MAX,COUNT, AVERAGE, MEDIAN and other array like rules functions against the returned data cells. There has been an update on the knowledgebase on using this syntax in rules here: https://knowledgebase.jedox.com/jedox/in-memory-db/rules-overview.htm?Highlight=subsets%20in%20rules There will be more updates coming to the knowledgebase in relation to this topic. Please also download the what's new model for 2020.4 from the partner portal for comprehensive examples of how this functionality works. If you do not have access to this , please let me know and I can send you a copy. The Subset in Rules functionality is not yet supported by the Rules wizard UI (it will be coming in a 2021 release), but you can manually paste in the syntax and it will work.
I see in the 2020.3 and 2020.4 release notes that something like this was released, but see no indication of where this functionality is in the Rule Editor Expressions list or in the Knowledge Base ("Supported Functions in Rules" page, which was last updated in July 2020). To make this work with statistical functions, you actually need a subset of values, not just a subset of elements, as I explained in my related idea that I submitted about 8 months ago: https://feedback.jedox.com/ideas/JS-I-643.
Thank you, Chris. I took a look at the sample formulas in the What's New model for 2020.4, and this is exactly what I was looking for. Great job on getting this done! I will definitely make good use of this. I don't care about the Rule Editor UI coming later, since I generally don't need that anyway. The only thing missing now is to add some more statistical cube rule functions to take better advantage of this powerful new calculation capability against granular data values from custom cube slices. Two obvious cube functions to add would be standard deviation and variance, which would be powerful in highlighting outliers on reports and dashboards. Not all of these would be applicable to cube functions, but here are some more from Excel, which I included in my link below:
https://support.microsoft.com/en-us/office/statistical-functions-reference-624dac86-a375-4435-bc25-76d659719ffd?ui=en-us&rs=en-us&ad=us
Hello, this is exactly how subset in Rules work. The Subset returns a list of elements for a specific array of cells, which enables you to use MIN,MAX,COUNT, AVERAGE, MEDIAN and other array like rules functions against the returned data cells. There has been an update on the knowledgebase on using this syntax in rules here: https://knowledgebase.jedox.com/jedox/in-memory-db/rules-overview.htm?Highlight=subsets%20in%20rules There will be more updates coming to the knowledgebase in relation to this topic. Please also download the what's new model for 2020.4 from the partner portal for comprehensive examples of how this functionality works. If you do not have access to this , please let me know and I can send you a copy. The Subset in Rules functionality is not yet supported by the Rules wizard UI (it will be coming in a 2021 release), but you can manually paste in the syntax and it will work.
I see in the 2020.3 and 2020.4 release notes that something like this was released, but see no indication of where this functionality is in the Rule Editor Expressions list or in the Knowledge Base ("Supported Functions in Rules" page, which was last updated in July 2020). To make this work with statistical functions, you actually need a subset of values, not just a subset of elements, as I explained in my related idea that I submitted about 8 months ago: https://feedback.jedox.com/ideas/JS-I-643.
We are working on an extension of the rule engine, tha will allow running certain functions over a subset of elements.