![]() ![]() This can be found under the Paste Options menu, which is highlighted in the following image. Then, right-click the selected column again and select Values. To remove date formulas, select a column, right-click, and then click Copy. You need to convert these computed values into simple values before uploading a spreadsheet. Spreadsheets may contain a date column where the values are computed by Excel using a formula. You can also do this prior to the upload in Excel. In the Upload workflow, you can define and edit dimension hierarchies prior to creating the synonym. ![]() ![]() To help WebFOCUS recognize hierarchical columns correctly, ensure that the column titles begin with a common word or words, and are arranged left-to-right in the correct top-to-bottom direction, as shown in the following image. Auto-drill lets you drill up and down a field hierarchy automatically, making the content engaging and useful. This is useful because the field names are arranged more logically in InfoAssist and because it facilitates Auto-drill capabilities in the content. WebFOCUS recognizes columns of data that have hierarchical relationships. An example of this is shown in the following image. You can define a data range in your worksheet to remove the data that you want WebFOCUS to process during upload, and leave your spreadsheet in its original format. You may not want to import all of the data columns found on your worksheet.Your worksheet may have introductory information, such as formatted headings or non-data information, in the first few columns.Using Excel Name Rangesĭata ranges defined within your Excel worksheet can be helpful for the following reasons: Data aggregation is performed by WebFOCUS, so you should remove these kinds of rows from your spreadsheet and save the file before uploading it. Removing Aggregated InformationĮxcel spreadsheets may contain subtotals, grand totals, and other non-data row information. You will be given an option to specify how many first rows of the Excel file contain title information in the Upload workflow. If your spreadsheet has more than one row of column titles, WebFOCUS can merge the information when creating the synonym. An example of meaningful column titles is shown in the following image. You can make this easier by ensuring that the first few rows of your Excel spreadsheet contain column titles that are meaningful to you and to other users who will be using it. The following image shows an example spreadsheet with a heading and subheadings highlighted.įor data to be useful in WebFOCUS, your data columns must be identified and properly described in the synonym that is generated during the upload process. Alternatively, you can define a data range within your worksheet and leave the introductory information in place. Delete the introductory rows and save the file before uploading. This information cannot be imported into WebFOCUS and should be removed. Sometimes, an Excel spreadsheet contains formatted headings in the first few rows. Be sure to check and adjust the file name prior to the upload. For this reason, all of the limitations identified for Excel worksheet names apply to the CSV file name. Note that your spreadsheet data and column titles may contain National Language Support data and special characters.įor CSV files, there is no worksheet name, so the CSV file name is used to generate the synonym name. While you have an opportunity to edit the worksheet name within the Upload workflow, editing in Excel may be preferable. The following image shows a worksheet with a meaningful name, Retail Sales. Spaces will be converted to underscores, but all non-alphanumeric characters should be removed from the name, such as the Remove or replace NLS characters with standard alphanumeric characters. Remove special characters from the worksheet name.For example, Store Sales is better than Sheet1. Ensure that the worksheet name is meaningful.For the best results, note the following guidelines: Naming Conventions and Microsoft Excel Sheet Namesįor Excel spreadsheets, the name of the file is not important, but the name of the worksheet that contains your data is used to generate the synonym name. You can use the following techniques to prepare your data for the uploading process. This is important because the synonym created for your uploaded data provides the basis for quality analytical content. Uploading data to WebFOCUS can be made easier if you first familiarize yourself with the data file, and then ensure that it is properly formatted for upload, so that geographic data, hierarchies, and other important aspects of your data are recognized. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |