Blending Data SSAS and Excel

tableaucommunity@tableau.com — Mon, 11 Feb 2013 19:19:35 GMT

Hello Tableau!

I am trying to blend data from SSAS and Excel. We have a cube, yet it is lacking any true GEO coding. So I exported customer names and zip codes from the relational database and put it into excel.

When I try to blend the data using 'customer name' it seems to work in a normal table report, however trying to plot revenue by customer on a map leveraging the blended zip code results in 2 errors (and it removes the customer name relationship link between datasources):

1) Analysis Services database error 0x00000001: The '1024' locale is not supported.

2) Analysis Services database error 0x80004005: Query (3, 2) The dimension '[Latitude]' was not found in the cube when the string, [Latitude], was parsed.

And here is the query it is performing:

SELECT

{[Measures].[Revenue], Latitude, Longitude}

DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON COLUMNS,

NON EMPTY [Engagement].[Customer Name].[Customer Name].AllMembers DIMENSION PROPERTIES [MEMBER_UNIQUE_NAME],[MEMBER_CAPTION] ON ROWS

FROM [PRIMARYDataSource]

As far as specifics (Windows 2008 R2 Server with SQL Server 2008 R2, Tableau 8.0 beta)

Anyone have any insight here? I'm trying to prove out how I can supplement CUBE data with flat files and this was a disheartening first step...

Thanks,
K2

Content in Tableau Community Forums

Blending Data SSAS and Excel