Skip to Content
avatar image
Former Member

Unresolved reference: @where (QTJ 00519)

Hi,

I am receiving above error when validating below expn

=IIf(@Select(Fact Area\Business Quarter)=4,

fact_area.measure @Where(fact_area.year=2010 and fact_area.quarter=@Select(Fact Area\Business Quarter)))

or

=IIf(@Select(Fact Area\Business Quarter)=4,

fact_area.measure @Where((Fact Area\year=2010 and(Fact Area\Quarter=@Select(Fact Area\Business Quarter)))

There reason iam using @where in Select statement is i want use multiple where statement for MAT calculation

can't use runningsum() because this should be only column in the table.

Thanks,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 05, 2015 at 04:25 PM

    The @Where is expecting only an object.  It appears you are adding in parameters that it does not like.

    It expects:  @Where(classname\objectname)

    but you are putting in @Where((Fact Area\year=2010 and ...

    You could try using @Where(Fact Area\year)=2010 but I still don't understand what you are trying to accomplish here.

    The @Where is used to reuse the Where clause of another object.  So setting it = to 2010 doesn't really make sense.

    Either way, I think you need to check your syntax on the usage here.  The Universe design guide talks about the @Where in section 7.3.7. - http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp5_universe_design_tool_en.pdf

    Thanks

    Jb

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      thank you for replying.

      I want use multiple where function with iif function, in IDT there is separte window for using where function, it does not all to use inside Sql statement window. Which was possible in UDT. So iam trying to replace where function with @where function.

      I hope it makes sense.

      Thank you.