Thinkwise Platform

When I create a new model in the SF (2024.2), vrs_control_branch_id and vrs_control_model_vrs_id of the main branch will be empty (and stay empty after generating definitions) (screenshot 1). When I develop something in the model and then try to upgrade the database, no ‘upgrade’ script will be generated at the ‘creation - execute source code’ tab (screenshot 2). Am I missing something here?After setting vrs_control_branch_id and vrs_control_model_vrs_id in the database of the SF, it does work correctly.    

We are still unable to display Multi Line HTML content in a grid within the Windows GUI.Is this possible and if so, what should we take into account?Are there special requirements for HTML formatting?

Hi,I have a chart that shows the capacity per day. The x-axis shows the dates. However, the sorting of the x-axis on dates is not working properly since it sorts alphabetically instead of numerically. E.g. 10 - 11 - 1, …, 20, 21, 2, … 3,30,31…  instead of 1,2,3, etc.The year, month and day in the cube are base on 1 column: date_day_only.I think I can create a workaround here by adding the day in the view like 01,02,03 etc. but I think I am missing something here in the settings. Graph sorted alphabetically instead of numerically Cube settings 

Currently installing our TW application at a customer where Internet access is only possible through whitelisting per site. Which URL's and ports need to be whitelisted to allow license registration and license refresh?I think https 443 for:- tcp.thinkwise.app- *.thinkwisesoftware.comAre these sufficient? 

I believe the default behaviour of the GUI when adding a new item through a form is to retrieve all fields and filling them with the default value (if defined). Even if the field is hidden. All fields are eventually  specified in the actual insert / update statement (excluding identity columns it seems).I am using a column with the default value set to expression and newsequentialid(). This can only be used as a default expression for the column. So i want to exclude this column when adding a new item.I have unchecked the default, layout, context checkmarks for this field in the subjects. When i add a new item through a form i get the following error:I think what's happening is that field is still retrieved and initiated with it's default value newsequentialid(). Is there anyway to exclude this field? I found this topic on the community Uniqueidentifier with NEWSEQUENTIALID as Primary Key | Thinkwise Community (thinkwisesoftware.com) from which i derive that newsequentialid() is not su

I want to connect our ERP with Documizers/Docuflow using their API. In short: the first step is to create a workspace, the second is filling that workspace with data.I use Postman to test step 1: The ID that returns I can use in step 2.How do I translate this Postman-POST to the HTTP-connector POST?No matter what I try, Indicium is returning error 400: Bad request.My return-parameter http_result_id is filled with:{"":["Failed to read the request form. Invalid header line:     "]}in stead of an ID.This is how I activate the HTTP-connector: And this is the content of http_body:set @http_body=--ItemID'--abcde12345Content-Disposition: form-data; name="ProcessName"Koffieadvies--abcde12345Content-Disposition: form-data; name="File.Name"pdw--abcde12345Content-Disposition: form-data; name="File.Extension".txt--abcde12345Content-Disposition: form-data; name="File.Content"; filename="123.txt"123abcde12345--'The API needs a file (with is an empty one).I also tried just sending the processname, bu

Is it possible to show only the color, instead of color + code in grid in universal?Compare with windows GUISo we can hide this irrelevant info on other places 

Hi,We have a subject definition with a default sort order on three columns and a prefilter which is always on (logged on user specific content filter). When this subject is opened from a menu-item, it shows the records in the correct (subject defined) sort order.When this same subject is accessed using the API, it seems to have a different (or no) sort order. When looking at the request Universal sends to Indicium using the same endpoint, all sort columns are specified in the request.Is my assumption correct that the sort order, which is defined on the subject level, is not used when accessing the resource through the endpoint without any parameters? Or is there some setting that can be used. It would be preferred to use as much the subjects configuration where possible so it only has to be coded in the backend.

Hi there.We are using a setup that is described in your documentation: Load balancing | Thinkwise Documentation (thinkwisesoftware.com) (Azure application gateway). We are using the standard import file functionality in a particular case where the file may have >10,000 rows and 30+ columns. The process takes longer than the application gateway request timeout (20 seconds in our case) and therefore a 504 is returned.Do you have any recommendation of this setting in the application gateway? Thanks in advance! Best regards,Nick Janssen

I'm looking for an easy way to obtain an end user's Time zone- and Language setting within the end database to be to make inline translations and conversions from UTC Time to Local Time?For example to construct a HTML card list field based on multiple fields.Any ideas?

Hi,The idea is the create a link to an external application. Right now this is the table we are using with 2 fields (a lot more, but those are not relevant)external_invoice_numberexternal_urlThe external_invoice_number is a readonly fieldThe external_url is a hidden fieldI thought of using the Calculation Type: Expression for the external_invoice_number field to create the link, but somehow it is not working (or my code is not correct)Why is this not working and what is the correct way to create a link? This is the code in the expression ​​​​​​​case when t1.external_invoice_number not null and t1.external_url not null then         '<a href="' + t1.external_url +'">' + t1.external_invoice_number + '</a>'     when t1.external_invoice_number not null and t1.external_url is null then        t1.external_invoice_number     else        ''     end 

