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