I have found this article very helpful, thought I share this with you..it will help you address some of the scalability and performance issues/concern using SSIS as ETL tool..Excellent article by Thomas Kejser and Denny Lee..
http://sqlcat.com/top10lists/archive/2008/10/01/top-10-sql-server-integration-services-best-practices.aspx
Tuesday, December 9, 2008
Tuesday, November 18, 2008
CE to XI R2 Migration Project
I am currenlty working on Crystal Enterprise Migration 8.5 to BOE XI R2. Reports being migrated have SAP, SQL Server and Oracle as datasources. SQL and SAP Reports is being migrated correctly but Oracle Report publised in new Enviroment is throwing Oracle Database Error Code 12153. Eventough investigation
revealed it had some this to do with tns host name resolution , but was thown of the track in believing because all other application could talk to this database from the same box using same clinet except reports deployed in BOE.
Things tried:
- Called BO for support refused to talk because oracle client we were using was not supported so had to install supported version but still had a same issue.
- Installed Crystal in the BOE box but ran fine but once deployed to BOE came up with same error
-Conduct tnsping test seems to resolve the host name correctly
-SQL plus is also connect to the server correclty
-Tried Oracle Native driver but still yielded same result
-Removed all the oracle client and removed all the registry entry and installed new clinet still had a same result.
Resolution:
After hours on the phone with BO finally some one pointed out Registry Entry for TNS was pointing to tns.ora file that is network sharefolder. Folder was mapped to the BOE server and for some reason it was not able to resolve host name for mapped drive. We changed path to fully qualified path and Voila reports started to work. Sweet......
revealed it had some this to do with tns host name resolution , but was thown of the track in believing because all other application could talk to this database from the same box using same clinet except reports deployed in BOE.
Things tried:
- Called BO for support refused to talk because oracle client we were using was not supported so had to install supported version but still had a same issue.
- Installed Crystal in the BOE box but ran fine but once deployed to BOE came up with same error
-Conduct tnsping test seems to resolve the host name correctly
-SQL plus is also connect to the server correclty
-Tried Oracle Native driver but still yielded same result
-Removed all the oracle client and removed all the registry entry and installed new clinet still had a same result.
Resolution:
After hours on the phone with BO finally some one pointed out Registry Entry for TNS was pointing to tns.ora file that is network sharefolder. Folder was mapped to the BOE server and for some reason it was not able to resolve host name for mapped drive. We changed path to fully qualified path and Voila reports started to work. Sweet......
Friday, October 17, 2008
All KPIs are Metrics but all Metrics are not KPIs
Metrics represent a numeric business data in relationship with one or more context or dimensions. For example “Weekly Gross Profit By Week” represents a measure across time dimension i.e Week in this case.
KPI’s are special type of Metrics. It inherits all the characteristic of metrics but in addition to that
- KPI should reflect organizational goals
- KPI should me meaningful throughout the organization
- KPI should be based on valid data
- KPI should be actionable
- KPI should be visual and easy to understand
- Most important KPI should be decided by business unit/business users
Subscribe to:
Posts (Atom)