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.