SQL Server Performance

Calculated measure format lost in Excel PivotTable

Discussion in 'Analysis Services/Data Warehousing' started by fdeluccia, Aug 3, 2004.

  1. fdeluccia New Member

    Hello All,

    I have a cube in ANALYSIS SERVER with formatted Calculated measures. When I try and connect an Excel PivotTable to the cube, all the calulated measure formats are lost. Why is that? How can I propagate the cube formats into the Excel PivotTable so I do'nt have to keep on formatting in Excel?

    Thanks for any guidance!

  2. Hemanth New Member

    Hi Frank,

    How do you plan to use this excel file do you want to publish it on a site.
    If yes then you can use OWC components and use frontpage to show the pivot by using active x control properties.

    Let me know how it goes


Share This Page