Create Groups and Users in Central Management Console (CMC) in BusinessObjects 4.0

How to video for Central Management Console (CMC) in BusinessObjects 4.0.
This video will show you how to:
- Navigate Business Objects 4.0 Central Management Console
- Create a Group, Sub Group, & User
- Add a Group in CMC Group Hierarchy
- Add a Sub Group to an existing Group
- Add a User to a Sub Group
- Delete a Group, Sub Group, & User

How to Create Pivot Table Excel 2007 Video

Creating a Pivot Table in Excel is a crucial part of data management int he Microsoft Suite. Pivot Tables are normally relied on by Power Users with in companies or advanced Excel employees. Creating a Pivot Table in Excel 2007 is different from creating one in Excel 97 – Excel 2003. The Pivot Table creation button is in a totally different location in the Excel Header.

Installing a Connection inside Business Object Designer – A How To Business Objects Tutorial

The Business Object Designer Connection Set-up video is the second video in a series of 3 Business Objects Training Videos and includes a Business Objects Set-Up PowerPoint overview. The first Business Objects video showed how to create an ODBC Connection for Business Objects to connect to.This Business Objects video shows how to create a connection inside Business Objects Designer. In this case the database connection is for an ODBC connection which was created through Microsoft Access, but the ODBC could have been from any source. The final goal will be to create a Business Objects Universe and this step will be posted in the near future. This YouTube video contains a Basic Visio Work Flow which will prove useful for any beginner Business Objects Users to be able to understand the database steps needed when first learning the  Business Objects Reporting Suite. The Business Objects process flow includes steps like Business Objects installation, establishing Power Users buy-in,creating Business Objects connections, creating Business Object Universe, and distributing and creating final Business Objects Reports.

Learning Business Objects – How to Create ODBC Connection for BO Universe

This Business Objects video shows how to create an ODBC connection to be able to connect and create a Business Objects Universe. The video also contains a workflow for beginner Business Objects Users on the entire process of setting up Business Objects. From Business Objects installation, establishing Power Users buy-in,creating Business Objects connections, creating Business Object Universe, and distributing and creating final Business Objects Reports. This video is the first series to the Business Objects PowerPoint overview.

7 Steps to Properly Upload Data into SAP

SAP has been growing in popularity for almost all kinds of business and industries. This is due to the fact that SAP has been the service provider for many companies’ data and software management. More specifically, SAP Business Objects is a portfolio of applications and software tools that are specifically designed to help and maximize business performance by centralizing information and business processes and making them available for various networks in the company.

However, many small and big corporations are still using Excel Worksheets to store their corporate data. It takes so much time, energy and resources for these IT personnel to manually input the data into SAP. Manual re-entry causes errors that can cause inconvenience and inaccurate reports for those who will need the information. The operations and administrative personnel of these IT departments are constantly bombarded by requests from the other departments to upload their own Excel spreadsheets into SAP.

This article will discuss the automation processes of uploading Excel worksheets into SAP. This will benefit IT specialists who are required to do the following tasks: to stop or at least reduce the manual entry of data during upload sessions to SAP, to look for more effective and faster means to provide data to users, and to help the company save resources when using SAP as the central data management system.

Tip No. 1: There is no need for programming. This can only mean more expense for the company especially if you are only going to use the software once a year. One can opt to use these SAP-provided tools: CATT, BDC, LSMW or third-party software tools like Winshuttle’s TxShuttle.

Tip No. 2: Spreadsheets should not be uploaded directly into existing SAP tables. You can use the above-mentioned SAP tools and Winshuttle instead. Uploading directly to SAP tables negates all the validation processes when you create data during everyday SAP transactions.

Tip No.3: Use the record-map-run strategy. This three-step method is your guide to uploading Excel spreadsheet data into SAP. Using the same tools mentioned in tip number one will make this strategy work. First, a recording will occur during a SAP transaction wherein data will be uploaded into the system. Next, a mapping step will happen wherein all the SAP data fields are mapped into specific and corresponding Excel fields. Then, the system will run all the needed processes to transfer the data needed to be uploaded.

Tip No. 4: Always have a check and balance method so that the company will provide specific access rights to different employees instead of having only one IT specialist maintaining all SAP transactions.

Tip No. 5: Keep your information in basic Microsoft Excel format. This will make the upload process faster and simpler. Again, you can use Winshuttle’s TxShuttle.

Tip No. 6: Use the outside-in approach wherein the tools not included by SAP are used to bring in outside information into the system rather than the other way around.

Tip No. 7: Provide adequate training to all frequent users of SAP. These users should be able to know how to do the uploading by themselves without any assistance from the IT department. This will enable the IT personnel to be more efficient in their various roles and responsibilities. SAP also has SDN which means SAP Developer Network. This is the online community for SAP users and developers. They have forums and sharing portals wherein they can discuss and share various information, techniques and basically tricks and tips that are needed by using SAP anywhere in the world.

For small and medium enterprises, SAP Business One is the recommended software for important resource planning. With larger enterprises, there is SAP NetWeaver Business Warehouse. The users will benefit from the informative search features in this system.

Lastly, for those companies in need of specially designed reports for frequent use, there is such a thing as Crystal Reports. Crystal Reports is a powerful software that has interactive reports that can be connected to any data source. This software includes Xcelsius Engage which is helpful for those who require forecasting-based information.

