Cloud Data Connect Pipeline Drill Through

This helps optimize your integrations and data movement by:

Only needing to load the aggregate data you need for planning into Adaptive.
Still retaining access to contextual and granular details of those aggregates through live-queries to your cloud data warehouse.

On the

Setup Pipeline

pages, we add a new:

Warning message on the
Pipeline Details
page that the version and the sheet need to be unique per pipeline. This ensures there is a single source for Drill Through to query but allows you to create a draft.
Drill Through Table
field so you can select the table that contains the data you want to drill through for the loaded aggregate data.
Error message on the
Review
page when a pipeline already exists to prevent a connection of pipelines with the same destination.

When you download a cube or standard sheet, you can now select

Drill Through to Data

at the leaf node level on a drillable sheet cell or from an explore cell then a

Transactions

pop-up window displays. The Drill Through query leverages live queries to the Drill Through table you configured for the pipeline to return the data displayed in the pop-up window. You can also optionally export drill-through data relating to the cell that you are drilled into.

We add a new

Drill Into Cloud Imported Numbers

permission.

Note: Drill Through to Data is only supported for CDC managed pipelines, not CDC connections managed through Design Integrations.

Add the permission

Drill Into Cloud Imported Numbers

to your permission set.

To use Cloud Data Connect Pipeline Drill Through on a new pipeline:

Select
Integration
from the main menu.
Select
Setup Pipeline
.
Set up Cloud Data Connect. See
Set Up Cloud Data Connect
in the
Related Links
for more information.
Select
Drill Through Table
on the
Configure Connection
page.

To use Cloud Data Connect Pipeline Drill Through on an existing pipeline:

Select
Integration
from the main menu.
Select
Manage Pipelines
.
Duplicate
the pipeline.
Select
Drill Through Table
on the
Configure Connection
page.
Select
Save and Exit
to save the pipeline as a draft.
Delete
the original pipeline.
Navigate to the
Setup Pipeline
page.
Select the pipeline you saved as a draft.
On the
Review
page select
Complete
to connect the pipeline.