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!

    -Frank
  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

    Hemanth

Share This Page