JDBC Driver for Adobe Analytics

Build 22.0.8462

CreateReport

Creates a custom report by providing dimensions and metrics.

Stored Procedure Specific Information

To create a report view on a query, you can use the CreateReport stored procedure. The CreateReport stored procedure provides an easy way to generate new view definitions with a custom combination of Dimensions and Metrics. Calling it will create a new schema file that you can query like any other view.

The stored procedure takes a view name, a comma-separated list of metric names, a comma-separated list of metric ids, a comma-separated list of dimension names, a comma-separated list of dimension ids and an output folder as inputs. You will need to set the Location connection property to the folder containing the new script files in order to access them; the Location can be set instead of the output folder.
You can get the metric/dimension Ids by querying Metrics/Dimensions views.

SELECT Id, Name FROM Dimensions
SELECT Id, Name FROM Metrics

For example, to use a new schema along with the default schemas, set the Location property to the db subfolder in the installation folder and make the following call:

EXEC CreateReport DimensionIds = 'variables/geocountry, variables/geocity', MetricIds = 'metrics/pageviews, metrics/visits', TableName = 'MyCustomReport'
Dimensions and Metrics should have their respective Ids specified in DimensionIds and MetricIds inputs.

Input

Name Type Required Accepts Output Streams Description
TableName String True False The name for the new table.
Description String False False An optional description for the table.
WriteToFile String False False Wheather to write the contents of this stored procedure to a file or not (Default = true) needs to be set to false to output FileStream of FileData
DimensionIds String True False A comma-separated list of dimensions' ids.
MetricIds String True False A comma-separated list of metrics' ids.
FileStream String False True An instance of an output stream where file data is written to. Only used if OutputFolder is not set.

Result Set Columns

Name Type Description
FileData String If the OutputFolder input is empty.
Success String Whether or not the schema was created successfully.
SchemaFile String The generated schema file.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462