Frequently Asked Questions (FAQ)

Here you will find answers to all your commonly asked questions, How-To's and errors.

OneCloud Documentation avatar
52 articles in this collection
Written by OneCloud Documentation
How-To

How To: Use Repeat Until Iteration

Explore how to use the Repeat Until teration functionality to create dynamic loops
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
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.
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How can fields be concatenated?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How is the NetSuite JDBC BizApp configured?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How do I set varying date formats using Handlebars?

OneCloud Documentation avatar
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
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How do you rename files in OneCloud?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How do I add multiple columns to a file?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to sum values with a dollar sign?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to filter out the first record of a file?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How to display numbers in their native form?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
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
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Error: Unable to find valid certification path to requested target

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Find and Replace is not working with exact match.

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago
General Questions

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

What is the Site Content URL Name for Tableau?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
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
OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

How do I escape special characters with Handlebars?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

Where can I find some additional information related to Handlebars?

OneCloud Documentation avatar
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?

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago

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

OneCloud Documentation avatar
Written by OneCloud Documentation
Updated over a week ago