Wednesday, August 11, 2010

Stocks Useful Links

If you want to get the whole saving/investing thing started early, I would just toss the money in a set of index funds. I recommend Vanguard (low fees and high quality product - index funds are more or less all the same), diversifying across a few different indices (depending on what you wish, you could spread it across the S&P500 fund, the international equity fund, a corporate bond fund, and treasuries).

AFTER THAT, I would then begin the "learning" phase. What most people do not understand is that putting your money in a few companies is unbelievably risky unless you really know what you're doing. You can't just invest in names you know, the key is how much you're paying for them. With your money tied relatively safely in index funds, I would start researching individual companies. Take a look at the Investor Relations section of their websites, and read through the most recent 10-K. Don't worry if its unbelievably confusing, it's honestly not meant to be fully understandable by the general public. Your first time through, look through the verbal parts. Read the sections that describe the business, read sections like the Management's Dicussion and Analysis - skim through some of the numbers if you wish. Watch, if you have access, financial news programs, the Wall Street Journal, finance sections of news websites like CNN. Go to Yahoo! Finance or similar sites and see what the recent news is for specific companies as well as the economy as a whole, and look at how this news is impacting stock prices. Use Investopedia and Wikipedia.

What's important that this stage is that you learn. Avoid getting trapped into the world of people who have never opened a 10-K but think they're stock market geniuses because their uncle's brother's friend's barber had a great stock tip. One really good thing to do once you get into college is go to the business school library if there is one and ask how you can get access to equity research reports of companies. I would recommend that, at all costs, avoid technical analysis. It's an interesting idea but at the retail level (what you and 99.9% of the rest of the public is at), it's just not a very good idea.

http://www.investopedia.com/
http://www.capitalmarket.com/
http://www.commodityinsights.com/
www.stockclever.com
http://www.stockstobuy.co.in/
www.maketheprofit.com
http://www.finance-trading-times.com/
http://sharegenius.blogspot.com/
http://www.moneycontrol.com/

Sunday, July 25, 2010

Siebel Application Object Manager

Siebel Application Object Manager (AOM)

Application Object Managers (AOMs) host the Business Objects layer and Data Objects layer of the Siebel architecture.

It is a server component that creates and processes data at multiple levels.

UI layer (supported by the Siebel Web Engine)
Business object layer
Processes business logic
Data object layer (supported by Data Manager)
The AOM is used primarily to support Siebel Web client connections.

AOMs are hosted as components in the Siebel Server and run on the application server (the machine that hosts the Siebel Server). The Siebel Server provides the infrastructure for an AOM to serve multiple Siebel Web client users. Multiple AOM components can run on a single Siebel Server installation.



AOMs communicate with clients using the TCP/IP protocol through a Web server that contains the Siebel Web Server Extension plug-in (SWSE). Communication between the Web server and the AOM can be compressed and encrypted. An independent session is established to serve incoming connect requests from each client. Subsequent requests from clients are directed to the same AOM tasks until the sessions are terminated.

After startup, AOMs do not achieve their full run-time environments until after the first connect, therefore, leading to possible delays during the first connection.

Monday, July 19, 2010

Escript Best Practices

There a Golden Rule that every Siebel Developer should follow when it comes to scripting. This golden rule is to never script unless there is no other choice on meeting your requirements. Scripting is the highest level of customization and adds complexity and cost to the configuration. So scripting should be your last resort. So the first practice is to avoid script. So to avoid scripting, below are some configuration methods every developer should think before attempting to work with eScripts

User Properties: This is a major feature in Siebel. An example of this is “On Field Update Set”. This is used instead of scripting on Set Field Value event to change some other value.

Calculated Fields: Calculated fields come very handy when we need to do validation. With the help of Calculated Fields and User properties lot of functional requirements are achieved.

State Models: State models help in restricting transitions from one field value to other. So there is no need to script to check the status change.

Runtime Events: This was introduced in 7.7 and has been of significant help to the developers to on invoking Workflows & Business Services based on events. So avoid Business Component events.

Workflows: Instead of writing a big script, we can break that down to a series of workflow steps. We have steps Like Write, Update, if condition, Sub-Process, Invoke Business Service and lot of other key stuff. Workflows are very efficient and promising.

Best Practices of Scripting in Siebel

This article presents a collection of Siebel scripting best practices.

1. Always use TheApplication to call the application, as the declaration of a global variable to represent the application (e.g. var theApp = TheApplication()) is not recommended by Siebel. The use of this variable may cause memory leaks, reduce performance or other unpredictable behaviour.

2. User-defined functions must be Forward Declared in the general declarations of each script. This avoids compilation errors that may arise if the functions called are not in alphabetical order. The compiler compiles all functions alphabetically and so if one function calls another that is later in the alphabet the compiler does not recognize this second function and therefore, fails.

3. Be cautious when adding script to business components as this code applies application wide across applets and views. If a certain piece of coding is needed at the business component level but is restrictive to certain situations like if exposed only through some particular views then make sure to limit the processing through an appropriate condition.

4. The use of 'With' is recommended by Siebel as it enables the code to be changed faster and more readable way to group operations performed within the same business component. The use of 'With' also presents a slight performance improvement.

5. Using variables can make code maintenance easier due to readability. However overuse of variables increases the amount of operations that have to be performed and can reduce performance slightly.

6. Siebel does not recommend the use of 'Empty'. 'Empty' is an undefined variable which is assigned as type variant. A variant is initially set to a null string (''), which means that any scripts currently using this term will not be affected. However, it is better practice to assign '' rather than 'Empty' to any strings you need to set back to NULL. The use of 'Empty' prevents Option Explicit from checking all other variables are declared correctly.

7. The use of 'ActivateField' prior to a query is the equivalent to the 'SELECT' statement in SQL. The use of 'ActivateField' in Siebel scripts code can be confusing and should be minimized as much as possible as this has a performance impact. However there is nothing worse than receiving a runtime exception: ' was not active...'. When activating fields note that:

a. Siebel system fields (Id, Created, Created By, Last Updated, Last Updated By) are always force active.

b. Fields that have Force Active = Y on the business component are always force active.

c. Fields that have Link Specification = Y on the business component are always force active.

d. Fields that are included in the definition of an applet on the active view if it is bound to a web template item and the 'Show In List' property of the list column or 'Visible' property of the control is TRUE. If the user removes the list column from the 'Columns Displayed' in the list applet, the field may no longer be active after the next query.

e. Fields that are used as part of a calculated field calculation when the calculated field is retrieved for use on the active applet.

8. 'ActivateField' should only be used prior to 'ExecuteQuery' to ensure that a particular field will be activated and included in the equivalent 'SELECT' statement of the query. Therefore 'ActivateField' is usually never to be used with 'this'/'Me' (eg. this.ActivateField('Field1')). This is because you don't usually perform a query in the current context as this would change the on screen query displayed to the user. Siebel actually specifies that the use of ActivateField with 'this' can possibly cause data corruption to occur.

9. When performing a query, always use 'ForwardOnly' after the 'ExecuteQuery' to set the cursor position unless moving back through the returned records. This is a much faster query because it does not create a cache that stores the previous records.

10. If you have a set of 3 or more 'IF Else If' statements then use 'Switch Case' statements instead. This simplifies code and improves performance.

11. It is best practice in Siebel scripting to use the 'Try/Catch/Finally' statements in code. This will ensure that exceptions are caught and handled appropriately and instantiated object variables are always destructed in the finally block (which reduces the chances of memory leak) as the code in the finally block is always executed. Note that object variables should be destroyed in the reverse order they were instantiated.

