Column Headers (MS SQL Server, OLAP)

  • Thread starter Michael G. Schneider
  • Start date
M

Michael G. Schneider

With MS SQL Server 2005, MS Excel 2007.

Suppose the database in SQL Server contains Customers and Addresses. Each
Customer has two Addresses: Shipping and Billing. The Address contains a
City and a Country.

Now we design the cube. There are two dimensions: Shipping and Billing.

When opening the cube in MS Excel the list of field looks as follows

Billing
Billing.City
Billing.Country

Shipping
Shipping.City
Shipping.Country

If I select the Billing.City and make it appear in the row area, the column
header will not be "Shipping.City". It will be "City".

As the City might come from several dimensions, the header is not so good.
What can I do so that MS Excel does not shorten the header?

Michael G. Schneider
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update Query w/user input, Need to add a formula. 2
Issue linking data from SQL Server to Infopath form 1
Execl 2007 Pivot Olap calculated Field 1
Embedding excel formula in MS Query that will be evaluated in excelnot in the SQL server 0
Pivot table from olap cube Warning and datasource 0
Excel pivot tables and SSAS 2
Excel Error while connecting to OLAP cube 0
Portfolio Analyzer views in Project Server 2003 Using SQL 2005 1

Top