0 Replies Latest reply: Jan 24, 2013 3:13 AM by Alex1 RSS

    Jump between different subject areas


      My situation is (obiee

      I have two subject areas (exactly equals).

      I have a prompt (pv called area) with name of subject areas: Subject area1 / Subject area2

      I have an analysis created with Subject area1 and I modify advanced tab and I type pv in xml code instead of Subject area1. Now if I choose subject area 1 or subject area 2 in my prompt I see different results in my analysis, so it's good for me.

      I need to work using hierarchycal columns and I have an error:

      State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 34030] A subject area corresponding to the business model has at least one column that does not originate from this business model. For more information, please check global consistency. (HY000)

      From my analysis if I change manually this line of code:
      <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;*Subject Area1*&quot;" withinHierarchy="true">
      <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;*Subject Area2*&quot;" withinHierarchy="true">

      I see good results on results tab without any error.

      So I need to get some kind of pv in this code...

      Any help??