12. Reduce the number of queries performed as much as possible. Siebel maintains the parent-child relationships defined in links automatically so there is no need to query the child Business Component to obtain records for a given parent. Make use of commands like, 'GetParentBusComp' to access the parent record, instead of re-querying to retrieve record.

13. Don't create objects (BC and BOs) if you need a reference to BC and BO from the current context. Make use of default application variables 'BusComp' and 'BusObject' in this situation.

14. The use of 'ActiveBusObject', 'ActiveBusComp' and 'ActiveApplet' should be limited because the object represented by these statements may change depending on the active applet. Siebel recommends the use of the 'this' object for eScript ('Me' for Siebel VB) wherever possible. 'Me'/'this' represents the object where the code is written, 'ActiveXXX' represents the object behind the current active applet. The use of 'Me'/'this' is a safer method, especially during development when, it is not entirely clear which applet will be active at any given time. It also enables easier interpretation of the scripts because the 'base' object, represented by 'Me'/'this' will never change. The use of 'Me'/'this' also removes the need to store the active BusObject and active BusComp in variables as it does not need to be declared or explicitly destroyed at the end of the function.

15. All code must be indented logically, including comments which efficiently describe what the script is doing. Each new script should include a header comment which provides: Author, Date, Description and Version History for that script.

16. Delete all 'empty' scripts that once contained text. Delete everything, including the function header and footer. Otherwise the application will go to that script when the event is triggered and performance will be impacted slightly.

17. Keep use of Applet scripting to a minimum where possible. Attempt to meet business requirements by configuring in Siebel Tools where possible and generally implementing scripts for minor functionality where a given functionality cannot be met using declarative configuration.

18. Scripts which insert new records or change data should take care to explicitly commit the record otherwise the data could be lost.

19. When you are deleting records in script based on a particular query, be sure to use a while loop rather than an 'If' statement as the 'If' condition will only delete one record where multiple records may need to be deleted.

Wrong Way:


1: bcPositionMVG.ClearToQuery();
2: bcPositionMVG.InvokeMethod("SetAdminMode", "TRUE");
3: bcPositionMVG.SetSearchExpr("[Id] <> '0-5220'");
4: bcPositionMVG.ExecuteQuery();
5:
6: // The first record is identified and deleted. However,
7: // subsequent child records are not deleted.
8: if ( bcPositionMVG.FirstRecord() )
9: {
10: bcPositionMVG.DeleteRecord();
11: }

Right Way:


1: bcPositionMVG.ClearToQuery();
2: bcPositionMVG.InvokeMethod("SetAdminMode", "TRUE");
3: bcPositionMVG.SetSearchExpr("[Id] <> '0-5220'");
4: bcPositionMVG.ExecuteQuery();
5:
6: while ( bcPositionMVG.FirstRecord() )
7: {
8: bcPositionMVG.DeleteRecord();
9: }

Saturday, July 17, 2010

BIP Troubleshooting Steps

Process behind execution of Reports
Purpose: The Reports Business Service enables BI Publisher reports to be executed from the Siebel application via a Workflow Process, or through scripting. The report is generated in the background by connecting to the BI Publisher server. The report output is stored in the Siebel File System and accessed from the My BI Publisher Reports view. The Reports Business Service can not be executed on the Mobile Web Client.
Vanilla Siebel Report Business Service was not configured properly. We had issue in seeing Reports from Siebel UI. This issue is also for Vanilla Reports. When we check in Support Web found an SR which is reconfiguring Report business Services and performed the steps specified in the link below.
https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocDsrc=DOCUMENT&bmDocTitle=Siebel%20BI%20Publisher%20Reports%20Business%20Service&viewingMode=1143&bmDocID=823360.1&from=BOOKMARK&bmDocType=BULLETIN))

Troubleshooting Errors While Running Siebel Reports (SBL-OMS-
00203)



To troubleshoot errors while generating Siebel Reports
1. Make sure the XMLP Report Server server component is enabled.
2. Increase the XMLP Report Server server component log level to 5 to create a more detailed log file.
3. Copy the xdodebug.log file to the jre\lib directory.

Additionally, you might encounter an instance where a layout template was registered with one database, but you generated it with a different database, and the generation fails. If this error happens, you must complete the following task.

To regenerate and rerun the report
1. Regenerate the XML data.
2. Reregister the layout template.
3. Regenerate the report.






Troubleshooting Errors while Uploading reports.



The above error may cause for two reasons:
Reason 1: Check for BI Publisher Server with administrator privileges as below

1. Log in to the Oracle BI Publisher Server with administrator privileges
2. Click the Admin tab, and then select Security Configuration (under Security Center).
3. In the Security Model section, check the following
o Model: Siebel Security
o Check the host name and port as the Web Service Endpoint.
o Chesk the Siebel administrator credentials

Reason 2: If the Report Uploaded for second time

Need to delete the report from BI Repository, re-register the report after deleting it from repository and the upload the file.

Resolving Class Not Found Errors




1. Navigate to the Administration - Server Configuration screen, Enterprises, and then the Profile Configuration view.
2. Select the XMLPJvmSubsys profile.
3. For the JVM Classpath profile parameter value in the Profile Parameters subview, Provide a reference to each of the JAR files in the CLASSES directory in the Siebel application root directory (SIEBSRVR_ROOT/CLASSES).

For example, you might enter the following value:

\siebsrvr\CLASSES\bicmn.jar;\siebsrvr\CLASSES\bipres.jar;\siebsrvr\CLASSES\collections.jar;\siebsrvr\CLASSES\fix6312772.jar;\siebsrvr\CLASSES\i18nAPI_v3.jar;\siebsrvr\CLASSES\jdbc12.jar;\siebsrvr\CLASSES\jewt4.jar;\siebsrvr\CLASSES\MQeBase.jar;\siebsrvr\CLASSES\MQeSecurity.jar;\siebsrvr\CLASSES\share.jar;\siebsrvr\CLASSES\Siebel.jar;\siebsrvr\CLASSES\Siebel_JavaDoc.jar;\siebsrvr\CLASSES\SiebelCustomXMLP.jar;\siebsrvr\CLASSES\SiebelJI_enu.jar;\siebsrvr\CLASSES\SiebelSMQ.jar;\siebsrvr\CLASSES\SiebelXMLP.jar;\siebsrvr\CLASSES\versioninfo.jar;\siebsrvr\CLASSES\xdocore.jar;
\siebsrvr\CLASSES\xdoparser.jar;\siebsrvr\CLASSES\xmlparserv2-904.jar;\siebsrvr\CLASSES\XSLFunctions.jar;.


Troubleshooting Errors while applying fix pack.



Make sure that the Siebel repository pointing to single repository.

Process of Optimizing the Generation Performance of Siebel Reports for Large Data Volumes

Note: This task is applicable only to connected mode.

1. Navigate to the Administration - Server Configuration screen, Enterprises, and then Profile Configuration view.
2. In the Profile Configuration view list, select Server Datasource (alias ServerDataSrc).
3. Scroll down to the Profile Parameters, and then click Advanced.
4. In the Profile Parameters list, select Datasource maximum fetch array size (alias DSMaxFetchArraySize), and then change the value to -1.
5. Restart the Siebel Server.

Create Separate Named Datasource For Siebel BI Publisher Reports With Large Data Volumes

1. Create a new Profile (Named Subsystem) by cloning the existing 'Server DataSource' Profile. You would need to use the Copy Record feature to do that.
2. The new profile can be named as 'Reports DataSource' (Alias RptDataSrc).
3. In the 'Profile Parameters' specify all the parameters same as the 'Server Datasource' profile. Make sure you set the Datasource maximum fetch array size 'DSMaxFetchArraySize = -1'.

