This discussion is archived
1 Reply Latest reply: Feb 21, 2013 8:16 AM by Sasi Nagireddy RSS

Problem on a table with hierarchy prompt

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

+Level1
...+Level1.1
...+Level1.2
+Level2
...+Level2.1
etc.

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???

Thanks!

Legend

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