Forum Stats

  • 3,851,459 Users
  • 2,263,981 Discussions
  • 7,904,718 Comments

Discussions

Filter Metric Splitting (OBIEE and MDX)

Does anyone have any information on when/why the BI server in OBIEE 12.2.1.3.0 will not split filter metrics against Essbase?

EXAMPLE: FILTER(measure USING Account = cash)

I have 20 filter metrics in my analysis.  When I run the analysis the BI server splits the MDX in to multiple queries (which is the desired effect).  If I add one more filter metric (now 21) the BI server only sends 1 query to Essbase (NOT desired effect).

I have tried the following at the analysis level on the advanced tab with no luck.

OBIS_FILTER_METRIC_SPLITTING_LEVEL=0

OBIS_FILTER_METRIC_SPLITTING_LEVEL=1

OBIS_FILTER_METRIC_SPLITTING_LEVEL=2

OBIS_FILTER_METRIC_SPLITTING_LEVEL=3

FILTER_METRIC_SPLITTING_LEVEL=0

FILTER_METRIC_SPLITTING_LEVEL=1

FILTER_METRIC_SPLITTING_LEVEL=2

FILTER_METRIC_SPLITTING_LEVEL=3

Tagged:
This discussion has been closed.