NOTE: Match up all the parameters (including Hidden and Advanced)
4. Navigate to the Administration - Server Configuration > Enterprises > Component Definitions view. Query for 'XMLP Report Server' component.
5. Click the drop down Menu and select 'Start Reconfiguration'.
6. In the 'Component Parameters’ list applet query for '*Data Source'.
7. Set the value of the following parameters:
a) OM - Data Source = RptDataSrc
b) OM - Named Data Source name = RptDataSrc,GatewayDataSrc
c) Application Datasource = ServerDataSrc
8. Click the drop down menu in the 'Component Definitions' applet and select 'Commit Configuration'.
9. Hit the 'Synchronize' button under the 'Component Definitions'
10. Restart Siebel Server and Gateway Services.
11. Log into the Siebel Application as Siebel Administrator and ensure that the XMLP Report Server component is 'Online'.
12. To ensure that the new parameters are in effect:
- Navigate to Site Map > Administration - Server Configuration > Servers >Components
- In the Component Parameters list applet query for '*Datasource'
- Verify the following parameter values:
a) OM - Data Source = RptDataSrc
b) OM - Named Data Source name = RptDataSrc,GatewayDataSrc
c) Application Datasource = ServerDataSrc

BIP Report Installation

BIP Software Download

Installing Oracle Business Intelligence Publisher for
Siebel Business Applications

Installation of BI Publisher Server

1. Log in to Oracle E-Delivery available at:
http://edelivery.oracle.com/EPD/WelcomePage/get_form?ARU_LANG=US
2. Choose a language or select the Continue link to download with English as the default language.
3. Accept the license terms and export restrictions.

4. Select Oracle Business Intelligence as the product pack, a platform (for example, Microsoft Windows (32-bit), and then click Go.

5. Select Oracle Business Intelligence (10.1.3) Media Pack for Microsoft Windows (32-bit), Part
Number B36246-15, and then click Continue(The part number is different if installing a media
pack for other platform).

6. Download the following BI Publisher installations:

Oracle BI Publisher Enterprise 10.1.3.4.0 for Microsoft Windows Part 1 of 2.
Oracle BI Publisher Enterprise 10.1.3.4.0 for Microsoft Windows Part 2 of 2.

7. Install BI Publisher by performing the following tasks
• Unzip the following files into a directory of your choice
B50931-01_1of2.zip
B50931-01_2of2.zip
• Run setup.exe.

Oracle BI Publisher Desktop Installation


Select the language and click next.



Click next.




Click Finish, setup for Oracle BI Publisher Desktop is completed.


Oracle Enterprise Installer





Click next

























Enter OC4J Password as Administrator1.







Installation of Oracle BI Publisher is completed.

Login to BI Server as below






Give the UserId and Password as ‘Administrator’.










Note: You must have installed JDK (Java Development Kit) version 1.5 or higher and pointed the JAVA_HOME system variable to the JDK.






























Steps to configure BIP Report server

1. Define Outbound Web Service for the BIP Publisher Server
a. Login to Siebel application with SADMIN
b. Navigate Administration - Web Services , Click Outbound Web Service
c. In the Name field, query for ‘PublicReportService’ change Address in Service Ports to http://crmprd02.usac.mmm.com:9704/xmlpserver/services/PublicReportService

2. Copy JAR files to the BI Publisher Server: We need to copy JAR files for successful Report generation. By default, these Java functions are not available on the BI Publisher Server.

a. Copy the following files from $SIEBEL_HOME/CLASSES to OC4J_HOME/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib

XSLFunctions.JAR
SiebelCustomXMLP.JAR
SiebelCustomXMLP_SIA.JAR( Applicable only for Industry applications)

b. Enable external file references by performing the following tasks

1) Log in to the BI Publisher Server
2) Click the Admin tab, and then select Runtime Configuration and Properties
3) Change the Default value for the Disable External Reference attribute to FALSE.

c. Restart OC4J( BI Publisher services).


3. Enable Siebel Reports: Before using Siebel Reports, the XMLP Report Server Component must be enabled. By enabling the XMLP Report Server Component, reports appear in the Reports Menu drop-down list in Siebel Business Applications.
To enable Siebel Reports do the following:
a. Log in to the Siebel application with system administrator privileges
b. Navigate to Administration - Server Configuration, Enterprises, and then Component Groups
c. In the Component Groups list, select XMLP Report, and then click Enable.
d. Click the Synchronize view tab, and then in the Component list, select XMLP Report Server
e. Click Synchronize
f. Restart the Siebel Server



4. Configure Database Authentication and Security:
To set the BI Publisher server user ID and password.

a. Log in to your Siebel application.
b. Navigate to Administration - Server Configuration, Servers, and then Components.
c. Query for XMLP Report Server, and then select it.
d. Click the Parameters tab and query for BIP*.
e. Enter the user ID and password used to access the BI Publisher Server in the Default Value fields of the BIP Server Login and BIP Server Password parameters

5. Configure Font Files
On the Siebel Server machine where the XMLP Report Server Component is enabled, copy the fonts you want to use for your reports from, for example, C:\WINDOWS\Fonts directory, to the $JRE_HOME\fonts directory.


Configuration Steps after 8.1.1.1 Fix Pack applied: (Fix Pack to get Parameterized Reports)

Apply 8.1.1.1 Fix Pack Tools, Client and Server (Download the software from Metalink Patches & Updates)

 Importing the Siebel CRM 8.1.1.1 Fix Pack SIF File for Use with Siebel Reports
a. Log in to Siebel Tools.
b. From the application-level menu, select Tools, and then the Import from Archive menu item.
c. In the file browser dialog window, choose 8111FP_new_feature.sif from the D:\SIEBEL_TOOLS_ROOT\tools\REPPATCH directory (where Siebel Tools is installed).
d. Follow the import wizard prompts to import the SIF file.
e. Compile the new project into the repository file.

 Post installation Configuration Tasks for Oracle BI Publisher

o Configuring the Outbound Web Service for the Oracle BI Publisher Server
1. Generate a new WSDL file by doing the following.
a. Start up the Oracle BI Publisher Server.
b. Using your browser, enter the following URL to retrieve the Web service definition.
http://:/xmlpserver/services/PublicReportService_v11?wsdl
Where:
• host is the full path for your Oracle BI Publisher Server
• port is the port that the Oracle BI Publisher Server uses
c. Save the definition as PublicReportService_v11.WSDL.
2. Using Siebel Tools, delete the PublicReportService outbound Web service and related integrated objects by doing the following.
a. Log in to Siebel Tools.
b. Query for the PublicReportService business service, and then remove this object.
c. Click Integration Object, query for the XMLP Integration project, and then remove all selected objects.
Note: Make sure that tools is pointing single repository.
3. Create the updated PublicReportService by doing the following.
a. In Siebel Tools, choose File, New Objects, the EAI tab, Web Service, and then click OK.
b. Select the XMLP Integration project.
c. Browse to import the PublicReportService_v11.WSDL document file (the file you created in Step 1), and then click Next.
d. Check the Deploy Integration Object(s) and Proxy Business Service(s) checkbox, and then click Finish.
4. Check your results by doing the following.
a. In Siebel Tools, click the Business Service object type.
b. Perform a query with the following criteria:
• Project is XMLP Integration
• Name is PublicReportService
c. Verify the user properties are as follows:
• siebel_port_name is PublicReportService_v11
• siebel_web_service_name is PublicReportServiceService
• siebel_web_service_namespace is
http://xmlns.oracle.com/oxp/service/v11/PublicReportService
5. Select Integration Object, query for the XMLP Integration project, and then verify there 128 projects are returned.
6. Compile the XMLP Integration project.
7. Log in to the Siebel application as an administrator.
8. Navigate to the Administration - Web Services screen, then the Outbound Web Services view.
9. In the Name field, query for PublicReportServiceService, and then change the Oracle BI Publisher Server machine name to your Oracle BI Publisher Server using the following format:
http://:/xmlpserver/services/PublicReportServiceService
Where:
 host.domain is the full path for your Oracle BI Publisher Server
 port is the port that the Oracle BI Publisher Server uses
