2 Replies Latest reply: Mar 21, 2013 8:41 AM by gaurav.singla RSS

    Query Failed: [nQSError: 22048]

    user9329331
      Hello All,

      I can find no reference to... "Query Failed: [nQSError: 22048] To use Time Series function in this query you must project 'Dim - Calendar Time.Calendar Date' column. (HY000)". This analysis works fine in my 10g environment, yet fails in my 11g world.

      It seems to be related to the "- Total POS Units Time Series"."Year Ago Total POS Net Units" fields in one column.

      Column Name : Total Market Y^Y Change

      With this column formula

      ((("Total POS"."Total POS Net Units"-"- Total POS Units Time Series"."Year Ago Total POS Net Units")*1.00)/("- Total POS Units Time Series"."Year Ago Total POS Net Units")*1.00)*100

      I eliminated each column and found this one to be the problem child.

      If I create a brand new analysis with "- Total POS Units Time Series"."Year Ago Total POS Net Units" it seems to bring back the correct results and I do not see the 22048 message.

      Any help would be most welcome.

      Best Regards,
      Joe