Posts Tagged ‘performance’

We turned the page on another year and over the next few weeks, organizations and individuals everywhere will be communicating their strategic priorities, goals, and objectives for 2019. This year, I would like to challenge you to identify the one word that describes the success you desire for 2019.  Then, ensure that your strategic goals […]

Reputation Institute, a research and advisory firm that focuses on tackling and analyzing the reputation of companies worldwide, released its annual ranking of the most reputable U.S. banks. According to the report (and a basic understanding of human nature!), a company’s reputation has an effect on: Customers buying your products and services Policymakers and regulators […]

When developing Apps, it is not usual but sometimes developers may face some weird issues like lagging, stuck or even App crash. Normally, those issues are caused by some bad code style or leak programming and a traditionally developer can use some third-part tools like SonarQube to ensure the code quality. Unfortunately, iOS developing uses […]

Gathering Statistics of a database schema before executing an ODI load plan will improve performance by helping the Optimizer to select optimal execution plan by referring to latest statistics, instead of stale statistics. We can gather statistics of Oracle database schema at a scheduled time of day using the DBMS_SCHEDULER and DBMS_AUTO_TASK_ADMIN packages, However, if […]

I recently attended the opening session of Association of Change Management Professionals (ACMP) yearly conference and was immediately drawn to keynote speaker John Achor’s thoughts on “The Happiness Advantage” and how positive thought can not only make you happier, but can provide a myriad of other positive impacts in your life. Not only can it […]

by jDevaun.Photography Everyone is guilty of falling into a rut and building reports the same way over and over again. This year, don’t just churn out the same old reports, resolve to deliver better business intelligence. Think about what business intelligence means. Resolve, at least in your world, to make business intelligence about helping organizations […]

It is almost always advantageous to be able to “make sure” your Cognos TM1 environment is “ready for use” after a server restart. For example, you may want to: Create a backup Load the latest sales data Initialize security Etc. Hopefully, you know what a TM1 chore is (“a chore is a set of tasks […]

Currently there are 4 options for rounding numbers in Cognos TM1. They are: Rounding in reports. Rounding during loads. Rounding with the Cube Viewer. Rounding with rules. Rounding in Reports The most popular method to apply rounding in TM1 is in reporting. Cognos TM1 leverages MS Excel for reporting and supports all of the formatting […]

How do you create a recoverable backup for a TM1 server instance (TM1 service)? What is best practice? Here is some advice. Note: as with any guideline or recommendation, there will be circumstances that support deviating from accepted best practice. In these instances, it is recommended that all key stakeholders involved agree that: The reason for deviation […]

Overtime, I’ve written about keeping your TM1 model design “architecturally pure”. What this means is that you should strive to keep a models “areas of functionality” distinct within your design. Common Components I believe that all TM1 applications, for example, are made of only 4 distinct “areas of functionality”. They are absorption (of key information […]

Vision Most organizations today have had successes implementing technology and they are happy to tell you about it. From a tactical perspective, they understand how to install, configure and use whatever software you are interested in. They are “practitioners”. But, how may can bring a “strategic vision” to a project or to your organization in […]

When I speak to clients about In-Memory features in SQL Server, I find that Columnstore indexes just haven’t gained much traction as a marquee feature. The functionality itself is quite useful in the BI/DW realm as far as potentially boosting query performance by 1.5 to 10 times. But I think it gets overlooked because the […]

One of the most effective ways to improve application performance is to implement data caching. Most of the applications are relatively retrieving the same data from external sources like database of web service and if that source data is never or seldom changes then application is just wasting CPU time and I/O querying the source […]

Bulk Absorption Options From a pure architectural perspective, what is sometimes referred to as “bulk uploading” sometimes is (mistakenly) considered to be part of reporting or included in the data consumption component of a TM1 application design.  Loading and/or updating data is part of an applications absorption or configurations components and should be handled with […]

My colleague Martin Ridgway recently posted on how your web site’s performance is important to the user experience. Of course this is true for WebSphere Portal sites as well, so I wanted to steal…er, leverage his recommendations and elaborate with some specifics on how we see those implemented within WebSphere Portal sites. Before I go […]

Reengineering the Forecasting Process with Predictive Models Forecasts usually start as historical performance which is then reviewed and adjusted based upon anticipated events. More mature forecasting may also incorporate generally accepted business rules “programmed in” to help “drive” the data into a forecast. Over the years I’ve deployed uncountable applications which provide the ability to […]

Summary: In BI testing, we create views for large amounts of data, but performance issues can occur when we need to pivot a column and make it a string. To improve the performance, we divide this column into two groups first, one is for the unique value that doesn’t need any combination, and another one […]

Splunk hosted a webinar earlier today on their Splunk for WebSphere Application Server 2.0 application. This is an application they wrote that extends Splunk’s already powerful capabilities to provide WebSphere-specific searches and reports. If you’re not familiar with Splunk, you should take a look. In a nutshell: Your IT infrastructure generates massive amounts of data. […]

Guideposts An intelligent, data driven digital dashboard might be described as a corporate guidepost providing insight for an ongoing journey towards profitability. An interesting comparison might be found in the form of ancient store cairns found throughout many countries including Scotland, Ireland, Tibet, and the Arctic. These sculptures were often created as directional markers pointing […]

When it comes to performance problems indexing is the bread and butter of most data warehouse developers. And why not? It’s a cheap and easy way address simple performance problems. However, like anything cheap and easy it can only fix the cheap and easy problems. Indexing will not solve large underlying performance problems, but it […]