For example, you might set it to:
http://.domain:9704/xmlpserver/services/PublicReportServiceService
10. Confirm the new PublicReportServiceService Web service is active by doing the following.
a. Restart the Siebel Server.
b. Navigate to the Administration - Web Services screen, then the Outbound Web Services view.
c. Query for PublicReportServiceService to confirm the status is Active.
d. In the Service Ports subview, verify the Name field shows PublicReportService_v11.
11. Verify that the Oracle BI Publisher Server is running and ready for generating reports.

o To copy JAR files to the Oracle BI Publisher Server ( Ignore these steps if it’s performed before fix pack)

1. Copy the following files from the SIEBSRVR_ROOT/CLASSES directory:
 XSLFunctions.JAR
 SiebelCustomXMLP.JAR
 SiebelCustomXMLP_SIA.JAR
2. Paste them to the following Oracle Application Server directory:
OracleAS_HOME/j2ee/home/applications/xmlpserver/xmlpserver/WEB-INF/lib
3. Enable the external file references:
a. Log in to the Oracle BI Publisher Server with administrator privileges.
b. Click the Admin tab, and then select Runtime Configuration and Properties.
c. Change the default value for the Disable External Reference attribute to FALSE, click Apply, and then verify the changes were made.
4. Restart Oracle Application Server Containers for Java Platform, Enterprise Edition (OC4J).



o Adding an Explicit Reference to JAR Files for the Oracle BI Publisher Server

1. Navigate to the Administration - Server Configuration screen, Enterprises, and then the Profile Configuration view.
2. Select the XMLPJvmSubsys profile.
3. For the JVM Classpath profile parameter value in the Profile Parameters subview, provide a reference to each of the JAR files in the CLASSES directory in the Siebel application root directory (SIEBSRVR_ROOT/CLASSES).
For example
${SIEBEL_HOME}/classes/SiebelXMLP.jar:${SIEBEL_HOME}/classes/xdoparser.jar:${SIEBEL_HOME}/classes/fix6312772.jar:${SIEBEL_HOME}/classes/xdocore.jar:${SIEBEL_HOME}/classes/xmlparserv2-904.jar:${SIEBEL_HOME}/classes/versioninfo.jar:${SIEBEL_HOME}/classes/share.jar:${SIEBEL_HOME}/classes/jewt4.jar:${SIEBEL_HOME}/classes/jdbc12.jar:${SIEBEL_HOME}/classes/i18nAPI_v3.jar:${SIEBEL_HOME}/classes/collections.jar:${SIEBEL_HOME}/classes/bipres.jar:${SIEBEL_HOME}/classes/bicmn.jar:${SIEBEL_HOME}/classes/Siebel.jar:${SIEBEL_HOME}/classes/XSLFunctions.jar:${SIEBEL_HOME}/classes/SiebelCustomXMLP.jar
Where:
${SIEBEL_HOME} is the actual path where the Siebel application is installed.
4. Restart Siebel services

 Process of Configuring Security and Authentication for Siebel Reports

o Setting the Siebel Security Model for Siebel Reports

1. Define four new responsibilities in the Siebel application by doing the following:
a. Navigate to the Administration - Web service screen, then the Inbound Web Service view.
b. Import the BIPSiebelSecurityWS.XML file to create the inbound Web service from the D:\SIEBEL_TOOLS_ROOT\tools\REPPATCH directory (where Siebel Tools is installed).
c. Change the host and port number of the server port's address to that of the Siebel Server.
d. Navigate to the Administration - Application screen, then the Responsibilities view to add the following new responsibilities:
Responsibility Description
XMLP_ADMIN Administrator role for the Oracle BI Publisher Server with no access limitations.
XMLP_DEVELOPER Assign this responsibility to allow for uploading reports from the Oracle BI Publisher Server to the Siebel application.
XMLP_SCHEDULER Assign this responsibility to allow for scheduling of reports.
XMLP_SIEBEL_GUEST Assign this responsibility to limit access to reports. This responsibility only allows for generation, viewing, and deletion of user's own reports.
e. Assign these responsibilities to the appropriate users.
2. Associate the XMLP_SCHEDULER responsibility with the Report Job List View.
This association allows users to view their scheduled reports in the My Jobs view in the Siebel application, which is an embedded user interface to Oracle BI Publisher.
3. Enable the Siebel Security model by doing the following:
a. Log in to the Oracle BI Publisher Server with administrator privileges.
b. Click the Admin tab, then select Security Configuration (under Security Center).
c. Create a super user as shown below and click Apply button.


NOTE: Super user allows you to log into the Oracle BI Publisher Server when the Siebel application is not running.
d. In the Security Model section, perform the following, and then click Apply.
 Set the model to Siebel Security
 Enter the host name and port as the Web Service Endpoint
 Enter the Siebel administrator credentials

4. Set the proper access permissions to the SiebelCRMReports folder by performing the following:
a. Open a new browser window and navigate to the Oracle BI Publisher Server at
http://BIPServerHost:9704/xmlpserver
b. Click the Admin tab, select Roles and Permissions, and then locate the XMLP roles (XMLP_*).
c. For each report responsibility, click Add Folders to grant permission to the shared SiebelCRMReports folder.
5. Restart the Oracle BI Publisher Server.

BIP Reports Setup in Siebel

BIP Reports Documentation




Introduction 2
Steps to convert Actuate Report into Oracle BI Publisher 2
Actuate Reports Conversion Assistant 3
Steps to Convert Report Layout 4
Siebel Reporting Architecture with BI Publisher 7
Two Different Modes for BI Publisher Integration 7

Siebel Reports Architecture and Report Flow Generation for Connected Mode 7
Siebel Reports Architecture and Report Flow Generation for Disconnected Mode 9
OBI Publisher Reports 11
1. Create a new Integration Object in Siebel Tools – 11
2. Create sample XML file- 14
3. Create a Report template- 17
4. Register the report template using the Report Template Registration view. 26
5. View Association- 27









Introduction
BI Publisher has been introduced to Siebel users since its Release 8.1.1 as a new reporting platform replacing the older Actuate base reporting platform. It is tightly integrated with the Siebel architecture and its applications. The users can run and manage their reports with BI Publisher from Siebel applications UI.
This document provides detail description of how to convert Actuate reports to BI reports and how to create reports Using OBI Publisher

Steps to convert Actuate Report into Oracle BI Publisher

The Siebel Reports integration with Oracle BI Publisher is based on a loosely coupled architecture where Oracle BI Publisher runs as a standalone server. The integration point for Siebel Reporting will be through standard Web services integration using Siebel EAI. Reports will be submitted and rendered within the context of the Siebel user interface. The reports can be saved within the Siebel file system. Actuate, in a Siebel CRM environment, handles the report layout in an Actuate design File (.ROD file) and the report data comes from Siebel in pre-built report objects (Business Objects, Business Components etc.). In Oracle BI Publisher the data model and the layout are separate entities, therefore, the Actuate Reports Conversion Assistant can assist with part of the reports conversion process.