Chief Technology Counsel Services Benefits

Maximizing Technology Benefits: The Advantage of Chief Technology Counsel

The world of commerce has evolved in the past decade due to the invention of the internet and the advantages that it brings. However, taking advantage of all these technological innovations is not that easy. The use of technology can be tricky, even scary for some people. Thus, the need for chief technology counsel services becomes even more important as we advance.

What are the advantages of Chief Technology Counsel Services?

The main advantage of Chief Technology Counsel Services can be summarized into 3 major points: Facility, Cost Effectiveness, and Productivity.


Business owners and leaders are experts in their field—that is thinking of ways to maximize profit and attain operational excellence. But knowing how to facilitate transactions and operation through the use of technology is another thing. CTC technology experts provide great support to the business experts by showing how technology can further help in the growth of the business or in facilitating operational transactions.

Chief technology counsel likewise eliminates the need for creating an in-house team to address operational issues related to technology. This way, employees and officers can focus on their strengths and will not be bogged down by concerns that technology experts can solve immediately with the use of minimal resource.

The set-up can be a win-win situation for everyone—the business owners, corporate officers, and employees, and even the technology counsel because of the facility and ease of the transactions using and maximizing technological tools.
Cost Effectiveness:

Ever heard of organizations spending on high-tech equipment to help them in their operations but failed on implementation? This happens when there is no fit between the tool and the persons expected to execute the program. Most of the time, it is better to leave the technology-related part of the program to the experts-such as the Chief technology counsel.

CTC services, more or less fall under the following six business practices:Technology Risk, Management & Support, Business Continuity Planning & Support, Information Assurance, On-Demand Services, Managed Services and Enterprise Content Management (ECM). Definitely, you will find a CTC expert that can respond to your need in any of these arrangements or practices.

In addition, since most small and medium-sized businesses cannot afford to have their own Management Information Systems (MIS) or Technology departments, the chief technology counsel services offer the benefits of having a technology adviser without much expense.


With the business owners and operations people concentrated on maximizing profits and ensuring operational excellence, productivity comes out as a logical result. Also, with the experts’ know-how, the trial and error system is avoided and efficiency is realized. Chief technology counsel indeed is a wise investment for any business.

Business Data Analysis : Comparing Data Populations with SQL

While dealing with business data you will often times need to validated various database populations with one another. The comparison queries below are simplistic in nature but can be used in a host of business questions, solutions and resolutions. The SQL queries check and see if a record is in one population and not the other. Below is a set of three SQL business queries which use a standard join, left join, and right join which compares two populations against each other.

Business Scenario: A company has a set of loans which it needs to have evaluated by a third party. The company has 1000 loan records in their database. They have received back 975 records. The goal is to research the returned loan population from the third party evaluation company.

Individual SQL Count Query: It will be important to document how many loans are in each data population. In this business scenario, the original population results in 1000 loans and the returned population has 975 loans.

Individual SQL Count Query Example:

select count(loan_num) from original_loan_pop

select count(loan_num) from returned_loan_pop

SQL Straight Join Query: This business related query checks to see which records are in both populations. In the business scenario, the query returns 970 records. This means of the 1000 loans sent to be evaluated, only 970 loans were sent back correctly from the original population.

SQL Straight Join Query Example:

Select * from
(select * from original_loan_pop)a
(select * from returned_loan_pop)b
on a.loan_num = b.loan_num

SQL Left Join Query with Criteria: This query looks to see which loans are in the original table, but are not in the returned table. The query in this example returns 30 loans.  This mean of the 1000 loans sent to be evaluated, 30 loans from the original population were not included.

SQL Left Join Query Example:

Select * from
(select * from original_loan_pop)a
left join
(select * from returned_loan_pop)b
on a.loan_num = b.loan_num
where b.loan_num is null

SQL Right Join Query with Criteria: This query looks to see which loans are in the returned table table, but are not in the original table. The query in this example returns 5 loans.  The results of this query mean the company who provided back the evaluated loan information some how added 5 loans that were not even included in the original 100o loan data set.

SQL Right Join Query Example:

Select * from
(select * from original_loan_pop)a
right join
(select * from returned_loan_pop)b
on a.loan_num = b.loan_num
where b.loan_num is null

Final Results and Findings: Based on the results of the data analysis above, a data analyst or business analysis could conclude that the data returned by the loan evaluation company is incomplete with data inconsistencies. Of the original 1000 loans only 970 were returned correctly, with 30 loans missing. More concerning, there were 5 loans returned which did not even exist in the companies original loan set.

Article by Brady Smith

iovation Adds Max Anhoury to Executive Team

PORTLAND, Ore., BUSINESS WIRE -- iovation, the Device Reputation Authority' for the Internet, today announced a new executive appointment.

27.NOV.08 Symposium Brings Together Artists, Scientists

By ARIN MIKAILIAN 27.NOV.08 It was a meeting of the technical and artistic minds as members of the entertainment industry and scientific community met in Century City Nov.

Interview- Three ways to leverage ERP during slowdown

Chennai: In what ways can enterprises leverage their ERP systems during a period of economic crisis such as what is currently experienced? When I pose this question to Mr Ranjan Das , Managing Director, SAP, ...

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027

Warning: strpos() [function.strpos]: Empty delimiter in /home/texeyes/public_html/ on line 1027