How to: |
Reference: |
Create Synonym for the Google BigQuery Adapter creates the metadata used for WebFOCUS reporting.
The Available Objects for Google BigQuery (GoogleBigQuery) pane opens, as shown in the following image.
Restrict candidates for synonym creation based on the selected object type(s): Tables, Views, External SQL Scripts, and any other supported objects.
Choosing External SQL Scripts from the drop-down list enables you to represent an SQL Query as a synonym for read-only reporting. A Synonym candidate can be any file that contains one (and only one) valid SQL Query and does not contain end-of-statement delimiters (";" or "/") and comments.
Depending on the adapter, you can further restrict your search by choosing check boxes for listed objects.
Select an owner/schema from the drop-down list, or click Search to search.
Indicates the project associated with the Google BigQuery data.
Select an application directory. The default value is baseapp.
If checked, opens additional fields for decomposing date fields, adding geographic roles, and selecting the data type for numeric fields and for alphanumeric fields.
Select Create Base Synonyms, Create Cluster Synonym With BV, or Update Base Synonyms.
Assign a prefix to the synonym names.
Assign a suffix to the synonym names.
Select objects for which to create synonyms. If you selected Create Cluster Synonym With BV as the action, the list will have facts and dimensions. If you select a fact or dimension, you can right-click it to show or add related dimensions to the list of checked items for the cluster.
Click Create Base Synonyms, Create Cluster Synonym With BV, or Update Base Synonyms on the ribbon.
WebFOCUS | |
Feedback |