FAQ: Table of Contents

After reviewing these questions, if you were unable to find a solution and/or are still experiencing issues, please contact us at support@onecloud.io. We are here to assist.

Table of Contents

How-To

General Questions

Error Related

How-To

• How do you rename files in OneCloud?

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

• How do I escape special characters with Handlebars?

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

• How do I set varying date formats using Handlebars?

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

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

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

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

• How do I add multiple columns to a file?

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

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

• How to sum values with a dollar sign?

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

• How to filter out the first record of a file?

• How to display numbers in their native form?

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

• How can fields be concatenated?

• How to: Examples: HTTP BizApp Connector

• How to: Creating a Sample Microsoft Azure Application for OneDrive

• How to: Google Drive OAuth Setup

• How to: Creating a sample Box Application

• How to: Anaplan Certificate Authentication Setup

• How to: Create a NetSuite Integration User

• How is the NetSuite JDBC BizApp configured?

• How to: Oracle Identity Cloud OAuth Setup

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

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

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

• How to: Create sample Oracle HFM Config Text files

• How to: Salesforce OAuth Setup

• How to: Script Runner Examples

Home

General Questions

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

• Where can I find some additional information related to Handlebars?

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

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

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

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

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

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

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

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

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

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

• What is the Site Content URL Name for Tableau?

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

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

Home

Error Related

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

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

• Find and Replace is not working with exact match.

• Error: Unable to find valid certification path to requested target (IBM Planning Analytics)

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

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

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

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

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

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

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

• Error: Could not execute command: error getting file information: error code: XX (Oracle Content and Experience)

Home