Actuate Reports Conversion Assistant
Actuate Reports Conversion Assistant is a command line utility that converts the Actuate layout design into BI Publisher layout design. It takes the .BAS file as input that is generated by Actuate Design File (.ROD) during compilation. The conversion tool reads the .BAS file and generates an RTF template for BI Publisher.
Prerequisites

1. Windows OS environment
2. JRE 1.5 or above installed in the machine and this should be set in the Windows path environment variable. To verify the version of java in the machine, type the following in a command prompt:
Java -version



3. If the Java version is lower than 1.5 then you must change the path at the command prompt to the higher version:
Set path = [enter the path to a higher version of Java.exe]; %path%
Note: The complete install of Oracle BI Publisher 10.1.3.4 includes a JDK 1.5 installation.
Steps to Convert Report Layout


1. Extract the files from ActuateConversionAssistant_v1.00.zip to a suitable location



2. From a Windows command prompt navigate to the extracted locations and the ‘scripts’ folder.




3. Type "run" to start the conversion. The run command can have the following options:
run –i -o -l
Option -i is a mandatory switch, -o and -l are optional and will default to the input bas file location. [-i , -o , -l] can be a file name or a folder location (for multiple report conversion) To convert multiple reports at a time, run the following command run –i basFile_path -o RTFfile_path This will read all the files in the basFile_path location and put the generated files with corresponding names in the RTFfile_path location. By default a log file is created at location RTFfile_path.


4. Review the BI Publisher rtf template and log file created. If the log file indicates any function that could not be handled then inspect the RTF template in the BI Publisher Word Add-In. In the Template Builder, open the Field Browser under the Tools menu. Look for the label mentioned in the log file and the corresponding data commented out with in tags . These are copied functions or expressions from Actuate. These need to be converted into BI Publisher syntax to handle the function or expression. If the log file indicates failure to convert any Actuate Report object, then you will have to manually add the equivalent report object in the RTF template.



5. Using a sample XML data for the report, preview the report output while you are using the Template Builder. Make modifications as necessary to match the look and feel of the report layout.

6. Deploy the RTF template to Oracle BI Publisher Server.





OBI Publisher Reports
Following are the steps to generate a simple report in Siebel with the help of OBI Publisher which is a new feature in Version 8.1.1.
1. Create a new integration object using Siebel Tools
2. Create XML data using the Sample Data File Generation view in the Siebel client.
3. Create a new report template or modify an existing report template using Oracle BI Publisher Desktop.
4. Register the report template using the Report Template Registration view.
5. Associate the report with Siebel views.
The detailed explanation of each step is as follows:
1. Create a new Integration Object in Siebel Tools –
Integration Object is a logical representation of external application data, or of Siebel data that needs to map to an external application. You can either create an Integration object through New Object wizard or by directly creating a new record at object level.















Compile the Integration object into srf.

2. Create sample XML file-
After creating the Integration object, we have to create a sample xml file which is our data source. Log into Siebel Application. Go to Administration – BIP Reports -> Sample Data File Generation view .Query for the Integration object created and click on Generate sample XML button.


Once the sample xml file is created, we have to save it in Client root->XMLP->DATA folder.



3. Create a Report template-
Now that we have the xml data source, we have to develop a template file on which we want to see the Report. Open a word document (considering that OBI Publisher desktop is installed).Go to Data -> Load xml. Choose the xml file generated and load it to the template.




Now that we have loaded the data, we have to insert fields. Go to Insert ->Choose Field if we want add a few fields only .Choose table to insert a table or Form or Free form.














You can also give headings and attach logos to your report template.
Select Tools->Field Browser. Dialog box opens which shows the template logic and allows us to change it.


Go to Preview->Choose in which format you want to preview the report. This allows us to preview the report.


A pop up will come asking to save the file in rtf extension.Click Yes and save the file in Client root\XMLP\TEMPLATES folder.

Now you can preview the report in any format.
Go to Tools -> Validate Template. This will validate the template which is created.



4. Register the report template using the Report Template Registration view.

Log into Application Administration – BIP Reports -> Report Template Registration view. Create a new record. Give the name of your report as you want to see it in Application. Give the rtf template name and output type. Go to Report Template Integration Object and add the Integration object you created.

Save the record.
Click on Generate Xliff button. This will generate the .xsl file(localization file) in Client Root\XMLP\Template Folder.


XML, XLIFF, and XSL template are given as input to the XDO classes for generating the report.
5. View Association-
Associate the report to views on which you want to generate report. Go to Administration- BIP Reports -> View Association. Query for the view. On report list applet, add the report name and save.

6. Now that the configuration is over. You can go to the specific view and click on Reports icon.

Under BIP, You can the report name which you created. Click on that. A window will open which will ask the output type. Select the output type and click on Submit. You can view the report in template which you have created.





















Deploying BI Reports for Mobile Clients
--add the xmlp resp. to user
--Copy files to client installed dir (Data,rtf,xsl.xlf
)

Siebel Upgrade from 7.8 to 8.1

1 In-Scope

• Setup of the Development Environment
• Changes to the User Interface, Scripts, and Data Models
• Validation of Workflows, which include Business Services
• Impact Analysis for all interfaces after the upgrade to Siebel 8.1.1. Only the Impact Analysis - Interfaces report will be prepared
• Unit Testing of the User Interface. This will include script validation
• Tracking and resolution of defects and issues
• Functionality testing for 500 test cases for the web client. Only existing test cases will be used
• Install OBI server and configure to Siebel 8.1.1 development upgrade environment
• Analysis of the vanilla Siebel 8.1.1 reports. Configure those that closely matches the existing Siebel 7.8 vanilla reports
• Configure all reports with minimal configuration in terms of additional labels changes and fields
• Prepare a report for all the customized/Complex reports that can not be configured before end of this project

2.2 Out of Scope

• End to end testing of all interfaces
• Development of any Interfaces integrated with Siebel 7.8 after upgrade to Siebel 8.1
• Setup and validation of interfaces (if required) for successful execution of test cases
• Development of the Customized/Complex BI reports which can not be configured before end of the project
• Test environment setup, system integration testing and UAT
• Remote user testing
• Performance testing

Interface Impact Analysis Report of Siebel 8.1.1

1.OVERVIEW:


To identify the impact of this upgrade on the existing Siebel7.8 interfaces, detailed impact analysis is performed. This document covers the interface impacts identified and discuss the proposed solutions.

2.SCOPE:

Analyzed the existing Interfaces in Siebel 7.8 Application to identify

1.Architectural and supported platforms impact on Interfaces
2.Upgrade impact on Siebel interface objects(IOs, Workflows, Scripts..etc)
3.External Application Impact


3.REFERENCE DOCUMENTS AND ARTIFACTS:

•http://w76162.usac.mmm.com/CRMA/index.html
•System Requirement Specifications guide of 7.8, 8.1
•Siebel 7.8 application and Tools Repository


4.ARCHITECTURAL IMPACTS:

All real time interfaces in Siebel 7.8 application are using IBM MQSeries Application Messaging Interface1.2.4 (AMI) transport

Oracle stopped supporting AMI transport starting Siebel7.8 onwards. Some customers got it working on 7.8 as the transport business service was still available at the repository but they did so at their own risk.

There was no formal support for AMI at 7.8 and the transport has not been maintained or enhanced since 7.7

Hence, we will not be able to continue with AMI transport in Siebel 8.1 application.

