QueBIT Value
Euclid 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 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 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 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 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 More