Work data of a pivot table created in PWA.

[Newbie]

Hello again,

When we export the work data of a pivot table created in PWA (OLAP cube) to
Excel, the work values arrive in Excel with a "h" for hours. This number
format is not recognized by Excel : source data is translated as text.
How is it possible to export data without the "h" ?

Thanks for help.

Newbie.

 

[Dale Howard [MVP]]

Newbie --

You can't. You will have to convert it in the Excel workbook. Hope this
helps.

 

[Gary L. Chefetz [MVP]]

Actually, I think you might be able to do this if you change the view in the
Analyzer to not show the "h" addendum in the display. You can accomplish
this by removing the display mask in the commands and options dialog for
work fields in question. Another approach is to simply define calculated
fields with a formula referencing the fact field. When you add calculated
fields, no display mask is applied.

 

[Newbie]

Good idea Gary!
I'll work around that
Thanks

Newbie