Supporting Documentation:

https://support.oracle.com/CSP/ui/flash.html#tab=Dashboard(page=Dashboard&id=g2ta6nki()),(page=SRView&id=g2tbb3om(sr_stmt=Does%20the%20EAI%20MQSeries%20AMI%20Transport%20work%20in%208.1.1%20and%20if%20yes,%20will%20it%20gets%20su...&&sr_number=3-1167762381&sr_row_id=3-JB977X))

https://metalink3.oracle.com/od/faces/secure/km/DocumentDisplay.jspx?id=477793.1

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=498587.1

4.1 Available Solutions:

The below are the 3 supported Interfaces as alternatives for latest version of Siebel application.


1. EAI JMS Transport

2. EAI MQ Series Server Transport

3. Other Transports



EAI JMS Transport

MQ can be configured to act as a JMS server and siebel can access a remote MQ+JMS server. However, all applications exchanging messages with siebel need to use JMS methods to put or read messages to the MQ queue. The reason is a "pure" MQ message lacks headers and other information a JMS message has. As a result, a message put by a 3rd party application into an MQ queue NOT using JMS methods would NOT be readable by Siebel.


The reverse is also true. A JMS message put at an MQ queue by Siebel using JMS methods would not be readable by applications not using JMS methods to read it.
It means you have to re-design the 3rd party applications to use JMS too.


EAI MQ Series Server Transport


If EAI MQ Series Server Transport is used siebel server that interacts with MQ , a whole MQ server needs to be installed at the same machine.
Unlike AMI, you can not access a remote MQ queue with this transport.
The MQ server has to be at the same box as the siebel server.
This may have an impact on MQ licenses as you may have to license multiple MQ servers.


Other Transports


EAI allows other transports such as EAI HTTP Transport, EAI File Transport, and even custom transports (custom business services you code yourself) but they are not standard QUEUE transports. They do not provide the same guarantees and features as a queue transport.

4.3 Impact to Siebel:

• Software Installation

Software’s to be installed on Windows Servers where Workflow Process Manager Siebel Server component operates.

1. IBM Websphere MQ Client Version 6.0.2.2
2. Java Virtual Machine

Download ms0n.zip, ms0B.zip, me01.zip from IBM support site. Extract the files to JMS\GUITool


•Setting up the JVM Receiver Component Parameter & Subsystem

Need to setup JMS Receiver Component Parameters in Enterprise Servers – Component Definitions

Setting up the JVM Subsystem Types
Need to specify the required parameters like JVM Subsystem name
ReceiveQueue name



Impact to MW & Other applications:

1. Middleware Queue Type needs to be modified in accordance with JMS Transport
2. Chances of discrepancy of JMS Headers with the Middleware and External Applications
3. If JMS transport communication port is not open, enable the ports
4. Middleware team has to investigate for further Impact while migrating from AMI Transport to JMS Transport


Configuration Impacts:

1. Need to make use of EAI JMS Transport instead of EAI MQSeries AMI Transport
2. Slight modification with the default branches in the workflows
3. Some of the Upgrade workflow issues needs to addressed
4. Integration Object Issues
5. Unit test all the interfaces and fix the issues

Out of Scope

• End to end testing of Interfaces in 7.8

• Testing of Interfaces that does not have sufficient details and XML files

• Development of any Interfaces integrated with Siebel 7.8 after upgrade to Siebel 8.1

• Setup and validation of interfaces (if required) for successful execution of test cases

Most Read Blog on global n/w

http://www.thecompulsiveconfessor.blogspot.com/

JMS Transport

JMS Setup

1) Downloaded ms0n.zip, ms0B.zip, me01.zip and ms0n.tar from IBM support site.


2) Extracted the zip files to the location F:\JMS\GUITool

com.ibm.mq.pcf-6.1.jar
jmsadmingui.jar
mqcontext.jar
jmsadmingui.bat

Note: The above mentioned files were created in this folder.

3) Created jndi.properties.txt in F:\JMS\JNDI

java.naming.factory.initial=com.sun.jndi.fscontext.RefFSContextFactory java.naming.provider.url=file:/ F:\JMS\JNDI

4) Set the correct path settings in jmsadmingui.bat file

Go to F:\JMS\GUITool and edit the jmsadmingui.bat file and set the
• current directory (CUR)
• MQJ
• PATH
• CLASSPATH.

Note: In the CLASSPATH specify all the jar files that were extracted from zip files and jar files located in the C:\PrograFiles\IBM\WebSphere MQ\Java\lib.

5) Modified the JMSAdmin.config file

Navigate to C:\Program Files\ibm\WebSphere MQ\Java\bin under MQSeries installation. Edit JMSAdmin.config file and perform the following modifications



• INITIAL_CONTEXT_FACTORY=com.sun.jndi.fscontext.RefFSContextFactory
• PROVIDER_URL=file:/F:\JMS\GUITool


Details to be filled by the Middleware team:


Step 1: Run (jmsadmingui.bat) Batch File

Go to F:\JMS\GUITool\ jmsadmingui.bat

Step 2: Select the JMSAdmin.config file in the GUI Tool.

C:\Program Files\IBM\WebSphere MQ\Java\bin\ JMSAdmin.config

Sept 3: Specify the file path

file:/F:\JMS\GUITool


Example Queue Creation

Example ConnectionFactory Creation

Save it and make sure .bindings files gets created under F:\JMS\GUITool

JVM Subsystem Setup


The following steps can be used to create the JVM subsystem using the Siebel WebClient


1. Start any Siebel Business Application and navigate to Site Map → Administration → Server Configuration → Enterprises.

2. In the top list applet, select the Enterprise Server that you want to configure.

3. In the middle applet, click the Profile Configuration tab.

4. Click New to create a new component profile and set the following parameters:

 Profile = JAVA
 Alias = JAVA
 Subsystem Type = JVMSubsys

5. In the Profile Parameters list applet (the bottom applet), set the following values:

a) Set the Value of the JVM Classpath parameter to contain the following:

• The location of the JNDI.properties
• The JMS provider JAR files.
• The Siebel.jar and SiebelJI_lang.jar files.

E:\seaNAM811DEV\siebsrvr\CLASSES\ SiebelJI_enu.jar
E:\seaNAM811DEV\siebsrvr\CLASSES\ Siebel.jar

b) Set the Value of the JVM DLL Name parameter to the path where you have the jvm.dll file installed. For example,

C:\Program Files\Java\j2re1.4.2_16\bin\client \jvm.dll

c) Set the Value of the JVM Options record to any JVM-specific options that you would like to enable. For example,

-Xrs -Djava.compiler=NONE

JMS Sub System Setup:

The following procedure can be used for creating the JMS Transport subsystem using the Siebel Web Client.

1. Start any Siebel Business Application and navigate to Administration → Server Configuration → Enterprises.

2. In the top list applet, select the desired Enterprise Server that you want to configure.

3. In the middle applet, click the Profile Configuration tab.

4. Click New to create a new component profile and set the following parameters:

 Profile = M3-HISD-SOFTRAX
 Alias = M3-HISD-SOFTRAX
 Subsystem Type = JMSSubsys

5. In the Profile Parameters list applet (the bottom applet), specify the following parameters

• ConnectionFactory name =com.ibm.mq.jms.MQQueueConnectionFactory
• JVM Subsystem name = JAVA
• ReceiveQueue name =
• Receive Timeout = 20000



Data Handling Sub system Setup:

To create a JMS Receiver subsystem using the Siebel Web Client a user should follow the steps below:

