Picture Results, A US-Analytics Blog

Get started with Oracle Essbase, at a discount

Posted in Financial Applications, Oracle by usanalyticssolutionsgroup on June 3, 2011

US-Analytics Essbase Starter-Kit

In just five weeks, and with rapid time-to-value, implement the most comprehensive platform for the development of custom analytic applications… at an unprecedented discount.

Learn more: US-Analytics Essbase Starter-Kit

To get started, contact sales@us-analytics.com

Tagged with: ,

Don’t miss the next Hyperion Professional Women’s Event!

Posted in Oracle, Uncategorized by usanalyticssolutionsgroup on March 29, 2011

Don’t miss the first Hyperion Professional Women’s Forum event of the year!

Hear from Jennifer Grant, Financial Reporting Systems Manager at Lennox International, discuss the global deployment of the full Oracle|Hyperion platform!

This event is sponsored by US-Analytics, and will benefit Dallas Challenge, a non-profit helping youth stay in school, off drugs and alcohol, and out of the criminal justice system. Please bring a $10+ donation.

Bonus! Don’t miss a Nordstrom Spa Giveaway!

Please join us on March 31 at noon at the Maggiano’s on Park and the Tollway in Plano. RSVP Today!

Going to OAUG Collaborate? Join us for cocktails!

Posted in Oracle by usanalyticssolutionsgroup on March 29, 2011

Take a break from the hectic schedule of Collaborate!

Join US-Analytics and the Oracle Hyperion community for drinks, hors d’oeuvres and networking at Copper Canyon Grill.

Who: Oracle Hyperion community
Where: Copper Canyon Grill, 9101 International Drive, Orlando, FL 32819
When: 7:15 p.m. on Tuesday, April 12

RSVP today!

Tagged with:

QlikView Webinar: March 25, Noon Eastern

Posted in Business Intelligence, QlikView by usanalyticssolutionsgroup on March 8, 2011

Got QlikView Personal Edition? Now Learn to Use It!

Live Webinar, March 25, Noon Eastern

So you’ve downloaded QlikView Personal Edition for free?  As you may have noticed, getting started can sometimes be a bit tricky to new users.  However, once a few simple steps are shown to you, you will be off and running building your own simple, yet powerful applications for personal use.

Maybe you are already off and running or want to learn more about how to use QlikView?  Or maybe you are just looking for a few tips and tricks…either way, this is a session you cannot afford to miss!

Join QlikView product experts Rob Patterson and Mike Alegado for an hour long session where you will learn a little more about the power of QlikView and what it can add to your organization moving forward into the future.

On March 25 at Noon Eastern Time:

  • learn how to load data from multiple sources into one QlikView application
  • see the development of various sheet objects including charts and graphs
  • see how to customize reports and dashboards yourself (without the help of IT)

This is one of our most popular sessions so space will fill-up quickly…Register to reserve your spot today!

Tagged with:

Oracle a leader in Gartner’s Magic Quadrant

Posted in Business Intelligence by usanalyticssolutionsgroup on March 7, 2011

As a Platinum partner, US-Analytics is proud to provide services around Oracle, recently named a leader in Gartner’s Magic Quadrant for Business Intelligence Platforms.

According to Gartner, “leaders are vendors that are reasonably strong in the breadth and depth of their BI platform capabilities and can deliver on enterprise wide implementations that support a broad BI strategy.”

“One of the great advancements to the Oracle BI product suite is embedded intelligence, which lets you insert analytics and decision-making right into your business processes,” said Tobin Gilman, vice president of product marketing for Oracle BI, to Profit Online. “The idea is to make BI more actionable and more part of daily operations. To that end, Oracle’s open BI technology lets you embed BI directly into transactional applications or industry-standard portals.”

Read more about Business Intelligence.

Tagged with:

Looking for a chart in QlikView? Check out QV Extensions

Posted in Business Intelligence, QlikView by usanalyticssolutionsgroup on March 1, 2011

By Kristen A., QlikView Developer

Looking for a chart to use in QlikView but it isn’t listed? QV Extensions are there to open a new world of charts.

What exactly are extensions? A new feature for version 10 that makes it possible to write plugin objects.

Huh? Essentially, it’s great way to use other developers’ APIs to create sheet objects like Google charts. However, there’s a trick − extensions only work on the desktop client when you have WebView on. To do this, go to View > Turn on/off WebView.

When you download version 10 desktop, there is an extensions example that comes with it. Go to the getting started > examples.  Some examples they show here are gantt chart, stream chart and icon chart.

