This discussion is archived
2 Replies Latest reply: Mar 21, 2013 6:41 AM by 945333 RSS

Query Failed: [nQSError: 22048]

842659 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points