Cannot Build Trellis View From Essbase Source

Matt W

Hi - I am attempting to build an analysis using an Essbase data source. With the same source/columns/filters in the edit analysis pane, I am able to create a table and a graph view with no issues. However I am unable to create a trellis view. I have a simple 3 column analysis. Year, Market, Service Request (measure: Count of service requests).

I have stripped all but the essential columns/filters out of the data and we're still getting the issue. It's pretty frustrating, to be honest.

Using the exact same cube and columns, I can create a trellis view with the Visual Analyzer tool without issue.

Is there a reason OBIEE Answers/Dashboards behaves differently with the same source compared to VA?

Platform: OBIEE Business Suite Edition

OBIEE Version number 12.2.1.3.0

Browser: Chrome (latest update)

Below are the error messages I am receiving:

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed:

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 96002. [nQSError: 96002]

Please have your System Administrator look at the log for more details on this error. (HY000)

SQL Issued: SELECT 0 s_0, "BI_SRVC Cube"."Geography"."Market" s_1, "BI_SRVC Cube"."Period"."Year" s_2, SORTKEY("BI_SRVC Cube"."Geography"."Market") s_3, SORTKEY("BI_SRVC Cube"."Period"."Year") s_4, "BI_SRVC Cube"."Accounts"."Requests" s_5, REPORT_AGGREGATE("BI_SRVC Cube"."Accounts"."Requests" BY "BI_SRVC Cube"."Geography"."Market") s_6 FROM "BI_SRVC Cube" FETCH FIRST 100000001 ROWS ONLY

Robert Angel

Not sure if this applies to your version of OBIEE, but worth a try; -

Workaround:

1) Edit an analysis on which the error is encountered.

2) Go to the advanced tab and on the Prefix section add:

    SET VARIABLE FILTER_METRIC_SPLITTING_LEVEL=1,DISABLE_PLAN_CACHE_HIT=1;

3) Apply the SQL.

4) Save the analysis

5) Rerun the analysis.