OWC export to excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi,

Could someone please help to resolve the following issue

I am displaying cube data in pivot table reports using owc in
sharepoint services. The names of measures and attributes in teh cubes
cannot be changed as it will affect a number of reporting services
reports. But users want to see different measure names for pivot table
reports.

Iam able to change measure names and also dimension attribute/hiearachy
names from owc by going to commands and options and changing the
caption for them. In the "fields list" i can see that change. But when
i export it into excel it reverts back to the original name as defined
in the cube and ignores changes applied in owc.

Iam using excel 2003. Could someone please guide me on how to keep the
changes when exported to excel.

Thanks

.

Relevant Pages

  • Re: Poor perfomance with Spreadsheet OWC 10 with more than 200 columns
    ... It needs 7 minutes to be load. ... > We have already created other reports with less number of columns (60 ... > We are loading the OWC with the HTML Data Param using Response.Write ...
    (microsoft.public.office.developer.web.components)
  • Re: How Large Is Too Large?
    ... That said it is not INXS of column counts allowed and if ... single Fact table with 200 columns realistic and feasible? ... Reports or via a cube or cubes? ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Data mining tools
    ... down large amounts of aggregate data, then an OLAP cube is a good way ... number of, IMO, completely silly reports we were asked to create. ... I mostly use PivotCube because it's VCL for Delphi. ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: Novice - Help with OLAP Design
    ... Designing time dimensions ahead of time is probably the standard way ... query or cube processing costs. ... your comment about knowing what the reports need to look like ... metrics they want to know as well, whcih is apart from report layout ...
    (microsoft.public.sqlserver.olap)
  • Re: OWC 9 best performance than OWC 11
    ... one is using the OWC 9 and the other one is using ... Both pages are accesing to the same OLAP Server, Same Olap Cube ... The data that is displayed is the same in both reports ... OWC 9 Report takes 15 seconds in order to display the report. ...
    (microsoft.public.office.developer.web.components)