Frequently Asked Questions (FAQ)

FAQ: Table of Contents

Written by OneCloud Documentation
Updated over a week ago

How To: Use Repeat Until Iteration

Explore how to use the Repeat Until teration functionality to create dynamic loops

Written by OneCloud Documentation
Updated over a week ago

How to use the Convert CSV to Native Essbase Format Command?

Written by OneCloud Documentation
Updated over a week ago

How do I convert to a Cross Tab report when there are commas in the Alias from an Essbase MDX query?

Using tuple delimiters.

Written by OneCloud Documentation
Updated over a week ago

How to use the Convert CSV to Planning File Format Command?

Written by OneCloud Documentation
Updated over a week ago

How can fields be concatenated?

Written by OneCloud Documentation
Updated over a week ago

How to use the Create Workbook Command of the OneCloud Excel BizApp?

Written by OneCloud Documentation
Updated over a week ago

How is the NetSuite JDBC BizApp configured?

Written by OneCloud Documentation
Updated over a week ago

How do I set varying date formats using Handlebars?

Written by OneCloud Documentation
Updated over a week ago

How to fix the Advanced Query Command dropping of leading zeros?

This solution highlight addresses how to fix the issue of Advanced Query dropping leading zeros on fields

Written by OneCloud Documentation
Updated over a week ago

What are Handlebars JSON Variables and how can I use them?

Written by OneCloud Documentation
Updated over a week ago

How do you rename files in OneCloud?

Written by OneCloud Documentation
Updated over a week ago

How to use the CSV to JSON Command and iterate over the results?

Written by OneCloud Documentation
Updated over a week ago

How can the Advanced Query Command suppress records with duplicate unique IDs?

Written by OneCloud Documentation
Updated over a week ago

How do I add multiple columns to a file?

Written by OneCloud Documentation
Updated over a week ago

What is the Smart Filter Rows Command and how do I use it?

Written by OneCloud Documentation
Updated over a week ago

How do I use Advanced Query with spaces in the columns names?

Written by OneCloud Documentation
Updated over a week ago

How to sum values with a dollar sign?

Written by OneCloud Documentation
Updated over a week ago

How to Incorporate Multiple "Find and Replace" into a Single Command?

Written by OneCloud Documentation
Updated over a week ago

How to filter out the first record of a file?

Written by OneCloud Documentation
Updated over a week ago

How to display numbers in their native form?

Written by OneCloud Documentation
Updated over a week ago

How to "Find and Replace" a single character (pattern)?

Written by OneCloud Documentation
Updated over a week ago

Error: Microsoft Excel Worksheet to CSV Command Use Formatted Cell Values parameter not working

Clarification for how the Microsoft Excel Worksheet to CSV Use Formatted Cell Values parameter functions

Written by OneCloud Documentation
Updated over a week ago

Error: Could not execute command: error getting file information: error code: XX

Written by OneCloud Documentation
Updated over a week ago

Error: EPMFDM-140149: Invalid data load rule name 'RULE NAME' specified when trying to run a Data Map

Written by OneCloud Documentation
Updated over a week ago

Error: Error reading list files response: invalid character '<' looking for beginning of value

Written by OneCloud Documentation
Updated over a week ago

Error: com.essbase.api.base.EssException: Cannot connect to olap service.

Written by OneCloud Documentation
Updated over a week ago

Error: com.essbase.api.base.EssException: Cannot connect to Provider Server.

Written by OneCloud Documentation
Updated over a week ago

Error: Essbase Error(1042017): Network error: Timed out before receiving all data

Written by OneCloud Documentation
Updated over a week ago

Error: Maxl: Function Not Yet Implemented (Error 1241106)

Written by OneCloud Documentation
Updated over a week ago

Error: java.lang.NoClassDefFoundError: com/essbase/api/base/EssException

Written by OneCloud Documentation
Updated over a week ago

Error finding the root array element, please check your path: path not found

Written by OneCloud Documentation
Updated over a week ago

Error: Could not execute command: Value to encrypt is empty

Written by OneCloud Documentation
Updated over a week ago

Error: Unable to find valid certification path to requested target

Written by OneCloud Documentation
Updated over a week ago

Find and Replace is not working with exact match.

Written by OneCloud Documentation
Updated over a week ago

Which version of Tableau do I use when creating a Connection?

Written by OneCloud Documentation
Updated over a week ago

What is the Site Content URL Name for Tableau?

Written by OneCloud Documentation
Updated over a week ago

How do I find the correct Workday values to populate the Workday BizApp connection?

Written by OneCloud Documentation
Updated over a week ago

What is the difference between Run Data Load Rule and Run Plan Type Map?

Written by OneCloud Documentation
Updated over a week ago

What is the support for Excel macros when using the OneCloud Excel BizApp?

Written by OneCloud Documentation
Updated over a week ago

How does the OneCloud Excel BizApp handle the calculation of formulas in workbooks?

Written by OneCloud Documentation
Updated over a week ago

Why is data uploaded interactively into Anaplan versus using OneCloud is different?

Data is different when uploading and importing via the Anaplan web application compared to performing the same data operation in OneCloud

Written by OneCloud Documentation
Updated over a week ago

Why does my HFM BizApp Command produced no data, yet results successful?

Written by OneCloud Documentation
Updated over a week ago

What field names should be used for loading the BlackLine Accounts object?

Written by OneCloud Documentation
Updated over a week ago

How come my NetSuite Saved Search returns an InternalID versus a MemberName?

Written by OneCloud Documentation
Updated over a week ago

My JSON to Tabular indicates “conversion successful”, but I do not get any data.

Written by OneCloud Documentation
Updated over a week ago

How do I escape special characters with Handlebars?

Written by OneCloud Documentation
Updated over a week ago

What is the Handlebars BizApp and how do I use it?

Written by OneCloud Documentation
Updated over a week ago

Where can I find some additional information related to Handlebars?

Written by OneCloud Documentation
Updated over a week ago

What's the difference between the Render File Template and Render Text Template Commands and which should I use?

Written by OneCloud Documentation
Updated over a week ago

Why are the File Utilities Commands not able to access a remote drive?

Written by OneCloud Documentation
Updated over a week ago

Can I use the UPDATE or INSERT statements with Advanced Query?

Written by OneCloud Documentation
Updated over a week ago