1. Start any Siebel Business Application and navigate to Administration → Server Configuration → Enterprises.

2. In the top list applet, select the desired Enterprise Server.

3. In the middle applet, click the Profile Configuration tab.

4. Click New to create a new component profile and set the following parameters:

 Profile = M3-HISD-SOFTRAX-DHSS
 Alias = M3-HISD-SOFTRAX-DH
 Subsystem Type = EAITransportDataHandlingSubsys

5. In the Profile Parameters list applet (the bottom applet), specify the following parameters

 Workflow Process to Execute = M3 HISD-Softrax RECV WF


Listener Component Setup:


1. Start any Siebel Business Application and navigate to Administration → Server Configuration → Enterprises.

2. In the top list applet, select the desired Enterprise Server.

 Component = M3 HISD-Softrax Integration
 Component Type = Enterprise Application Integration Receiver


3. Component Parameters Applet

 Receiver Service Name = EAI JMS Transport
 EAI JMS Transport = ReceiveDispatch
 Receiver Connection Subsystem = M3-HISD-SOFTRAX
 Receiver Data Handling Subsyst = M3-HISD-SOFTRAX-DH

'Sneha Geetam' Review: Youthful, Lively And Contemporary

Note: Since my friends and collegues are directly involved with Sneha Geetham's cast and crew, I have outsourced the services of film critic Lakshmi Naidu who is working with a news agency which is no way connected to greatandhra.com - Venkat Arikatla, Chief Editor

Film: Sneha Geetam
Rating: 3.25/5
Presented By:
Lagadapati Sridhar
Banner: Larsco Entertainment
Cast: Venky, Shreya Dhawanthary, Sandeep, Suhani, Chaitanya, Riya, Vennela Kishore, Melkote, Shruthi, Krishnudu, ARC Babu, VB Rao etc
Music: Sunil Kashyap
Lyrics: SiraSri, Chinni Charan
Editing: Lokesh
Digital Editor: Anirudra
Cinematography: PG Vinda
Screenplay, Dialogue: Madhura Sridhar, Mohan Bharadwaj
Story, Direction: ‘Madhura’ Sreedhar
Producer: Lagadapati Sirisha Sridhar
Released On: Jul 16th, 2010

A youthful movie with title ‘Sneha Geetham’ has arrived today. The faces are new, the director is new and obviously it carries no big expectation. But the hype created for this film has pulled me to watch it. Let us see if the material in this film is in tune with the hype or not.

Story:
This is the story of three young boys Ravi (Venky), Krishna (Chaitanya) and Arjun (Sandeep) who complete their graduation in engineering and want to be an entrepreneur, a SW employee and a film director respectively. Their love interests happen to be Shailu (Shreya Dhanwanthary), Pooja (Riya) and Maha (Suhani) respectively. How these guys achieve their dreams crossing the barriers, form the story. Just watch it on big screen and I’m sure it makes you elated.

Performances:
Venky has got the class elegance. He delivered matured performance. He has bright future as multiplex hero in the lines of Siddhartha.

Sandeep is rugged and has mass appeal. He can do well if takes care in choosing right scripts those suit his serious body language. His voice has good base which is an advantage.

Chaitanya, the wonderful dancer among young folks has a happy going face and he can be a family entertainer down the line.

Shreya Dhanwanthary gave apt performance while Riya also did well without any complaint. Suhani should be appreciated for own dubbing. She is perfect and cute.

Lohit Kumar has got a catchy role. He portrayed the role of perverted Software Manager trying to woo a heroine. He has the material to become best villain in Tollywood.

Arun, ARC Babu and VB Rao made presence felt as fathers.

Krishnudu delivered humorous and touching performance as Pitamaha. Vennela Kishore delivered right comedy as Box Office Bhushanam (recalling Tanikella Bharani in ‘Money Money’). Shruthi scores well as mother while ARC Babu is matured and serious in performance with echoing voice. Venu Madhav’s AIDS Papa Rao track is rib-tickling. Others are ok.

Music by Sunil Kashyap scores highest mark while Sirasri and Chinni Charan have given appropriate lyrics. Cinematography by PG Vinda is honest.

The debutant director ‘Madhura’ Sreedhar has done a fabulous job as an experienced director with huge stuff. He proves to be a promising director for Tollywood.

Production values by Lagadapati Sridhar are awesome and his publicity really helped this good movie reach majorities. Kudos should laurel him for bestowing such a meaningful movie to society.

Music:

  • 'Oka Snehame' written by SiraSri is instant winner and the tune haunts
  • 'Veyo Veyo' of SiraSri has got peppy features in it and the choreography is impressive
  • 'Farewell Song' penned by SiraSri is sounding novel all the way and its pictured as celebration
  • 'Sarigama Padani' written by Chinni Charan turned out to the best melody

Highlights:
Music
Lyrics
Storyline
Dialogues
Direction
Debutant Heroes and heroines with great performances
Songs picturization

Side Lights:
VV Vinayak gave his voice over at the outset
Producer Lagadapati Sridhar appears in real-time character

Disappointments:
Costumes of heroines could have been better. They are realistic but not pleasing.
Editing is sharp and for this sort of movies it could have been focused on mood
Director’s amateurism is seen in composition of a few scenes

Analysis:
You might have watched romantic films, action films, comedy films and educating films…Have you ever heard of ‘helpful film’? Here it is..It is helpful for entire family members…See how it helps…

  • Are you the father of a young boy or girl who completed studies and about to settle down in life? Watch this movie to know their true emotions? You may take a right decision that definitely helps them…
  • Are you the son of a perfectionist father who speaks on practical lines but not understanding your passion? Watch this so that you can know the better way to communicate your ideas to your father. It really helps you…
  • Are you in love with your class mate at present? Watch this to know when to propose and how to propose. You may end up with wedding without any hassle. It certainly helps you…
  • Are you an aspiring entrepreneur but there is none to support you financially? Watch this to find a right solution to know the way to project yourself…It surely helps you…
  • Are you an aspiring film director and completed your studies? Watch this to know darker and brighter sides of film industry. It perfectly helps you…

It’s a pleasant, heart touching, thought provoking, sincere and worthy movie that shouldn’t be missed by any family member. Responsibility is shown in all perspectives- from the side of father, from mother and from grown up children. Love is justified in either ways- from the boy and from the girl.

The film aptly describes the phase between ‘after the completion of degree and before getting settled in life’ with 3 pairs. On a whole, the majority of entire student community fits into these 3 sets. Debutant director should be appreciated for giving out such a matured and highly convincing product. There are no chasings, no beating around the bushes, no artificial scenes, no violence and there is just one thing in the film- that is ‘reality’. ‘Sneha Geetam’ opens a new genre all together- a sincere voyage with less cinematic liberties and more honest features. Humor is not missed and there is adequate. Emotions of all categories are well carried till the end.

First half goes with bits and phases of college life style while second half screens the real material. The last 30 minutes prove to be the highlight.

Bottom Line: Must-watch by every family member

Reviewed by Lakshmi (Lakshmi can be reached at lakshminaidu1981@gmail.com)

స్నేహగీతం-4/5-A must watch

స్నేహగీతం-4/5-A must watch


