Go to Top

Capitalize Analytics News

O&G Tax Calculation: A Cognos Success Story

When it comes to taxes, the US government can be particular about how they want taxes prepared and calculated. In the state of Louisiana, taxes are applied to the physical well’s volume and sales allocated, and not to the tract. A tract is an ownership percentage of one-to-many physical wells. The problem: Our client has an allocation system that applied taxes to the tracts and not to the physical wells. …Read More

Upcoming Live Webinar! Revolutionize Analytics for the Oil, Gas, and Energy Industries

Thursday, May 10th , 2018 at 1:00 pm CDT Join Alteryx and Capitalize Analytics as we take a deep dive into how self-service analytics, combined with a complete end-to-end platform, can revolutionize how people in the Oil, Gas, and Energy industries can use data to gain valuable insights. Walk away knowing how the right platform can help you:   • Accurately anticipate energy demands, like peak usage time, so you …Read More

Upcoming Webinar – ThoughtSpot: Stop building reports/dashboards and just “search” for answers!

Thursday, April 26th at 12:00 pm CT Capitalize Analytics works with dozens of vendors to solve data challenges. Rarely are we excited or blown away by a technology. ThoughtSpot will be the answer to a lot of our clients’ data/reporting challenges. Tableau, Qlik, Cognos, BusinessObjects, etc. are all great tools in the correct hands. The problem is that even the simplest tools are too complex for average users. ThoughtSpot changes …Read More

Cognos Web Services: Direct Access to Report Results

Cognos Web Services (CWS) allows report authors to share a URL that provides direct access to report results. Traditionally, generating report results requires a user to log in to Cognos Connection, navigate through the UI to the desired report, and select prompts and run options each time new results are needed. Utilizing CWS for a report streamlines the user experience to using a URL and getting up-to-date results without the …Read More

Powerful Date and Time Functions in Excel

Another installment of our educational blog series is here! If you have suggestions for future blog topics, we want to hear them. Email us at marketing@capitalizeconsulting.com with your ideas! Excel has numerous date and time functions that are very powerful in manipulating and deriving dates and times. In these examples, we are going to use one of them – WEEKDAY – as well as supporting numerical functions – FLOOR and …Read More

Event Studio: On-going events with data change example

Another installment of our educational blog series is here! If you have suggestions for future blog topics, we want to hear them. Email us at marketing@capitalizeconsulting.com with your ideas! Event Studio: On-going events with data change example Event Studio can be used to catch changes in data values that prompt further action by your organization. For instance, last name changes require updates to email addresses. If your system doesn’t currently …Read More

Prompting Best Practices: To require or not to require, that is the question.

The 2nd installment of our educational blog series is here! If you have suggestions for future blog topics, we want to hear them! Email us at marketing@capitalizeconsulting.com with your ideas! Updating reports can have its challenges. Sometimes, everything goes according to plan; other times, you are left scratching your head. We recently came across an interesting error while updating a report from a Cognos 10.2 to Cognos Analytics (11) related …Read More

Cognos Tutorial: How to Add a Second Line Per Record for Long Fields Using Grouping and Footers

We’re excited to add an educational component to our blog! Our consultants are great informational resources, and we want to share their knowledge with you, our subscribers. We’ll update our blog regularly with various educational posts written by our Business Intelligence team. We hope you find them to be informative and useful. If you have suggestions for future blog topics, we want to hear them! Email us at marketing@capitalizeconsulting.com with …Read More

Upcoming Live Webinar! What’s New in Cognos 11! Attention eSchoolPLUS and eFinancePLUS Users!

What’s New in Cognos 11! Attention eSchoolPLUS and eFinancePLUS Users! Monday, October 30, 2017 12:00 – 1:00 pm CDT Come see what’s new in Cognos 11 and why you should upgrade sooner rather than later. There are many exciting differences. To name a few… • Redesigned and modern user interface • Updated interactive viewer that allows users to sort, filter, group and total without the need for authoring capability • …Read More