This discussion is archived
5 Replies Latest reply: Feb 17, 2013 10:55 PM by sayak RSS

[nQSError: 46036] Internal Assertion: Condition pLeftOperand in obiee 11g

sayak Explorer
Currently Being Moderated
Hi ,

I am trying to display text data from Essbase Cube in OBIEE report , had one thread already opened for this :

Displaying text data from Essbase Cube in OBIEE report

I'm approaching in the following way :

1. Created one session initialization block "TEXT_ID_VALUE" , having below query :

select TEXT_ID, VALUE from HSP_TEXT_CELL_VALUE ;

2. Matching the data populating in "TEXT_ID"(numeric data) session variable, with one of my measure column and fetching the corresponding "VALUE" session variable (text data) . (both the session variable's belong to TEXT_ID_VALUE initialization block , with 'row wise initialization' )

3. Wrote below expression in measure column(in BMM layer) :

CASE WHEN  "CAPEX_inteliplan"."CAPEX"."Capex Description" = VALUEOF(NQ_SESSION.TEXT_ID)  THEN  VALUEOF(NQ_SESSION.VALUE)  END

Its throwing this error message :

*[nQSError: 46036] Internal Assertion: Condition pLeftOperand, file server\Query\Optimizer\Request\Src\SQORRqExprCond.cpp, line 158.*

Am I missing anything / is it the correct way to do it?

Legend

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