DAC Encryption key Change

Today we will discuss how to create a new Encryption key for DAC repository. Sometime we used to get an error while trying to start/stop the DAC server. Error description will be like  “Encryption key in authentication file doesn't match the repository. Please use the correct authentication file to connect.”

 To change the DAC encryption key

1.       In the DAC Client, on the Tools menu, select DAC Repository Management, and then select Change Encryption Key.

 

2.       Click Generate Random Encryption Key to generate an encryption key. The key is displayed in the Key field. Alternatively, you can enter a key in the Key field. The key must be at least 24 characters long.

 

3.       Distribute the updated authentication file (cwallet.sso) to all users that connect to this repository.

 

Enjoy & Stay Well !! :)

 

 

 

OBIEE 11G – Error in Importing Metadata :“The connection has failed”

If you get the error “The connection has failed” when you try to Import Metadata into the RPD, this post may help you to resolve it. There could be n number of reason behind this, but this is of the solution.

We need to create an Environment Variable called NLS_LANG.

Follow this procedure to set the NLS_LANG environment variable for Oracle databases.

To set the NLS_LANG environment variable for Oracle databases

1. Determine the NLS_LANG value.
   1. In the data warehouse database, run the command
   SELECT * FROM V$NLS_PARAMETERS
   2. Make a note of the NLS_LANG value, which is in the format [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
      For example: American_America.UTF8

 

      2. For Windows:

1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
2. In System variables section, click New.
3. In the Variable Name field, enter NLS_LANG.
4. In the Variable Value field, enter the NLS_LANG value that was returned in Step 1.
   The format for the NLS_LANG value should be [NLS_LANGUAGE]_[NLS_TERRITORY].[NLS_CHARACTERSET].
   For example: American_America.UTF8.

 

    3. For UNIX, set the variable as shown below:

setenv NLS_LANG <NLS_LANG>

For example: setenv NLS_LANG American_America.UTF8.

If your data is 7-bit or 8-bit ASCII and the Informatica Server is running on UNIX, then set

NLS_LANG <NLS_LANGUAGE>_<NLS_TERRITORY>.WE8ISO8859P1

CAUTION:  Make sure you set the NLS_LANG variable correctly, as stated in this procedure, or your data will not display correctly

 

 

    4. Reboot the machine after creating the variable.

 

 

Enjoy and Stay Well !! :)

Useful URL/Blogs for OBIA/OBIEE

.............................Some useful URL/Blogs for OBIA/OBIEE........................


1. Customizing ETL Mappings for Oracle BI Applications

2. Analyzing BI Apps ETL Runs using OBIEE and the DAC Repository

3. Setting Up Usage Tracking in Oracle BI 11g

4. OBI Applications Data Model Reference

5. Windows Informatica Repository Backup Automation

6. Resetting BISytemUser password in OBIEE 11g

7. DAC Issue and Solution

8. Refreshing Presentation Catalog GUIDs

9. OBIA Soft Delete


Enjoy and Stay Well !! :)

OBIEE 11g Error - NQSError: 13015

 We have created dashboard prompt where we are using session variable. And when we were trying to change the value for the dashboard prompt in different user, got the below error:

   nqserror: 13015 you do not have the permission to set the value of the variable report_currency'

This error will come if the "Enable any user to set the  value" is not checked in session variable.

Open RPD and the particular session variable. And checked the mentioned option.

 

I hope it will solve this issue. Enjoy and Stay well!!.

 

OBIEE - Sub Folder Creation

Sometimes its required to create a parent folder  and some sub folder under a subject area .

Suppose, we need to create a folder as like below:

 

 

Open RPD , go to presentation layer to specific subject area.  Here our parent folder is Project Details and under that we will be having sub folder like Cost Center, Project, etc.

First , you need to create a presentation table with a dummy column , where column name will be like as showed below.  

 

Then to create all sub folders , we need to specify the presentation table description like ‘->’.

 

Enjoy and stay well !! :)