Is it possible to have a variable value (e.g., a value from a table) as the value for the constant line in a cube view? Currently, I have only managed to insert a value which is plotted in a graph, which is sufficient, but it would be great if the value could be based on a value which the user has control of (e.g., a target for a KPI which the user may manipulate).

I've created a cube in a Proof of concept application, and I'm observing some strange behaviour.  in my column I have a date field and a responsefield that can be a value from 1 to 4 (it indicates the level of satisfaction)weird thing 1: if I have a dimension based on the score field and value based on the score field, in the pivot table the dimension gets substituted by the value field.    You see here that the categoy is average score, and in the pivot tabele you see it's actually dimension. weird behaviour number 2 if I use the count on the response field, and the amount is 3, which is a value of my element_list, in the pivot table it does not show 3 it shows the translation of the element item 3.  Weird thing 3:  if I have two fields based on the score field, say total count and average, when drag and dropping one of the two it is always substituted by the other one.  it basically means It's not possiblle to have to value items based on the same field?  

Hello all. We’ve previously upgraded our DevExpress component in the Windows GUI, Indicium, DevExpress Report Designer, and we want to inform you about a breaking change in the DevExpress component. Specifically regarding the Concat function.The DevExpress upgrade is included in our products starting from version 2024.1.13.0 (around April this year). This Concat function was only available and could only be used inside the DevExpress Report Designer. Previously, passing a null argument to this function would return an empty string. However, following our recent DevExpress update, this is no longer the case.The new behavior will not return an empty string when a null value is passed to the Concat function. This change may affect the output of your reports, potentially causing unexpected results if null values are involved.To ensure your reports continue to function as expected, we recommend reviewing and updating any code that relies on the previous behavior. You can find more informati

Hi, We have created a subroutine, that returns a table. The input params are employee_id and Date. When I call this routine through SQL it works and returns the rows as expected. When I call this this Subroutine through Indicium (with Postman) with a GET - I do get a 200 - but no data. It does not matter if I send use params are not. How can I have Indicium return the table /results? Much appreciated!Blommetje   

Hi,We have made a setup for using LLM Embeddings to implement AI based search which we are trying out as we speak (write). My question is about the models itself. Do they, and if so, how do they work with Dutch and other languages (like German)? Would you have to use other models, generate your own or is there some kind of translation possible? 

ContextI’m trying to create a grid that contains rows with prognosis, values and totals. Based on a contract-number. The idea is to be able to quickly gain insight into specific contracts prognosis, values and totals.Example:What do I want?Group on afspraak, omschrijving and leveranciers (all belong to contract), each contract has 3 rows of prognosis (inkoopwaarde, prijswijziging and total) each with its corresponding months.Datastructure:Its all one table in 1NF (supplier list is a description and has no relation and is not intended to).What did I try?I’ve tried working with the group untill function in the subjects, however as soon as Im adding more groups (for omschrijving and leverancier) the grid changes to a triple hierarchy tree-like view. Thats not what I want. When is problem solved?When I can make a grid in software factory that is like the example in context. Any suggestion is welcome and appreciated. Thanks in advance.

Hello,After upgrading our Universal version to a newer version in our DTA street, we get a version compatibility error. Clearing the cache fixes the problem, but we were wondering if there is a way to prevent our production end users having to clear their cache as this is not really user-friendly and many users will not understand why this is necessary and how to do this?Thanks in advance! 

Hi!We want to use the cube views in Thinkwise (Windows) to monitor our KPIs. One of these cube views is the representation of the company’s margin. The cube view is built based on a view, and this view is shown below the graph. I have created a ‘dummy’ table and a graph in Excel, which represents the view shown for the user. The formula for the margin KPI is as follows:100 * (sum(invoiced[€]) / sum(margin [€])​)Our users would like the following:The KPI calculation should be based on what the view is currently showing. This means that the calculation is ‘triggered’ (process flow?) when the user starts filtering in the view. The result should be shown near the margin view (or ideally, implemented in the graph). But it can also be a value stored in another table.Is it possible to start a process flow where I can fetch the shown data (e.g. order_id; financial done dates and order category) in the view when the user starts filtering? I know that the layout is triggered every time the user

Hi,Our team is considering offloading the files in our Thinkwise application from our on-prem server to an S3 instance, in order to reduce back-up size and improve file storage performance.However, we are unsure what happens to a file in S3, when a database record it is linked to is altered or deleted. Is a file automatically moved if a record is altered, is it automatically deleted if a record is deleted?We couldn’t find any documentation on this in the Thinkwise documentation, but we would like to know what behaviour to expect.Thanks in advance!

The Universal Client sends data to the external site sentry.io . From a security perspective we don't want to send any data to an external site.We also running the Universal Client in an offline environment so the  sentry.io site is not available which results in several errors.How can we disable this?

Is there a way to set the collation for a domain.It would already be helpful to know how to set / get the global collation, but I did not find it.I added some fields with the domain type “code_tag” to the application to avoid referencing numbers from code, and the collation can make a speed difference of a factor 5 in this scenario. So, I’m looking for a way to enforce that those have one of the two standard  “SQL … Latin … CS … BIN” collations. 

Hi,When we set some columns in the variant on hidden, in Universal, these are still in the response of the API calls when we check the network activity. Is for Universal also a view a better alternative?We are using the 2024.1.14 version of Universal.This topic is for the Windows GUI: