1 Reply Latest reply on Feb 21, 2013 4:16 PM by Sasi Nagireddy

    Problem on a table with hierarchy prompt

      Hi experts,

      I have an unusual error when I'm using hierarchy prompt.
      I make an analysis that it has two hierarchycal columns (One of this is to show on rows of my table, another is to get filter when I choose options with hierarchycal dashboard prompt)
      My table looks like this:


      If I drill down by Level1.1, it's drilldown fine and it shows childs of Level1.1, now comes my issue... With Level1.1 Opened (seeing childs of level 1.1), if I click to drilldown level1.2 I have an error:

      Odbc driver returned an error (SQLExecDirectW).
      Error Details
      Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 96002] Essbase Error: Syntax error in input MDX query on line 8 at token 'filter' (HY000)

      So...My problem exists when I want to drilldown with diferent ways.

      If I delete hierarchycal column that is prompted in my dashboard...I can drill down perfectly... but I can't to delete this hierarchycal column because my customer needs that hierarchycal prompt.

      Anybody can help me???