Implementation Challenges

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:

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

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.