|
There are two ways that you can connect to data in WebFOCUS. You can upload a Microsoft Excel spreadsheet or CSV file using the Upload wizard, or you can connect to an existing table in a data source of your choice, using the Connect to Data wizard. Both processes begin with identifying and preparing the data that you want to use. After your file or table selection is complete, the wizard shows you the default breakdown of your data as measures, dimensions, and hierarchies.
At similar points during the upload and connect processes, you can access options to transform your data beyond the default settings. This includes joining multiple tables into a cluster to create more fields and expand the scope of a synonym, editing geo roles and geo encoding to prepare the synonym for use in mapping and location analysis, data profiling and statistical analysis, changing columns or groups of columns into rows, and creating new or editing existing field roles.
Once a synonym is complete, you can upload it to a target environment or append it or merge it with an existing synonym. You can also save it as a template to allow repeated transformations if the same file is uploaded again in the future.
| WebFOCUS | |
|
Feedback |