Blocking Analyses Based on Criteria in OBIEE 12.2.1.2.0

Ramamohan Reddy

Hi All,

How to implement Blocking Analyses Based on Criteria in OBIEE 12.2.1.2.0.

Requirement: Basically users are not applying mandatory filters in obiee as a result query's running a long time and users are saying obiee slow.

We need to display pop up window message when users not applying mandatory filter.

Ex: Custom message: Please apply mandatory filters on column "Year" from folder "Time".

Thanks in advance

Gianni Ceresa

This topic has already been covered many times.

If your analysis in a dashboard page, make your prompt mandatory and set predefined values by default (either static or using variables). Or in the dashboard properties check the "Prompt before opening".

If you just want to use the analysis standalone (no page) add your prompts as inline prompts in the analysis and in that way when opening the analysis the prompt is what you see as the first thing.

[Deleted User]

a) No, you won't get a pop-up. OBI doesn't work that way. Use what the tool gives you.

b) https://lmgtfy.com/?q=obiee+mandatory+prompt

First hit:

https://www.rittmanmead.com/blog/2014/03/obiee-dashboard-prompt-at-least-one-mandatory/

[Deleted User]

Or what Gianni said. Beaten by one minute.

Ramamohan Reddy

Hi All,

I need to implement chapter 17.6 from this doc.

https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#i1016030

Tried below points. no luck

1.  C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\web\msgdb\messages\answerstemplates.xml

changes file From

"<script type="text/javascript">function validateAnalysisCriteria(analysisXml) {return true; // by default, no checking is done}</script>"

with

"<script type="text/javascript" src="fmap:myblocking.js" />"

2. Created AnalyticsRes folder ( C:\Oracle\analyticsRes\res).

   And placed myblocking.js file into folder (C:\Oracle\analyticsRes\res\myblocking.js)

  

3. Added below tag instanceconfig.xml

    C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\config\fmwconfig\biconfig\OBIPS\instanceconfig.xml

<URL>

<CustomerResourcePhysicalPath>c:\Oracle\analyticsRes\res</CustomerResourcePhysicalPath>

<CustomerResourceVirtualPath>/analyticsRes/res</CustomerResourceVirtualPath>

</URL>

4. Unable to deploy AnalyticsRes via console. Attached error screenshot.

Request you to please suggest on the same.

Ramamohan Reddy

[Deleted User]

If you have an issue with some JS code in the Oracle documentation, I suggest you open a Service Request and see with the people who wrote that code.

We're suggesting you use standard functionality. Not code. Your choice.

Ramamohan Reddy

Hi Berg,

Thanks for your reply.

I followed below link.But unable to deploy analyticsRes via console. Kindly suggest me on the same.

[Deleted User]

If you want to use JS and not standard configuration you can pester @Gianni Ceresa

For me that's a clear and definitive "No".

Gianni Ceresa

Deploying "analyticsRes" is pretty simple once you follow all the steps: https://gianniceresa.com/2016/12/deploy-custom-folder-obiee-12c-analyticsres/

Gianni Ceresa

You are following a way which isn't the natural way to achieve what you have in mind.

If the JS thing was the standard way to prevent an analysis from executing because of missing filters, it wouldn't be described in the "System Administrator's Guide" but in a document read by most users (not just sys admins).

You are over complicating things a lot...

But you have the doc, follow it and done.