Intro to Wdata

Get started with Wdata

Intro to Wdata
Tables overview
Queries overview
Chains overview
Get started with tables
See all articles

Using Wdata

Fixing broken queries in imported data
Import or export Wdata objects between workspaces
Integration with Wdata
Manage folders and items in Wdata
Track Wdata usage
See all articles

Financial accounting in Wdata

Set up earnings reports in Wdata
Set up financial statements in Wdata

Tables

Work with tables

Using tables
Manage table properties
Manage table columns
Permissions in tables

Work with table datasets

Manage table datasets
Preview or download table datasets
Set up tags for datasets

Queries

Using queries

Create queries
Manage query properties
Manage a query's sources
Define query source relationships
Define a query's fields and calculations
See all articles

Manage filters and parameters

Create query filters
Set query filter criteria
Manage query parameters
Configure global parameters for the workspace

Writing SQL syntax

SQL clauses and statements
SQL text string functions
SQL date and time functions
SQL conversion functions
SQL conditional expressions
See all articles

Views

Visualize query results as views
Design a view as a flat or pivot table
Design a view as a chart
Permissions in views

Chains

Using Chains

Import or export chains between workspaces
Add chains connections to other environments
Create and manage chains
Run chains
Manage variables for the workspace and chains
See all articles

Using Chain templates

Using chain templates
Manage chain template folders

Using commands and outputs

Masking sensitive data in chains
Manage commands in chains
Group commands in a chain
Use iterators with commands and command groups
Use command outputs with other commands
See all articles

Using Chain events

Manage chain events
Set dynamic chain variables
Set conditional logic in a chain
Set an approval workflow for a chain
Upload files in a chain
See all articles

Build Chains, step-by-step

Get and set the current period in Anaplan
Download a file from an SFTP server to upload to a Wdata table
Update a table's query dataset as a chain
Create a table from a CSV file as a chain
Run query with a parameter value from a spreadsheet via a chain
See all articles

Questions when using Chains

Why can't I schedule a chain?
Extract data using an Anaplan View
What is the difference between a "transform" and "pivot" command?

Data Prep

Using Data Prep

Data Prep overview
Creating pipelines
Manage pipelines
Pipeline transformations
Manage transformations for pipelines
See all articles

Questions when using Data Prep

Can I see the before and after values at the same time for a field transformed by a Mapping Group?
Why did the text I entered into a transformation or mapping group condition disappear?
How do I ignore or remove rows from a data file?

Connectors

Configuring Connectors

Manage connectors for chains
Connector types
Manage GroundRunners for connections
Chain Builder security architecture

Core Connectors

Premium Connectors

OneCloud Specific

Getting started with OneCloud

Getting Started with OneCloud API
Accessing OneCloud support
The OneCloud reference architecture
What is OneCloud?

Administering OneCloud

OneCloud: Setup Chain Security
OneCloud security logs
User data export in OneCloud
Bulk create users in OneCloud
OneCloud password policy
See all articles

OneCloud BizApp

OneCloud BizApp
OneCloud Commands

OneCloud FAQs

OneCloud: Questions related to GroundRunners.
OneCloud: Questions related to SAML
OneCloud: Why do read-only users see options to execute and edit Chains?

OneCloud release archive

OneCloud UI enhancements released
Conditional Branching, Notifications and Dynamic Variables
Enhanced Navigation, Tagging, and Monitoring
Approvals, Triggers and Transformations
Runtime Inputs, Monitor Filters and Connection Audit Trail
See all articles