Best Practices & Tips

  1. Don’t just pull in a chart because it is cool. Make sure there is a real business value for it.
  2. Press F5 to refresh extensions in QV

Why use QlikView?

Great question. I have one word for this: Open. With the extensions, QlikView now gives more flexibility by allowing 3rd party APIs. I believe this is a huge step in the right direction and look forward to seeing what the community does with this capability.

How it is done?

Instead of giving you a step-by-step guide I am going to show you where to go. You will need to have QlikView SDK installed from the server installation. On my machine, I downloaded Server 10 and did a custom installation and only had SDK install. Then go to the video recordings > QlikView Extension folder. Inside that folder is a great video on how to create an extension. If you don’t have the means to download server there is also an API guide that comes with the desktop version.

Where are the extensions located?

Windows 7

  • Desktop: C:\Users\[user]\AppData\Local\QlikTech\QlikView\Extensions\Objects
  • Server: C:\ProgramData\QlikTech\QlikViewServer\Extensions\Objects

Windows XP

  • Desktop: C:\Documents and Settings\[user]\Local Settings\Application Data\QlikTech\QlikView\Extensions\Objects
  • Server: C:\Documents and Settings\All Users\Application Data\QlikTech\QlikViewServer\Extensions\Objects

What files do you need to create an extension?

  • Definition.xml – the meta data about the object
  • Icon.png – icon for the object
  • Properties.qvpp – sets the layout of the properties page of the object
  • Script.js – reads the data from API to be displayed in the object

You can also use other apis like:

Want to know more?

Check out the code from the examples  QV provides with desktop. The gantt one is a great place to start.

And now for a hilarious video…


Tagged with:

Picture Results Webinar: OBIEE for Better Analytics

Posted in Business Intelligence by usanalyticssolutionsgroup on February 28, 2011


  • Leading manufacturer of aluminum products, Aleris needed to rapidly gain insight into spend procedures


  • OBIEE Spend and Procurement application to quickly identify process breakdowns and unclassified spend


  • OBIEE provides rapid, out-of-the box reports, data models, metrics, calculations and ETL’s used for Operational Reporting
  • Ability to compare vendor performance on timelines, quality, pricing – giving the company better visibility
  • Better visibility = Opportunities to reduce cost… 1% savings equated to $4 million!

Learn more in our webinar…

For more information, please contact sales@us-analytics.com.

Tagged with: ,

An argument for email archiving

Posted in Messaging & Archiving by usanalyticssolutionsgroup on February 23, 2011

A growing risk in litigation, it is more important than ever that corporations understand what their email says and where it is stored. According to Kevin Crane author of Designing a Document Strategy, as email becomes the predominant mode of business communication, risk associated with exposure of corporate and employee behavior, and theft of proprietary information will increase greatly. Access to email and awareness of usage is paramount.  However, research reveals that e-mail administrators require an average of 1.8 hours to recover a message if it is recent, and 11.2 hours to recover if it is over a year old.

Symantec Enterprise Vault as an email archiving solution overrides this time-consuming collection process.  It provides companies with visibility into the discovery and management of their electronic data by compressing, indexing and deduplicating electronic data. It is capable of reducing corporate cost and storage space by up to 60-percent.

Tagged with: ,

Hotfix for Symantec Enterprise Vault

Posted in Messaging & Archiving by usanalyticssolutionsgroup on February 23, 2011

Symantec recently announced a cumulative hotfix for Symantec Enterprise Vault 9.0.1, Build 1073 for Microsoft Exchange. In some cases, certain types of Active Directory objects, when added to a Distribution List which was later used as a recipient of an Exchange journaled item, could have been incorrectly identified as a group object. This resulted in Enterprise Vault event log warnings and a possible backlog of items in the target journal mailbox. Read more about the hotfix solution and how to install it in your environment. If you require assistance, contact evpro@us-analytics.com.

Tagged with:

Killer BI: QlikView used to track down alleged muderer

Posted in Business Intelligence, QlikView by usanalyticssolutionsgroup on February 22, 2011

QlikView saves the day…

QlikTech, a leader in Business Discovery – user-driven Business Intelligence, announced that police analysts in Sweden have used QlikView to assist with a high profile crime case which lasted more than a year. QlikView enabled the police to analyze data and reports that would have taken one police officer in excess of 43 years.

“Speed is of essence in any police work all over the world,” said Police analyst Berth Simonsson. “With this ground breaking technology, we can save lives, predict crime and target anti-social behavior.”

Read more on QlikView’s website…