Blocking Analyses Based on Criteria in OBIEE 12.2.1.2.0

Ramamohan Reddy · Apr 5, 2020 5:35AM

Hi Ceresa,

Thanks for your support.

I have tried blocking analyses in answers in OBIEE 12.2.1.2 as per oracle doc. No luck

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

I created folder analyticsRes in C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi\bidata\components\OBIPS\analyticsRes, placed these two files into this folder and restarted all services.

No success

Files:

answerstemplates.xml

myblocking.js

1. answerstemplates.xml

<?xml version="1.0" encoding="utf-8"?>

<HTML>

</HTML>

</WebMessage>

</WebMessageTable>

</WebMessageTables>

2. myblocking.js

function validateAnalysisCriteria(analysisXml)

{

var tValidator = new CriteriaValidator(analysisXml);

if (tValidator.getSubjectArea() != "Sample Sales Lite")

{

//*****************************************************************************//

// IF any attribute from the below listed folders of Subject area "Sample Sales Lite" are selected //

// filter on columns: Per Name Year,Per Name Half //

//******************************************************************************//

if (tValidator.tableExists("Base Facts")

|| tValidator.tableExists("Calculated Facts")

)

{

if ( ( !tValidator.filterExists("Time.Per Name Year"))

|| (!tValidator.filterExists("Time.Per Name Half"))

)

return "Please apply filter on columns \"Per Name Year"\,\"Per Name Half"\ from folder \"Time\" ";

}

return true;

}

Request you to please suggest on the same.

Thanks in advance.

[Deleted User] · Apr 5, 2020 9:37AM

It's not worth sending people direct messages when they explicitly counsel you to do something else than what you're doing.

Why do you insist on JS if you can't make it work?

MFA for Oracle Community

Oracle Analytics Cloud and Server

Categories

Blocking Analyses Based on Criteria in OBIEE 12.2.1.2.0

Answers