Building Noetix Search instance on Linux / Solaris platform

This post if for people using Noetix Search on a Linux or Solaris platform. Installation guide supplied with the tool only has steps to install Noetix search on Linux not how to build a search instance for a databse.

Here is a quick guide we got from Noetix

On a computer running Linux or Solaris, at the command prompt, locate the folder where Noetix Search Builder is installed (/usr/local/noetixsearch/builder, by default). Type run.sh --action . Use the table below to view the syntax and description for the action, input, and flag that you provide in the command.



NOTE: If you have set any or all of the above flag inputs in the Noetix.Search.Builder.properties file, you do not need to specify them again while running a command. The command will automatically take the settings that you make in the Noetix.Search.Builder.properties file. Moreover, setting the Solr URL as default in this file will keep you from having to specify it every time you run a command.

Examples: The following are some examples that may help you understand the task of running commands and providing inputs better.

To build a new instance:
run.sh --action build --alias NoetixViews Prod -u noetix_sys -p pw -s http://localhost:80/solr/ --tns ohs

Where the value for action is "build", for alias is "NoetixViews Prod", for username is " noetix_sys", for password is " pw", for Solr URL is "http://localhost:80/solr/", and for TNS name is "ohs"

To rebuild an existing instance:
run.sh --action rebuild --alias NoetixViews Prod -s http://localhost:80/solr/ -p pw

Where the value for action is "rebuild", for alias is "NoetixViews Prod", for Solr URL is "http:// localhost:80/ solr/", and for password is " pw"

To delete an instance:
run.sh --action delete --alias NoetixViews Prod -s http://localhost:80/solr/

Where the value for action is "delete", for alias is "NoetixViews Prod", for Solr URL is "http://localhost:80/solr/"

All Modules not geeting installed

Hello,
Last friday, my colegues came with a problem. They got a new Noetix build 6.0 but when they try to install Global Views, only Inventory Global views are getting installed. They were trying to install 6.0 in an existing Noetix_sys, where 5.7 version views are installed. We cannot upgrade to 6.0. It is totally a new platform, so we created a new schema but still only Inventory Global views got installed. When we checked the datfiles.ini, we found out that only Inventory global views were enabled (in my previous post, i have mentioned how to validate, what we have purchased)
Define dat_global_modules = 'INV'
What if you dont have access to datfiles.ini? This information is also stored in a table in Noetix_Sys schema.
Select application_label, global_instance_enabled from n_application_owner_templates where base_application = 'Y'

If the application has global_instance_enabled as 'Y' then atleast your noetix package has global views.

Configure Language settings of choice for NoetixViews to return data in OBIEE.

Oracle EBS multi-lingual capability for the data stored, by storing the translations in special _TL tables. For example, Part description in multiple language is stored in MTL_SYSTEM_ITEMS_B_TL one row for each translation. Noetix views invlude these tables in there definition to provide multi-lingual translations for the reporting. All noetix views (where translation tables are used), use "language" environment variable to identify the language in which the data is requested. When querying through OBIEE, you can choose the language in which noetix views should return data. Under "My Accounts" in OBIEE, users have capability to select there locale language and this language value is stores in a predefined OBIEE session variable VALUEOF(NQ_SESSION.WEBLANGUAGE). Following are the changed need to be done, to map obiee session value to database language. So that Noetix views return the data in the appropriate language. Following are the steps to be performed

a. Open the RPD of your choice.

b. In the physical layer, open the connection pool properties for the noetix views

c. In the Execute Before Query Tab, place the following code
Declare
lang_name = varchar2(30);
BEGIN
Select DECODE('VALUEOF(NQ_SESSION.WEBLANGUAGE)','no','NORWEGIAN','es','SPANISH','ENGLISH') INTO LANG_NAME FROM DUAL;

EXECUTE IMMEDIATE 'alter session set NLS_LANGUAGE = ' lang_name;
END;

d. Save the rpd.

Now when the user changes its locale to Spain, the weblanguage session variable will be populated with es code and an alter session command will be executed before each query execution. This way, correct language filter will be applied to the noetix views and the data will be displayed as per the user's preffered language.

Noetix OBIEE Dashboard dont have default dwonload / modify / print option

Noetix OBIEE dashboard one generated using Noetix OBIEE generator, dosent have default report links (download , print, modify etc...). This limits user ability to download the reports from the dashboard.
Noetix has identified it as a enhancement request and have recently released a patch (patch_9_25175) for the same. This patch can be requested by raising a incident to noetix suport.

How to validate Noetix Purchase

As noetix product cost is based on the modules for which you have purchased the views and what is installed is totally based on EBS setup. It is very important that you can found out what was supplied to you in the software package and what got installed.

In order to know what your noetix software package has, you need to find the datfiles.ini file. This file can be located under "NvAdm\Master\Datfiles\".

Above is a screenshot of the sample content in datfiles.ini.

a. dat_version - This is the version of your noetix build. This version is specific to the build based on the modules purchased and available in the package.

b. dat_noetix_product_version - This is the version of the base Noetix product.

c. dat_answers - This flag is set to Yes, if you have purchased out of the box reports, which is called answers by Noetix

d. dat_modules - These are the modules for which the views are provided as part of the package.

Noetix 6.0

Noetix 6.0 for Oracle EBS is the latest release from Noetix. This is a next generation operational reporting tool from noetix with all new global views for all the Oracle EBS modules -
a. Oracle Financials
b. Supply Chain
c. Discrete Manufacturing
d. Projects
e. Enterprise Asset management
and joining with previously released global views for HRMS.

What makes Noetix 6.0 so diferent
a. Global Views
Noetix solution before 6.0 use to provide one view for each operating unit, organization and ledger. So if you have multiple setups then you can imagine the number of views created and have to create multiple reports for each setup. In 6.0 with global views, a view with deliver data for all business groups, operating unit, organization and ledgers. This reduces the views considerably based on your EBS setup to provide enterprise wide reporting solution

b. Row Level Security
Row level security feature of Noetix global views ensures that the information viewed by EBS users will be consistent with their data access privilleges in EBS. This feature is integrated with OBIEE, Cognos and BO

Soon after after releasing 6.0, Noetix has released another version 6.0.1, which is more flexible and provides option to either install standard views or global views.