Posts by agoddard
Euclid Studio: Connect and Configure Nodes
This video instructs you how to connect and configure Euclid Studio Nodes. Orchestration of these Nodes is done using the canvas and Node connections.
Read MoreEuclid Studio: Create a Database Connection
In this video you will learn how to setup a JDBC Database Connection for use in Euclid Studio. Setting up these connections will allow you consume and deliver data for that Database
Read MoreEuclid Studio: Creating and Saving a Flow
This video walks you through the process of creating and saving a Euclid Studio Flow. Flows are files Euclid Studio uses to solve your business problems.
Read MoreEuclid Studio: Call a Flow from Planning Analytics
This video will show you how to use Planning Analytics to call a Euclid Studio Flow. This approach uses the included EuclidStudio.jar file and a QueBIT Standard Turbo Integrator Process to simplify your REST command.
Read MoreEuclid Studio: Call a TI Process from a Flow
This video will show you how you can execute a Planning Analytics Turbo Integrator process from a Euclid Studio Flow. This approach uses the Planning Analytics REST API.
Read MoreSupported Excel and TM1 worksheet functions by WebWORQ
Excel and TM1 worksheet expressions supported by WebWORQ include: Cell references, e.g. =B$22, =Sheet5!$K$6. Expressions built up of combinations of the following subset of predefined Excel functions and operators: Operators: +, -, *, &, =, <, >, >=, <=, <> Logical Functions: TRUE, FALSE, NOT, AND, OR, IF TM1 Functions: DBR, DBS, DBSS, DBRW, DBRA, DFRST, DIMNM,…
Read MoreExpansions stop working after updating sheet names in WebWORQ
Expansions stop working after updating sheet names Issue: Updated sheet names to include -, expansions stopped working on the web Resolution: Change the – to _ and republish sheet Open WebWORQ Excel file where the expansion is not working Review Sheet names If sheet name contains a – , rename the sheet to contain _…
Read MoreHow Do I Adjust Timeout Settings in ControlWORQ to Prevent Connection or Operation Timeouts?
This article covers settings that can be changed to adjust different timeouts in your ControlWORQ installation. ControlWORQ has timeout settings which can be added or modified to adjust how long a connection remains open or how long an operation (like intercompany eliminations) runs before timing out. ControlWORQ timeouts work in tandem with Planning Analytics (PA)-based…
Read MoreHow Do I Use the SQL SELECT and FROM Statements to Retrieve Data?
The select and from clauses are two of the most used statements in Structured Query Language, or SQL for short. We primarily use SQL to create views on the fly. Understanding what a view is will help to better understand the purpose of these statements. A view is a subset of records and/or a subset…
Read MoreHow Do I Use the SQL WHERE Statement to Filter Query Results?
Now that we have talked about how to specify what columns we would like to see in a view, we can talk about how to control the records or rows. The WHERE clause is a very useful one and it allows us to only view records that fit a certain criterion. The criteria often times…
Read More