Have a look at our Professional Services offerings here.
View our Implementation-Based Product offerings here.
Join COGNOiSe.com, the largest independent, worldwide FREE IBM Cognos Support Community by clicking here.
Cognos, an IBM Company, becomes a BSP Customer. See here for more information. |
|
| Greetings!
Welcome to this month's BSP Newsletter. As we continue down the Business Performance Management (BPM) journey with our customers, we have introduced into our newsletter this month a section dedicated to Cognos FPM ( IBM Cognos Planning / IBM Cognos TM1) in addition to content covering Cognos PM ( IBM Cognos BI). Future newsletters will continue to expand on these topics as well as Strategy Management, and as always, we always enjoy hearing your suggestions regarding the content you'd like to see.
Please e-mail us if you have a topic you'd like to see discussed in future newsletters. |
|
BrightStar Partners to be Featured on
"The Economic Report" with Greg Gumbel
Producers of The Economic Report recently selected BrightStar Partners to be featured in an upcoming episode as part of the show's series on Focus on Business and Technology. Viewers will be able to learn the latest technology available to their company, and will be provided with the tools to succeed in today's ever changing global economy.
The Economic Report is the newest and most powerful resource for management issues, bottom line results, and next level performance in Corporate America and beyond.
Stay tuned for the official Press Release and information on the show's nationally televised dates. |
|
Achieve Amazing ROI with MetaManager
- And Receive CPM Explorer With Your Purchase -
How many products can demonstrate well over 100% ROI in the first year of usage? Well, based on a case study done with one MetaManager customer, we've seen ROI far exceed that amount, and you can too! The complete case study can be found on our website.
BSP is in a unique class of IBM Cognos partners, being one of very few, if not the only partner that is a Gold Reseller / Implementation partner, Gold Technology partner and Powered By Cognos solution provider. These accolades credentialize us as a trusted firm who understands the technology and application of IBM Cognos products. We extend Cognos' own development team with products like MetaManager and CPM Explorer, and deliver solutions that streamline execution and maximize ROI on both Cognos and our products.
With the much anticipated release of our latest implementation-based product, CPM Explorer, we're offering through the month of July 5 free licenses of CPM Explorer to all customers purchasing MetaManager by 7/31/08.
Take a look at our implementation-based products website at BSP Software to see how our solutions generate tremendous ROI within your existing IBM Cognos investment at every level, from Consumer to Administrator. | |
|
SQL Server Duplicate Insert Errors with Bulk Insert
- Contributed by Tom Tesar, Senior Consultant -
Have you ever faced a situation when you are trying to bulk copy a huge number of records into a SQL server 2005 table and you keep getting a duplicate insert error?
The cause of the error most probably is:
- The target table has a unique key constraint enabled.
- The source table is violating the unique key constraint of the target table.
The above conclusion is quite simple to draw. The problem is that you will need to solve this before the bulk copy can succeed. The task can be even more challenging if the source also had unique key constraint implemented and apparently all rows in the source column were also unique as per the unique key constraint of the source table. The reason we are getting the error is that the unique key constraint of the target table is being violated and that could be different from the unique key constraint of the source table. The following SQL will help you to quickly find the rows that are responsible for the error.
SELECT <table>.* FROM
(SELECT COUNT(*) AS COUNT, <Key column(s)>
FROM <table>
GROUP BY <Key columns(s)>
HAVING COUNT(*) > 1) A
INNER JOIN <table>
ON <table>.<key columns(s) > = A.<key columns>
Where
<table> is the source table.
<Key column(s)> are all the key columns of the target table.
|
|
IBM Cognos 8 Planning Quick Facts
- IBM Cognos 8 Planning eases the planning, budgeting, forecasting, modeling, consolidation, and financial reporting workload.
- Contributors to the solution are connected via web browser and can use this single entry point to perform a number of tasks, including: What-if Analysis, Production and Ad-hoc Reporting, and viewing Workflow Status.
- In Contributor, users experience the simplicity of entering numbers; the complex calculations have already been defined and established in Analyst.
- This solution provides increased productivity by allowing users to collect data from more sources more often, providing better accuracy and more opportunities in less time.
| |
|
|
| Did You Know...
In IBM Cognos 8 Data Manager...
- Contributed by Katie Kalk, Senior Consultant -
- You can create folders to group builds / jobstreams
- Jobs can be published to and run from Cognos Connection
- Exporting to a Framework Manager model is simple
- There is an audit feature that lets you review a job or build's run and delivery history.
And.....
- The name is derived from Welsh terms 'pen', meaning head and 'gwyn', meaning white.
- Penguins have short legs and no knees.
- Most penguins can swim about 15 miles per hour.
- Unpaired males give ecstatic display for attracting females.
- Choice of mate depends on the female penguin.
- Penguins mate for life.
- Male penguins take care of their chicks.
- Penguins use sign language to communicate with each other.
-
They make use of their flippers and head to talk to other penguins.
-
The penguin is an unofficial symbol of the United States Libertarian Party.
-
Some interesting penguin terms
Read more about Penguins. |
BrightStar Partners is committed to bringing you quality content month after month. If you have ideas for topics or if there is something you'd like to learn more about, please contact us and we'll do our best to address your request! We hope you enjoy this newsletter as much as we enjoy bringing it to you. |
|
|
