Umer Pasha Blogs

www.umerpasha.com

Adobe Omniture Site Catalyst Bug (Discrepancy in current month and previous year)

Looks like Adobe Omniture Site Catalyst  has a bug where there is a Site Visit count discrepancy in current month and 52 weeks prior (previous year).

I am trying to create my own dashboard for site visits. So I am using the API to fetch the data off of Omniture.

There appears to be a discrepancy in current month and 52 weeks prior visit count.

Please see attached image file.

If I select current month as Sep-2012, it shows me that the visit count in Sep-2011 was 9474.
When I select Sep-2011, it shows me the total as 9898.

Why is it so? I get the same wrong data when I try to fetch it through API.
Though, if I do calculations of my own after fetching each day’s data from Omniture and run some SQLs, I get 9898 as correct and 9474 as wrong.

Looks like a bug….. I have logged the same question up on Adobe’s forum here… lets see what i get:

https://developer.omniture.com/en_US/forum/reporting/site-visit-count-discrepancy-in-current-month-and-52-weeks-prior-1

Omniture Bug - Umer Pasha

Omniture Bug – Umer Pasha

 

 

Advertisements
Leave a comment »

Publishing data from Omniture to Sharepoint 2010 using Power Pivot slice and dice features

Just started a new project to create a dashboard using Power Pivot for MS-Office 2010 and integrate a dashboard in Sharepoint 2010. The data is again coming from Omniture API Soap calls.

PowerPivot is a free add-in to the 2010 version of the spreadsheet application Microsoft Excel. It extends the capabilities of thePivotTable data summarisation and cross-tabulation feature by introducing the ability to import data from multiple sources. As such, PowerPivot falls under Microsoft’s Business Intelligence offering, complementing it with its self-service, in-memory capabilities.

Prior to the release of PowerPivot, Microsoft relied heavily on SQL Server Analysis Services as the engine for its Business Intelligence suite. PowerPivot complements the SQL Server core BI components under the vision of one Business Intelligence Semantic Model (BISM), which aims to integrate on-disk multidimensional analytics previously known as Unified Dimensional Model, or UDM, with a more flexible, in-memory “tabular” model.

As a self-service BI product PowerPivot is intended to allow users with no specialised BI or analytics training to develop data models and calculations, sharing them either directly or through SharePoint document libraries.

 

Publishing data from Omniture to Sharepoint 2010 using Power Pivot slice and dice features

Leave a comment »

Using Adobe Omniture WebServices API in C# and showing data in Telerik grid and charts (Source Code included)

Here is the Source Code right up front: The C# Project File for Visual Studio 2008

If you have used Adobe Omniture Site Catalyst Web Services API, you will know what a hassle it is and how bad the documentation and technical support is. It took me a couple of weeks to reach this point. But that also included mastering a 3rd party grid and charting control from Telerik.

You will need to get a trial version of RadGrid from Telerik here which works for 90 days. You can also modify the attached code to just get the data and delete anything related to Telerik.

You will need to download MS Web Service Enhancement 3. You can get it here.

Make sure you get Web Service Access to the Enterprise API. Instructions are here.

You need to get your specific Site Catalyst WSDL. Here are the instructions. You will use this to add a web reference to your dot net project.

In the web.config, setup the SQL Server Connection String before running. I am storing the data I get from Omniture in SQL Server. I have not provided the SP code here. Mail me if you need help with that. You can remove all the SQL bits from code to not use that.

The project uses API 1.3 which is the latest as of now.

The project also shows getting custom conversion variables “eVar21”. if you are not using them, you can remove the code.


Some important links:

Getting started with Omniture API: https://developer.omniture.com/en_US

Reporting API Tutorial: https://developer.omniture.com/en_US/content_page/enterprise-api/c-reporting-api-tutorial

Leave a comment »