Skip to Content

Expression in Where Condition

Hi,

Could you please help with the issue while iam trying to validate the expression in the where condition, iam getting below two errors:

1) length @Select(Dim\Fiscal Period\Fiscal Month)=1




2) Case

when

length @Select(Dim\Fiscal Period\Fiscal Month)=1

then

'00'||(@Select(Dim\Fiscal Period\Fiscal Month))||'.'||@Select(Dim\Fiscal Period\Fiscal Year)

else

'0'||(@Select(Dim\Fiscal Period\Fiscal Month))||'.'||@Select(Dim\Fiscal Period\Fiscal Year)

End

Thanks,

Dinya.

Capture.JPG (18.9 kB)
Capture.JPG (19.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 14, 2015 at 04:08 PM

    Hi,

    try with this.also check if Fiscal Month  object is parsing or not.

    length(@Select(Dim\Fiscal Period\Fiscal Month))=1


    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      try with below steps.

      1)Create Month Object with data type String.with below syntax I am checking the  length and adding 00 in the month part.

      ifelse(length(convert(@catalog('DMFIXMAM')."PUBLIC"."IDMFIXMAM"."Month",Varchar))=1,

      concat('00',convert(@catalog('DMFIXMAM')."PUBLIC"."IDMFIXMAM"."Month",Varchar)),

      concat('0',convert(@catalog('DMFIXMAM')."PUBLIC"."IDMFIXMAM"."Month",Varchar)))

      2) Create Year object with data type string. concatenating . and year.

      concat('.',convert(@catalog('DMFIXMAM')."PUBLIC"."IDMFIXMAM"."Year",varchar))

      3) Create Month/Year object based on the objects above created.

      concat(@Select(IX Monthly\Month),@Select(IX Monthly\Year))

      4) check the values.

      5) right click and create filter.Select the filter type "Business" and create the filter.Drag Month/Year objects and select as a prompt.

      6) Final filter with Month  and year.

      Amit

      1.png (23.3 kB)
      2.png (20.0 kB)
      3.png (17.1 kB)
      4.png (3.7 kB)
      5.png (15.7 kB)
      6.png (8.1 kB)