Archive for the ‘Uncategorized’ category

What I Do

March 22nd, 2010

What we do: Some asked recently for what was going on related to our tools. Here is a summary
At a 50K foot level we have 5 tools

1) Report Launch allows you to embed Crystal and Webi reports from any application without needing the SDK.

2) Dashboard Launch (You will have to see this). Caches webi content and many other things for really fast dashboards. SAP certified too

3) Admin Launch – bleeding edge web based BOE administration tool that you can train to do what you need it to do for you (beta just started).

4) Audit Launch : Export extends BOE auditing for advanced analysis by syncing CMC attributes into an extended audit database. Audit Launch Import syncs security from 3rd party apps into BOE

5) Activity Launch – allows you to create business activity monitoring events into report schedules and trach when a batch of schedules completes so you can continue the notification or event process

All of our software is 100& web based on Java SDK so it runs on Windows, Unix, and Linux

BI Tool Selection

February 6th, 2010

When a company thinks that a BI system will benefit their ability to access and analyze data, a great door of opportunity is opened. Through that door will come many vendors and products that may or may not be a match for your company’s needs and abilities. From the beginning, the success of a system is establishing the needs or requirements and the proposed benefits to the company. Without these, every product can be made to look like it fits and is “just what you are looking for.”

One thing to keep in mind is that these requirements are going to change throughout the life cycle of the design process as requirement-gathering processes uncover additional application issues. Benefits can be directly related to monetary issues (such as cost savings though eliminating unsuccessful spending) as well as non- monetary benefits (such as reducing the time it takes to analyze the last month’s sales trends).

How then does a company choose which product is right-one that will match the current needs and also support the requirements of future applications? There are some simple processes that can help in this decision. The first is to break the requirements into their separate entities. These entities will separate the kinds of questions that need to be asked of the products you are considering and identify your expectations of the application.

The primary classifications are simply by data related issues and by application functionality. While other factors exist (such as corporate relationships as well as vendor characteristics) and are influential, these should be viewed as external forces on the decision process. Other external forces, such as staffing requirements, should also be considered.

This topic will be continued…..

Split and Search

October 22nd, 2009

Presented at the GBN conference on a way to provide users the way to enter a comma delimited list of values into a prompt and then use a database function to split those values in order to return the list as a table that can be used in joins.

WHERE rs_tb_cms_groups.group_ID IN ( SELECT rs_tb_cms_groups.group_ID FROM @Prompt(‘Group
Name ‘,’A’,{‘California’,’New York’},mono,constrained,not_persistent,))

If anyone wants the full article including the Oracle and SQL server code please contact Kevin McManus at answers@mcmanusconsulting.com

Whitepaper: Disaster Recovery and Business Continuance

October 15th, 2009

No-one expects disaster but we can plan for it. As Business Intelligence becomes an integral part of an organizations decision making processes it becomes as operational as any other system to the proper functioning of the business. This dependence by the business means that the outage of the BI system will have a negative impact in critical areas such as finance, customer service, or deliver expectations.

As with other operations systems the BI systems should go through rigorous testing, quality assurance, provided failover, and tested against the disaster recovery needed for business continuance.

With the BusinessObjects Enterprise XI platform there is a close interdependence between the database and the file system files. Normally backups are handled by independent backup systems for the database and the files. This normally also means that there a different teams involved in the two backups. In addition to the confirmation that backups are being complete there needs to be a clear understanding of all team members on how to restore those backups to minimize the impact of the system restore.

– In the case where a single applications documents are accidentally deleted the restoration of the entire system would also erase any work done by all users.

– Backup is performed at 12 AM midnight and system crashes at 10 AM. You have the potential to lose
everything done in those 10 hours especially if you do a blank restore.

Using the list in the White Paper you can prepare by developing and testing an internal approach to the most common problems that result in the need for a restore, so that you can avoid the surprises of teams being unfamiliar with your BOE systems.

www.mcmanusconsulting.com/articles/Disaster Recovery 2010.pdf

Maximizing Business Objects

October 14th, 2009

Understand the full functionality of BusinessObjects Enterprise software and the significant return to be gained by sharing that functionality with your other Web applications. Using the BusinessObjects Enterprise SDK and Web services, you can easily integrate reports, dashboards, scheduling, and security management. You can also improve application performance by off-loading report processing and deliver business intelligence functionality without new software or custom development.

http://www.sap.com/community/showdetail.epx?itemID=14037

Business Objects Bursting SDK: Publication Nation

June 16th, 2009

A common request in reporting is the ability to break apart a large report into parts and send each part to a recipient based on his/her area of responsibility. For example, a patient census report may be broken apart by care unit and each part sent to the supervisor of that unit. This process is called bursting.
 
Bursting in Business Objects Enterprise is accomplished by a combination of two technologies, Profiles and Publications, and in the current BOE version 3.1, has been improved with the introduction of single-pass bursting. Single-past bursting optimizes the report bursting process by retrieving the entire report’s data in one pass as opposed to executing a retrieve for each “burst.” 
 
Let’s talk about Profiles. Profiles define how data should be limited for a given BOE user or group. In the profile, you are able to specify each user or group (aka “principal”), and a filter for that group. A filter is report platform specific: You define a filter for Crystal reports, and a separate filter for Webi reports. The idea behind a Profile existing independently of a Publication, strictly used to define the bursting process, is that the same Profile can be used over and over again, thereby saving time in configuration. Combined, BOE Profiles and Publications provide a flexible and efficient way to deliver personalized report content to your users. Stay tuned for Part 2 of Business Objects Bursting or visit us online at McManus Software.

April 4th, 2009

Hippa Compliance

Login screen message of authorization agreement

Emails links

Security – one user one login

Audit

Timeouts (Web, Webi, BOE)

Keep it online

Secure all the data in all ways to access it (Database, report, universe)

Sutrn off Excel download

Use Xcelsius

Turn off print and print screen

Creating a test database with masked data

Row restrictions