Oracle BI Consultant

OBIEE PERFORMANCE APPROACH

2008-09-26T12:47:00.000-07:00

Performance Considerations for OBIEE / Siebel Analytics:

1: Good Data Model Design on Star schema
2: NO Global Consistency Errors and Warnings
3: Metadata Repository size to be Reduced to the possible Extent b y removing the unused Objects
( tables, views, Aliases, synonyms, system Tables, Keys, Fk Keys) Init blocks and Variables
4: Best Practise and correct settings for the parameters in each section of the NQSConfig.ini
5: Applying Database hints ( use_nl, Oracle hints) for a table in the Physical layer of the Repository.
6: Reduce the SELECT statements executes by the OBIEE Server, and it chooses the correct MES.
7: Limit the generation of lengthy physical SQL queries by Modeling dimension hierarchies (Hierarchy ( Drill Key and Level Key))
8: The number of rows or record set returned from the Database can be restricted by putting the WHERE clause in the sources of the table.
9: Using Aggregate Navigation functionality of OBIEE and also design a good aggregation strategy for the Project.
10: Disable or remove the unused initialization blocks and also reduce the number of init blocks in the Repository
11: set the correct and recommended log level in the Production, setting the Query Limits and turn off logging
12: connection Pools, shared logon and number of connection pools Maximum connections and FIFO.
13: explore the features in the database properties of the repository, and push the complex functions to be performed at the database side.
14: Modeling ur Meta data using the materialized views in Physical layer
15: Good Caching and Purging strategy, Web server cache and Siebel Analytic Server Cache) and use of the Event Polling tables for the Project.
16: SQL Performance tuning for the Physical SQL generated by the Siebel analytics Server

OBIEE & Siebel Analytics, Informatica ETL Interview Topics

2008-09-09T23:06:00.000-07:00

