| Query View Workbook
You formatted a query view ( By changing Fonts/column width etc ) and saved as workbook in your favorites in the Browser. When you execute the workbook thru the browser you get the format that has been saved. However, you loose the format when you click the Refresh Button. How to set permanent settings so that formatting remains same as has been designed in the workbook? You can do this :- In Excel using BW, you have what I categorize as 2 different types of cells. You have "Excel" Cells and "BW" Cells. You can determine which you are in by selecting a cell and right mouse clicking. If you get the BW options (Drilldown, Swap, Insert.....) then you are in a BW Cell. If you get the standard (Cut, Copy, Paste) you are in the Excel Cells. If you are formatting an Excel Cell, Format using the option from the Excel Menu. If it is a BW Cell, Format using the option from the BW Toolbar (5th button from right). When you refresh you will retain your settings. Also, as a hint, you don't have to select all of your BW cells when formatting. Select a characteristic and format using the BW toolbar and all characteristics will format. Same goes for key figures, Free characteristics etc. BW uses the "BW Style Tool"to format. For more detail and customization follow the below steps: 1. Download OSS Note #300570. 2. On your machine
SAP Business Warehouse Books
SAP BW Tips
Best regards,
All the site contents are Copyright © www.erpgreat.com
and the content authors. All rights reserved.
|