ఎప్పుడో రెండేళ్ళ క్రితం అనౌన్స్ అయ్యి అప్పటినుంచీ అప్పుడూ ఇప్పుడూ అంటూ అసలు విడుదలవుతుందో లేదో అనే అనుమానం వచ్చేలా డేట్ మీద డేట్ postpone చేసుకుంటూ మొత్తానికి ఈ రోజు విడుదలవుతున్న స్నేహగీతం సినిమా గురించి వివరంగా చెప్పాలన్నా పూర్తిగా విశ్లేశించాలన్నా ఇంకా కొంత సమయం కావాలి. ప్రస్తుతానికయితే స్నేహగీతం ట్రాన్స్ లో రాస్తున్న ఒక పరిచయం లేదా రికమెండేషన్ అనుకోవచ్చు.

ఒక్క మాటలో చెప్పేయ్యాలంటే స్నేహగీతం is worth your money and time. Go and watch it.

సాధారణంగా బాగా చదువుకుని ప్రపంచం చూసి సినిమా అంటే ప్యాశన్ తో ఈ మధ్యకాలంలో వచ్చిన ఎంతో మంది యువదర్శకులు తమ మొదటి సినిమాగా ఒక యువతీయువకుల బృందం చుట్టూ కాలేజి నేపథ్యంలో తిరిగే కథలను (Thanks to happy days) ఎన్నుకోవడం మనం చూస్తూనే ఉన్నాం. హ్యపీడేస్ తర్వాత ఇలాంటి సినిమాలు వచ్చాయి. ఇక ముందు కూడా ఇలాంటివి రావొచ్చు. స్నేహగీతం కూడా ఈ వెల్లువలో వచ్చి కొట్టుకుపోయే సినిమా ఏమో అనుకున్నా కానీ అలా అనుకునే వారి అభిప్రాయం తప్పని నిరూపించారు శ్రీధర్స్ ఆఫ్ స్నేహగీతం.

కథగా చెప్పాల్సి వస్తే స్నేహగీతం ఆరుగురు మిత్రుల కథ. మొదట కాలేజిలో ఆ తర్వాత కాలేజ్ బయట వారి జీవితాలు, వారిaspirations, dreams, goals, మధ్యలో కాస్త ప్రేమ, కాస్త fun, మధ్యలో కొన్ని కష్టాలు చివరికి సుఖాంతమైన జీవితాలు. ఇంకా చెప్పాలంటే It’s a realistic journey through the lives of realistic characters who talk and behave like us.

ఈ సినిమా గురించి చెప్పుకోవాల్సిన విషయాలు చాలానే ఉన్నాయి. కానీ ఆ విషయాలన్నీ చెప్పేస్తే సినిమాలోని ఆసక్తికరమైన అంశాలను రివీల్ చెయ్యాల్సి వస్తుంది కాబట్టి ఆ పని ఇంకొన్ని రోజులకి వాయిదా వేస్తున్నాను. ప్రస్తుతానికి ఆ సినిమా గురించి మాట్లాడాలంటే superlatives ద్వారానే చెప్పగలను.

ముందుగా స్నేహగీతం అనే సినిమా ద్వారా “The Sridhars (లగడపాటి మరియు మధుర) have pulled of a rare feat” అని చెప్పొచ్చు. ఎందుకంటున్నానంటే ఈ సినిమా దాదాపు అందరూ కొత్తవాళ్ళతో తీసినా ఎక్కడా యాక్టింగ్ లో ఆర్టిఫిషియాలిటీ కనిపించదు. ఆ విధంగా casting పరంగా ఇదొక rare feat అని చెప్పొచ్చు. ప్రతీ సినిమాలోనూ చూసిన మొహాలే చూసి బోర్ కొట్టేసిన తరుణంలో ఎంతో ఈజ్ తో కొత్తవాళ్ళతో performance రాబట్టుకోవడం ఒక అద్భుతమనే చెప్పాలి.

Snehageetham is also a film that speaks to the new generation. ఇంతవరకూ ఎన్ని యూత్ ఫిలింస్ వచ్చినా స్నేహగీతంలోలా ఒక generation యొక్క డ్రీమ్స్, aspirations, confusion లాంటి అంశాలను సరిగ్గా డీల్ చేసిన సినిమా ఒక్కటీ రాలేదు. ఇందులో నటించిన నటీ నటులు మన మధ్యలో ఒకరిగా అనిపిస్తారు. అందంగా ప్లాస్టిక్ స్మైల్స్ ఉన్న అమ్మాయిలు అసలే లేరు. ఉన్న ముగ్గురమ్మాయిలూ ఎంతో న్యాచురల్ గా ఉన్నారు. కొంచెం కామిక్ టచ్ ఉన్న పాత్రలో నటించిన సౌమ్య కూడా మనం రోజూ చూసే అమ్మాయిలానే ఉంటుంది, అలాగే అబ్బాయిలు కూడా…వారిలో ఒక rawness కనిపిస్తుంది. This really added to the realistic feel of the film.

Snehageetham is a film with all the emotions blended very smoothly and it definitely caters to all the classes of audience. సినిమా మొత్తం ఎంతో lighter vein లో నడుస్తుంది. అయినా కూడా సరైన సమయంలో సరైన చోట emotions ఒక పీక్ కి చేరుకునేలా చేసి సినిమా అద్యంతం ప్రేక్షకులకు బోర్ కొట్టకుండా చేయడంలో దర్శకుడు సఫలమయ్యాడు. ముఖ్యంగా ద్వీతియార్థంలో pace చాలా బావుంది.

Snehageetham makes you laugh and at times it also makes you cry. All in all it entertains and at times enlightens you.

ఇంకా చెప్పాలంటే
1) దర్శకుడు కథను ఎక్కడా డైవర్ట్ చెయ్యకుండా to the point ఉండేలా care తీసుకున్న తీరు
2) సినిమాలో ముఖ్ భూమికలు పోషించిన ఐదు మంది కథలనూ ఎంతో బాగా బ్యాలెన్స్ చేసుకుంటూ వచ్చిన విధానం
3) ఈ సినిమా సందేశాత్మక చిత్రం అని అనిపించినా ఎక్కడా పెద్దగా preachy గా అనిపించకపోవడం
4) సంగీతం
5) ఎడిటింగ్

లాంటి ఎన్నో అంశాల కారణంగా ఈ సినిమాని నేనైతే Must Watch సినిమాగా రికమెండ్ చేస్తున్నాను.

స్నేహగీతం లాంటి సినిమాని చూసి ఆదరించండి.తెలిసిన స్టార్స్ లేరనో, చిన్న సినిమా అనో, పైరేటెడ్ డివిడి వస్తే చూద్దామనో, ఆన్ లైన్లో వస్తుందనో ఇంకా పోతే టివిలో వస్తుంది కదా అనో ఈ సినిమా ని థియేటర్లలో చూడడానికి ప్రేక్షకులు రాకపోతే మంచి తెలుగు సినిమాలు అసలు రాకుండా పోతాయి. మంచి సినిమాని ఆదరించండి. స్నేహగీతం చూడండి. మీ ఇంటిల్లపాదీ హాయిగా చూడదగ్గ సినిమా….మీరూ చూడండి మరింత మందికి చూపించండి. ముఖ్యంగా సినిమాలో లీడ్ రోల్స్ లో నటించిన యువతీ యువకులు కాకుండా క్యారెక్టర్ ఆర్టిస్టులు ఎంతో మంది కొత్త వారిని ఈ సినిమాలో పరిచయం చేశారు. వేణు మాధవ్, వెన్నెల కిషోర్ లాంటి ఒకరిద్దరు తప్పితే సినిమా మొత్తం కొత్త వాళ్ళే….మీరీ సినిమాని థియేటర్లలో చూసి విజయవంతం చేసి వారందరికీ మీ ఆదరాభిమానాలు అందచేయాలని కోరుకుంటూ శెలవు తీసుకుంటున్నాను.