5 Replies Latest reply on Jun 25, 2013 12:31 PM by metalray

    Column expression nQSError 22032

    metalray

      Hi Guys,

      I think I am close to pre-filtering my column by getting rid of all the offices that the user does not belong to.

      I created a logical mapping table in the repository. The table works in OBI Answers. Now I need to set the Dashboard prompt

      column expression right, but that did not work with the below filter. Is it really feasible?

       

      Dashboard prompts:
      New column prompt - >
      Column expression editor ->

      FILTER("dim_user_office"."usr_off_prompt_col" USING ("dim_user_office"."username" =
      valueof(nq_session."user")))
      nQSError 22032

        • 1. Re: Column expression nQSError 22032
          Sasi  Nagireddy

          Which Version you are using?

          1 person found this helpful
          • 2. Re: Column expression nQSError 22032
            metalray

            OBIEE 11.1.1.6.6

            • 3. Re: Column expression nQSError 22032
              metalray

              --does not work, no results load into the prompt dropdownlist--

              SELECT "USER_TABLE"."OFFICENAME", "USER_TABLE"."OFFICEKEY","USER_TABLE"."USERNAME"

              FROM "Repository_datasource"

              WHERE "USER_TABLE"."OFFICENAME" IS NOT NULL AND "USER_TABLE"."USERNAME" =  'login8712'

              ORDER BY "USER_TABLE"."OFFICEKEY"

               

              --does not work, no results load into the prompt dropdownlist--

              SELECT "USER_TABLE"."OFFICENAME", "USER_TABLE"."OFFICEKEY"

              FROM "Repository_datasource"

              WHERE "USER_TABLE"."OFFICENAME" IS NOT NULL AND "USER_TABLE"."USERNAME" = @{biServer.variables['NQ_SESSION.USER']}

              ORDER BY "USER_TABLE"."OFFICEKEY"

               

              --below works, but its not sufficient, I need the username in there--

              SELECT "USER_TABLE"."OFFICENAME", "USER_TABLE"."OFFICEKEY"

              FROM "Repository_datasource"

              WHERE "USER_TABLE"."OFFICENAME" IS NOT NULL AND "USER_TABLE"."OFFICEKEY" = 2600 ORDER BY "USER_TABLE"."OFFICEKEY"

              ---

              • 4. Re: Column expression nQSError 22032
                Christian Berg

                Very simple:

                Formula syntax is invalid.

                [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 22032] Function FILTER requires at least one measure column in its first argument. (HY000)


                And you said:

                metalray wrote:

                [snip...]

                FILTER("dim_user_office"."usr_off_prompt_col" USING ("dim_user_office"."username" =
                valueof(nq_session."user")))
                nQSError 22032

                 

                "dim_user_office"."usr_off_prompt_col" != measure. FILTER isn't what you're looking for to achieve this!

                1 person found this helpful
                • 5. Re: Column expression nQSError 22032
                  metalray

                  I found a way to achieve it! I created an Oracle DB mapping view for now, containing both columns and filtering with username=valueof(nq_session."user")