Thursday, April 26, 2007

Siebel Analytics installation flow.

  1. Install Prerequisites
    j2sdk > 142
    set environment variables
    DSNs
  2. Install the Analytics Platform
    Create scheduler tables
  3. Install analytics applications
    SRMW
    Customer centric applications such as supply chain management
  4. Install Informatica
    Patch it if required
  5. Configure DAC
  6. Create DAC Mata data repository
  7. Create data warehouse tables
  8. Upgrade transactional database schema
  9. Create delete triggers
  10. Create informatica repository
  11. Configure informatica repository
  12. Set up Informatica server
  13. Set up informatica repository server
  14. Set server in workflow manager
  15. load seed data for customer centric applications
    Merge ANALYTIC repositories IF ANY।

Wednesday, April 25, 2007

Few Important Basics Analytics

Foreign key in FACT table has reference to the primary key in dimension table.
Business model has two or more logical tables and each table has two or more logical columns. Logical table is on top of Physical table. It can combine the contents of two or more physical tables or from other logical tables.
Facts are analyzed by dimensions.
In hierarchical dimension, one attributes rolls up to ANOTHER, FORMING ONE TO MANY RELATIONSHIP.
Star and Snowflake:
Stars have one to many relationships between the logical dimension tables and logical Fact tables.
Snow flake has relationships between dimensions too
Create bridge table, to create many to many relationships between dimension tables and fact tables.

Tuesday, April 24, 2007

Basics of Siebel analytics solutions

Siebel provides the following three types of analytics.

Stand alone analytics
Siebel analytics (CRM)
Siebel analytics ( enterprise)

Stand alone analytics Basics:

Siebel provides platform components to access the data warehouse (custom) and analytics administration tool to create and edit Meta data content, used to create reports and analytics server to process client requests and analytics web server to provide answers and dash boards over web.

Siebel Analytics (CRM)

Siebel Analytics (CRM) provides a customized data ware house (SRMW)and pre built Meta data (repository data) content that is useful to analyze the users business which has already deployed any customer application. This is provided in addition to the components provided as part of Siebel analytics. The limitation is users cant access other database other than CRM application data and customized data ware house

Siebel analytics (enterprise)

In addition to all of the above, customers can access any data base if they got enterprise license.

Monday, April 23, 2007

Open source CRM and analytics

Open source an interesting area where I am interested in starting business. Does any one of you interested please ping me

Thursday, April 19, 2007

Siebel Analytics Open Intelligence Interface nqserrormsg.cat

When installing open intelligence interface we get an error “cant copy ***.cat file as it is already existing” . to avoid this we need to stop all Siebel analytics services and also take back up of that particular file and reinstall again. You can successful install

Tuesday, April 10, 2007

Localdb/Mobile Client login errors

Today I got a peculiar issue where one of my developer usually able to log in and work properly, suddenly he is facing errors “the authentication subsystem failed, user name and password entered is incorrect”.

Diagnosis: The user is directly working on the server and he established two connections and in one of the session, dbgen.exe using the database so no new connections are established.

As local database is already used by the dbgen process and another process cant be initiated and the developer is receiving an the above error

Solution: Kill the dbgen process and login.

Friday, April 6, 2007

How to shutdown the remote system

To day i got a problem in rebooting the system and i serched the web and found the process. to shoutdown any system remotely, you should be in the same network and should have access. if you have access to the system, then issue the follwoing command

Shutdown /r /f /m //machinename or IP/t 20 /d p:5:12 /c "shutting down as it is not reboted properly"

r : restart
f :forcbly
m: followed by machine name
t :wait time in seconds
d p : planned/unplanned follwoed by integer number
c : reason for restart.

Note:This command is used only in windows servers.