Go to OneCloud
All Collections
Frequently Asked Questions (FAQ)
Frequently Asked Questions (FAQ)
Here you will find answers to all your commonly asked questions, How-To's and errors.
52 articles in this collection
Written by
OneCloud Documentation
FAQ: Table of Contents
Written by
OneCloud Documentation
Updated over a week ago
How-To
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 Related
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
General Questions
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