Question Re: SAP Analytics Cloud - Formula Error in Technology Q&A

SAP Analytics Cloud - Formula Error

Max_Ribeiro — Wed, 06 Feb 2019 12:07:39 GMT

I'm trying to create a simple calculated dimension using a substring, but I receive the message:

"Formula could not be computed: Choose a property for dimension "COMPONENT" in function "SUBSTRING". Try rewriting the formula."

What am I missing here?

Re: SAP Analytics Cloud - Formula Error

Former Member — Wed, 06 Feb 2019 14:06:56 GMT

In your fomula - after the dimension you need to select either id or decription

try and add a "." after and the press ctrl + space

René

Re: SAP Analytics Cloud - Formula Error

Max_Ribeiro — Thu, 07 Feb 2019 17:14:11 GMT

Thank you so much, René!

Re: SAP Analytics Cloud - Formula Error

mohammedkhajamohiuddin — Mon, 14 Feb 2022 06:42:08 GMT

Rene is right.

Below is the descriptive answer for the issue. After Dimension put a dot and then ctrl+space. You will get a intellicense select from that (ID or Desc) issue will be resolved.

SUBSTRING([d/"ZCV":_CPB_ZE8YY1].[p/_CPB_ZE8YY1],5 ,2 )