OBIEE & Siebel Analytics Interview Topics : Focussed Prepared succeded by Experience:
------------------------------------------------------------------------------------
OBIEE 10x, Siebel Analytics 7.9.x/7.8.x/7.7/7.5.3
------------------------------------------------------------------------------------
1: Architecture ( Infrastructure & Applications)
2: Components ( BI Server, Delivers Server, BI Web, BI Cluster, Open Intelligence Interface )
3: Caching ( Query , Web Server, Seed Cache, Siebel Analytic Server Cache))
4: SA Metadata Administration (Physical Layer, Logical Layer,Presentation Layer )
5: Build, Deploy and Generating Requests (Answers, Interactive Dashboards, Delivers, Web Catalog
6: Informatica Mapping Tables
7: Integration of OBIEE with siebel CRM applications
8: Marketing Segmentation ( segment, Segment tree,List Catalog, List Import,Target Levels and Target List)
9: SQL Joins: INNER JOINs, OUTER JOINs, CROSS JOINs. OUTER JOINs are further classified as
10: How to view more than 10000 records in Siebel Analytics web in a Table or Pivot table Views.
11: Bridge Table ( many to Many Relationship in dimension.) Implemenation in Siebel Analytics
12: Objetcs can be Imported in Physical Layer( tables, views, Aliases, synonyms, system Tables, Keys, Fk Keys)
13: Dimension Hierarchy ( Drill Key and Level Key, Prefered drill Path)
14: Business Model Complex Joins (Place holder) and hardcode foriegn key
15: Physical model Connection Pool (shared Logon and Maximum connections and FIFO)
16: Shared logon in Physical layer of the RPD how it works and whats the use of it
17: Global Prompt and Filters, Filter( is Prompted) in SA 7.5.3
18: Dashboard Objects ( content, reports,section, Page , Dashboard and Folder)
19: Admin page ( Sessions, Priviliges, Analytics Catalog, Web Groups and uses)
20: Performacne Tunining in Siebel Analytics ( hints and Nl,)
21: Event Polling ( how event polling is done and also Purging)
22: SDE and SIL Mappings ( Siebel data warehouse ETL, SRMW)
23: Slowly changing Dimension ( type1, Type2, type3)
24: Assocative Entity ( Data Modelling)
25: truncate and Delete ( Auto commit on truncate)
26: Types of indexed (In Oracle ( B* , B tree, clustered)
27: Explain Plan and TK Prof ( Tunning)
29: Aggreagte Navigation, Fragmentation, Intialization Blocks and Variables ()
30: Star and Snow flake Schema
31: SRMW Tables (Fact tables ,Dim Tables, mini Dim Tables, Subset dim Tables,
32: Circular Join, Factless Fact
33: Life cycle DWH
34: Views ( Narrative, Static, View Selector, Compound layout, charts and other Views)
35: Difference between Table and why Pivot Table View ?
36: SRMW Siebel Data Warehouse (W_PARAM_G needs to be populated always for any ETL run or all the SIL mappings will fail.
37: Aliases in siebel Analytics Physical Layer
38: Creation of Reports, Prompts and filters
39: Advantages and Disadvantages of using SQl in Physical Layer
40: XLs Sheet imported in Physical Layer and its use
41: Online and Offline mode in Repository
42: Navigation in SA if column is selected from two same sources in the Logical Layer
43: View and synonym where to use which scenarios in the Physical layer of the RPD
44: Triggers in Oracle
45: Can CASE statements used in Physical and Logical Layer ( IF Case and Switch CASE)
46: Groups and Web Groups, Groubs thats created in WEb will it visible in RPD
47: Customization of Login Page ( style sheets and XML Files)
48: use of a web server in Siebel analytics
49: Full and incremental Load in SA ETL
50: DB Growth and size of the Database after ETL
51: Mapping of new aggregate Table in the Business Layer
52: How to have a new column in siebel naswers if the column is not avalible in Metadata
53: DAC and ETL
54: Informatica, siebel Applications Configuration and Siebel Tools
55: Multiuser check out & Administration of RPDS.
56: OBIEE Security & Single Sign on
57: Visiblity Model in Siebel & OBIEE Analytics
58: function of Connection Pool in the physical layer
59: Different user authentication methods available in Siebel Analytic s
60: SA column selector whats it it and how it can be used
61: Servers installed after ur Installation of siebel Analytics
62: Action Links in siebel application
63: Siebe delivers Automatic population of Devices and profiles for users
64: System session and Variables in the Repository
65: Security Levels in siebel Analytics
66: OLAP and OLTP
67: star and snow flake schema. where snow flaks can be used and which uses what schema (OLAP and OLTP)
68: Image Prompt and column Prompt in siebel answers
69: How a logical request works in Siebel Analytics
70: Performance issues applied in the siebel Analytics
71: Siebel analytics clustering how fail over recognises the other server
72: properties of connection pool, multiple connection pools to the same Database
73: Narrative View and Styles applied to charts and different view avalible in analytics
74: Upgrade of a old web cat to a new Web cat After the new installation of OBIEE
75: Disconnected Who uses it and steps in configuring Disconnected application
76: How to Bypass the Repository Authenication
78: Corelated sub query, Derived Tables
79: Normalization and five normal forms
80: What is the primary key, foreign key, alternate key, composite key and candiate key
81: Bringing data at run time from other database
83: Meta data ( do we actually have database or is data stored in meta data
84: which triggers the ETL and how data is refreshed
85: How is the Event polling and purging done
86: Addding a New dimension to the Existing DataMart
87: Is Data model changed in Newer version of siebel analytics ( why and what measures needs to be taken while upgrading)
88: Ibot fails and ggives odbc error in Production how to prevent the error in delivering to the recipent
89: How to Create the report and what are the standards followed to do the same
90. Hierarchy of the Siebel Analytics Web components
91: How comfortable in Siebel tools to get the understanding of the Tables and joins
92: Data Modelling Fundamentals and Concepts Different Types of Data modelling (Physical & dimensional)
93: Different utilities in Siebel Analytics(Admin tool,odbc client & catalog)
94: Joins & Keys(in analytics Layers ie. Phy & Bus) , creation of Aggregation Tables(Hirearchy,summary,sources)
95: Different stages of working in analytics Repository(12)
96: Datawarehouse Basics & ETL
ETL (A,b,c into x (a,b,c ->different Data sources) how ot achieve by writing oracle procedure
97: Visiblity Model in Siebel Analytics
98: Advanced Formatting in analyitcs(Conditional Fomating of Reports)
99: Physical SQL, NQQuery Log, NQS Config. INI, Cluster Config
100: Integrated ,stand alone Analytics Difference.
101: Relationship between saved objects in Analytics Web Catalog and Repository
102: Configurable NQSConfig.ini file parameters which affect disk space
103: Setting INTERRUPT_ENABLED parameter for Analytics Server using DB2 as a source
104: Displaying Multiple Time Periods in a Single Report
105: PopChart image server functionality in Siebel Analytics version 7.5.x
106: How to set up LDAP Security within Siebel Analytics Repository
107: When are Subject Areas and View Privileges visible in the Admin > Manage Privileges link?
108: How can users move the "My Accounts" Link to the "My Dashboard" screen?
109: What are the standard/best practice rules to build a hierarchy?
110: How can users check the status of an iBot?
111: How to set-up multiple analytics repository access in Windows OS installs
112: How should usage tracking information be loaded into Siebel Analytics 7.5.x?
113: Can the Siebel Analytics Platform be upgraded without upgrading the Siebel application repository?
114: What is guided navigation, custom page layout, & system message
115: How do we add/control a system message, explain the steps in detail
116: What are alerts How do we schedule alerts
117: why is the 'number of elements at a level' required for dimension
118: Log level in Production, Locale
119: bumping log files in prodcution and how to debug the issue in prodcution when log level set to 0 and how to get the query in the log file
120: DAC system Properties design, setup and configure, indices and tasks and sessions defn in the dac
121: etl configure dw_rep tables create and drop dac repository, informatica Repository Tables
122: OBIEE briefing books and xml publisher
123: ETL takes more time to complete how to debug and what approach to resolve the same
124: session log, mapping, workflow, configuration settigns of informatica
125: Roll back segment error, snapshot too old error
126: Performance tuning, Conformed dimensions
127: change capture Process in ETL, Pruene Days
128: Design the report from scratch ( Data Model)
129: Level Based Measure, Grain in a fact Table
130: Architecural Difference between OBIEE & Siebel analytics

OBIEE & Applications Architecture

2008-09-08T14:16:00.000-07:00

Oracle BI Applications Architecture (Enterprise-wide, Industry-Specific Analytic Applications)
---------------------------------------------------------------------------------

Oracle BI Presentation Services

Oracle Interactive Dashboards
Oracle Answers
Oracle Delivers
Oracle Reporting & Publishing

Oracle BI Server (Common Enterprise Information Model )
Enterprise Business Model and Abstraction Layer
Intelligent Caching Services
Multidimensional Calculation and Integration Engine
Intelligent Request Generation and Optimized Data Access Services
Metrics / KPI's
SA / Logical Model
Physical Map
Federated Data Sources
Oracle, SAP R/3 Siebel, EDW, Other
Data Warehouse / Data Model
DAC
ETL

Oracle BI Suite EE (Best-of-Breed, Next Generation BI platform )
---------------------------------------------------------------------------------
Interactive Dashboards
Reporting & Publishing
Ad-hoc Analysis
Proactive Detection and Alerts
Disconnected Analytics
MS Office Plug-in
Web Services

Oracle BI EE Architecture
---------------------------------------------------------------------------------
Oracle Delivers Server
Oracle BI Cluster Controller
Oracle BI Server
Oracle BI Administration
Oracle BI Web
External Authentication
Analytical and Operational Data Sources

Focus Areas for Improved Performance on OBIEE ETL

2008-09-04T15:50:00.000-07:00

OBIEE DAC Full load & Incremental load ETL duration Focus Areas for Improved Performance:
1: Change Capture Takes More Time in ETL Process in OBIEE DAC for Siebel Marketing
2: Composite Key for Fact Table ( all foreign keys of the Fact Table)
3: Drop and Create Indexes Manually After DB Migration
4: High Waterfall Mark issues to be addressed in the Database Objects
5: Database Volume on OLAP Database
6: Maximum Sessions parameter value in DAC to Determining the Informatica Server Maximum Sessions Parameter Setting
7: maximum number of work flows that can be executed in parallel on the Informatica server.
8: Drop Unsed Objects and compile the invalid objects in the Database
9: Disable Jobs / Tasks that re not part of the execution Plan of the Current ETL.
10: use union or union all in the SQL Qualifier instead of 'OR', Remove Duplicates from Staging Table.
11: Bulk Loading in Informatica.

Thanks
BSK

Message Categories From Siebel bookshelf To focus Right Area for errors

2008-08-28T17:16:00.000-07:00

Table 2. Message Categories
---------------------------------------------------
Message Number Message Category
---------------------------------------------------
11xxx - 12xxx Siebel Analytics Communications Messages
13xxx General Security Messages
14xxx - 15xxx Internal Navigation Messages
16xxx ODBC Access Messages
17xxx - 18xxx Oracle Access Messages
19xxx - 27xxx SQL Preparation Messages
28xxx UDML Parser Messages
29xxx Repository Metadata Messages
30xxx - 32xxx Join and UDML Generation Messages
34xxx - 40xxx General Administration Tool Messages
41xxx Siebel Analytics Client Messages
42xxx Request Generation Messages
43xxx Siebel Analytics Server Access Messages
44xxx Exception Messages
46xxx - 48xxx Utility and Configuration Messages
49xxx Communication Access Messages
51xxx General Siebel Analytics Server Messages
52xxx Cache Storage Messages
53xxx LDAP Security Messages
54xxx Connection Pool Messages
55xxx - 58xxx Cache Management Messages
59xxx Query Execution Messages
60xxx External Access Messages
61xxx File Management Messages
62xxx Metadata Import Messages
63xxx - 64xxx XML Gateway Messages
65xxx Relational Datasource Adapters Messages
66xxx - 68xxx Siebel Analytics Scheduler Messages
69xxx - 72xx Siebel Analytics Cluster Server Messages
73xxx Siebel Analytics Client Communication Messages
75xxx Siebel Analytics Scheduler Mail Access Messages
76xxx Siebel Analytics Scheduler Client Messages
77xxx Siebel iBot API Messages
.

Siebel Analytics Answers Erros out ORA-03113

2008-08-28T15:56:00.000-07:00

ORA-03113: end-of-file on communication channel errors in Siebel Answers

Running a Request in Siebel Answers gives Oracle Error.

1: Select Few columns from opportunity, position dimension and Revenue Fact in siebel Answers, when we ran the Request it gives Odbc Erros saying ORA-03113: end-of-file on communication channel errors.

2: when we Take the Physical SQL from the log file and Ran the same query in toad, here too it gave the same Error.

3: when we checked with the DBA it was giving an Oracle Internal Error "Core dump"

4: After debugging the SQL in Toad with Trial and error method, came to conclusion that the 2 conditions used for a column in opty DX was causing the Error.
ie( Column with " IS NOT NULL" AND "<>'N' " for an attribute.

5: when we removed any of the condition the SQL runs fine in Toad, then after further analysis , by adding the same attribute which has the same two conditions in the select list ,
the issue got resolved in Oracle Toad as well as in Siebel Analytics Answers.

The Siebel Analytics attempts to execute query using the W_INS_CLAIM_F table by default.

2008-08-25T16:24:00.000-07:00

How to remove the Default Join Path from LTS:

i): By Default when Employee name is selected the join path traverse to insurance fact ratter than expected Join Path.

ii): This Issue Arises when we have both the horizontal and vertical in the siebel analytics RPD.

iii): The requirement was to Get the name of the Sales Rep based on the Login from employee and their associated territory.

iv): This has been fixed by removing the reference in the Insurance Source of the FACTS (W_INS_CLAIM_F) table in the content tab of the LTS to the Horizontal dimensions so that it will choose the most economical sources as what is expected.

v): Employee and opportunity Relation is Many to many between these two. so the relation goes like the parent held position id in s_contact and row_id in the s_opty tables to the Intersection table of S_opty_postn through the Opty_id and Position_id).

Implementation Challenges

2008-08-21T17:38:00.000-07:00

Siebel Analytics end-to-end Challenges from Experience In Projects:

1: Siebel Delivers Automatic Population of Device and Email Address

2: Three Time Zone Refresh of ETL and report the Data based on the users Timezone

3: Data Level Security for the Siebel Sales application, Project Inaccessible column

4: Amount to be displayed in USD As well in Local Currency based on the Location

5: Siebel marketing List Generation & Launch Import

6: Siebel Campaigns based on the Position & territory assignment, to be populated in the Campaigns & Response Fact Table.

7: Load Campaign, Attach Segment, Lists errors in Siebel marketing Application

8: Database related Functions in OLAP to be pushed to the Database and not in Siebel analytics Layer

9: More time spent in the Siebel analytics Web Layer after the record set being returned from Database.

10: Siebel analytics Web server Crash and the tmp file size growing more than 4 Gb.

11: Siebel Vanilla Next Product Purchased Report Issues- Alternate Work Around.

13: Performance Bottleneck related Issues for Few reports and Application

14: System Administration Issues in setting up the New Environment ( DAC , Informatica, Siebel analytics, siebel delivers Erros)

15: Open Intelligent Interface. SA Metadata to be brought in Business Objects universe through Siebel Analytics DSN.

16: Oracle BIEE Publisher Admin Tab not visible after installing OBIEE 10.1.3.3

17: output of the report in a PDF dint deliver more than 25 rows in the deliver content of siebel Delivers

18: To track the changes in the Revenue amount based on the Lead Quality / stages in the opportunity

19: Access denied Error while doing the Manual Web cat merge between Environments.

20: To build a Obiee Web catalog from the siebel Analytics 7.8.5 Webcat to move the customized web Object contents ( Reports, pages,Dashboards)

21: "Too many values" being displayed in the Dashboard Prompt in OBIEE

22: System message to be Displayed in the Application when its required.

23: Static Toggle and Dynamic toggles and Tree Explorer View of report and Objects in siebel Analytics 7.5.3

24: Stopping the Sub query Generation of Physical SQL for the siebel Analytics Request being executed.

25: Add Oracle Hints Parameter to the table in the Physical Layer of the RPD to improve the Siebel analytics Request Performance.

26: Legend View to display Only the Lead Quality of the Top opportunities in a report.

27: Dashboard failing with Error: Governor limit exceeded in cube generation

28: Unresolved Column name and unresolved table name in Few reports of the dashboard.

29: Incorrectly defined logical table source (for fact table Fact - Account Transactions) does not contain mapping for [Activity.Activity Type].

30: Worked on Level based measures, dimension hierarchies, complex metrics, aggregation, fragmentation

31: IIS: HTTP Error 401.3 - Unauthorized: Access is denied due to an ACL set on the requested resource.

33: Customization of No Results View to display the meaning ful Content when no Data is returned from the Database.

34: The session variable, NQ_SESSION., has no value definition while using the variable in the column formula of a request

35: Metadata Global Consistency check Errors in RPD Good to Debug and Fix the Errors.

Siebel Sales, Oracle EBS, Siebel Marketing Campaign Related With Order:

2008-08-19T12:37:00.000-07:00

Siebel Sales, Oracle EBS, Siebel Marketing Campaign Related to an Order:

1: Typical Sales Life Cycle:

Prospecting ----> Lead ----> opportunity ----> Quote ----> Order ----> Closure
ENTITIES (Accounts, Contacts, Opportunities, Quotes)

2: Oracle EBS Data flow for an Order

Order ----> Oracle Install Base ----> Service Contracts ----> AR ( Recievables)

3: Retrieve Contact Information of an Account for Orders Placed and target Set of Customer for Service related Orders and New orders

4: Siebel Campaign Load for the list being generated from Oracle EBs for list of contacts.

Programs ----> Campaigns ----> Offer ---->(Email) ----> Segment / List ---->Load/ Launch ----> Responses

Responses ----> Leads ----> Opportunities

5: Key Tables / Views Involved in the Modules:

ORACLE EBS:
TABLES:
RA_CUSTOMERS
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
HZ_CUST_ACCOUNTS
HZ_PARTIES
HZ_PARTY_SITES
HZ_LOCATIONS
HZ_CUST_ACCNT_SITES_ALL
HZ_CUST_SITE_USES_ALL
MTL_PARAMETERS
MTL_SYSTEM_ITEMS_B
CSI_SYSTEMS_B
CSI_ITEM_INSTANCES
CSI_SYSTEMS_TL
VIEWS:
AR_CONTACTS_V , CSI_SYSTEMS_V

Thanks
BSK

Siebel Marketing List Management

2008-08-18T15:17:00.001-07:00

Importing the Responses from CSV to a Campaign:

1: Edit the Source File CSV in the correct format as Required by the Siebel system

2: Create a New Lists in the siebel Marketing by navigating to -> list Mgnmt -> and then upload the CSV file created.

3: click on the New list Created and Edit the Matching columns in the CSV files , assocaite the source coe or campaign name to the list in the System and then save the list.

4: go to List Import formatis and enable the matching column as per the requirement.

5: Now Lauch the List Import so that the Responses CSV will get loaded in to the Siebel system for the campaign associted with the same.

Admin Tab Was not visible after logging in Oracle BI Publisher

2008-08-14T17:01:00.000-07:00

Oracle BI Publisher:
Admin Tab Was not visible after logging in Oracle BI Publisher. it was giving security Exception errors.
1: Config File Changes for the XMLP Server (
OracleBI\xmlp\XMLP\Admin\Configuration\xmlp-server-config.xml
OracleBI\xmlp\XMLP\Admin\Security\principals.xml
oc4j_bi\j2ee\home\applications\xmlpserver\xmlpserver\WEB-INF\xmlp-server-config.xml2:

2: Cryptotools to generate the XML file to store the userid and password for BI and Publihser admin in credentailstore.xml

3: change the security model to XDO and try with the default uid/pwd of BI publisher , in case if it gives the security Exception error

4: Once we login t the Publisher click on the Admin tab and then do the configurations for BI server & Discoverer

Thanks
BSK

Siebel Delivers : Automatic Set up of Device & Email

2008-08-14T16:40:00.000-07:00

How to Setup the Email device Automatically for the Siebel Delivers for the users exists in Siebel OLTP Applications.

1: Make the SA System Subject Area visible in the Presentation Layer for the Administrator.

2: Ensure that the Authenication Init block uses the (OLTP DB Auth Conn Pool) and its only for the same.

3: Make the Changes in the config.xml and NQS config.ini for the Database Authenication and the SA system Subject Area, recipentname.

3 a: Restart all the services of Siebel Analytics ( SAW, SAS, Scheduler)

4: Create a new ibot and select the Email checkbox form the Destiantion Tab, select the users from the recipents tab and attach the content and save the Ibot.

5: If we need to get more inofrmaiton on the Delivers log we need the check the Debug option while configuring the ibots in the RPD of Siebel Analytics

6: check the ibots status in the log file getting generated in the Log folder of Siebel analytics.

Thanks
BSK

Oracle BIEE Apps 7.9.4 Install & Configuration Hands on Expereince on Erros Encountered & resolution

2008-05-30T17:18:00.000-07:00

Oracle Business Intelligence Applications Installation and Configuration Hands on:

*******************************************************************************************************************

1: Install JAVA SDK 1.5 or higgher

2: Install Oracle Business Intelligence Platform

3: Install Oracle Business Intelligence Applications

4: Process of Copying Hibernate Libraries

Please do the following to obtain Hibernate Core 3.2.2 GA:

--> Navigate to 'www.hibernate.org' website

--> In the search field on the top right hand corner of the page, type 3.2.2

--> You will get 5 hits for the search result. Click on 'Hibernate' link on item 3

--> Scroll down to the bottom of the page until you see the following:

"3.01.2007 - Hibernate Core 3.2.2.GA

Hibernate Core 3.2.2.GA has just been released. See the changelog for details."

--> Click on the ' 3.2.2.GA' link

You should be able to download Hibernate Core 3.2.2 GA from here.

5: Extract All Jar files and "dtd" files from Hibernate folder and copy the Jar files to DAC\Lib folder and Coyp *.dtd files into DAC root folder.

6: DAC IS NO LONGER PART OF THE ANALYTICS PLATFORM FROM OBIEE 10.1.3.2 ONWARDS DAC is now a part of the OBIEE Applications release (current release is version 7.9).

you will only get the DAC installer with the OBIEE Application installer.

7: Insatll Informatica POwercenter 7.1.4 and configure Informatica server and Respository Server

8: Create DWH Tables and Triggers from DAC to Database.

9: Try a Complete Dry Run to load all the see data from the CSV to the target tables.

*******************************************************************************************************************

Parameters used by Informatica workflows/sessions are fed to Informatica using a different architecture in 7.9.0, and

the extra configuration steps to get this new Parameterization functionality to work are not documented

In 7.9, while executing ETL, DAC

1. Reads & evaluates parameters from all static parameter files in the input directory

2. Reads & evaluates all parameters in DAC UI

3. Creates a file with evaluated name-value pairs for all parameters (in static files + DAC UI).

a. DAC creates one parameter file per informatica session. All parameter files created by DAC will be named <..Txt>.

4. Copies the file into a location configured under the “DAC setup>InformaticaParameterFileLocation” property. The default location for this property is <\DAC\Informatica\parameters>.

These parameter files contain all parameters - static (from files), and dynamic (from DAC UI) with properly evaluated values.

Here are the extra configuration steps

(1)Informatica Server Variable > $PMSourceFileDir must be set exactly the same as the DAC System Properties > InformaticaParamatereFileLocation as follows:

C:\oracleBI\DAC\Informatica\parameters (NB***no spaces in folder name****):

(a)Informatica Server Variable > $PMSourceFileDir

(b) DAC System Properties > InformaticaParameterFileLocation

Both Informatica and DAC must be able to access the folder specified above..

This could be important where components are distributed across several machines , also for unix user folder access

(2) Copy all files from OracleBI\dwrep\bin\Informatica\LkpFiles

eg domainValues_Emp_EventType....xls

to the location specified in $PMSourceFilesDir AND specified in DAC System Properties > InformaticaParameterFileLocation (should be identical location)

*******************************************************************************************************************

The Relational Connection settings in the Informatica Workflow Manager need to be set the same (including Case Sensitivity) as those used when configuring the 'DAC > Setup > Physical Data Sources'.

*******************************************************************************************************************

Errors Encountered during this complete Process:

1: TM_6193

2: VAR_21705

3: pmrep Connect Error

4: pmrep Connect Exception

5: comman line Stack Trace in DAC

6: Database Driver Errors

7: JDBC Error while connecting to data sources from DAC

8: Oracle OCI 8 driver not Avalible

9: Cannot find the Parameter file

10: Relation Connection Sources Error

11: FR_3000 Error opening file

12: Rep Error while restoring the Oracle_BI_DW_Base

13: Err: 1053 while starting the informatica Service

14: Team based Licensing error in the informatica repository server configuration.

15: Error opening file [/home/anapp/informatica/PowerCenter/SrcFiles/LoadXRef_Contact.txt]. Operating system error message

*******************************************************************************************************************

Links for Resolvoing the Errors:

Oracle® Business Intelligence Applications Installation and Configuration Guide

http://download.oracle.com/docs/cd/E10783_01/doc/bi.79/e10742/anyinstadmwininstall.htm#i1105233

*******************************************************************************************************************

Flickr

2008-03-31T16:02:00.001-07:00

This is a test post from , a fancy photo sharing thing.

WEB RESOURCES FOR ORACLE BIEE ANALYTICS

2008-03-31T15:13:00.000-07:00

Analytics Done Right

BI ERP Dashboards

Clear Peaks

Dashboards, Applications & BI

Dylan's BI

Index of -Papers

ITtoolbox

lutz hartmann

OBIEE 10g (10.1.3.x)

OBIEE Certifications

Oracle Apps DBA

Oracle BI Applications

Oracle BI Blog

Oracle Brains

Oraclebizint

Orion MetaLink

Remote DBA

SelectorWeb

Siebel Street

Suresh Vaishya

Teachinformatica

Techonthenet

Venkatakrishnan

Vidya Bala's