Restrict numeric value

[former_member205064]

Hi

I have a dimension which return 6 digit value from DB, i want to restrict to 4 digit in IDT.

It should restrict to :-

Is it possible to restrict at IDT level by creating any variable.

[amitrathi239 · Accepted solution]

Hi,

Create another object.Use substring function to extract four digit.

substring(@Select(Class\Object Name),1,4)

Amit