Thinkwise Platform

I have a cube view that shows numeric values as a dimension (2 dec) with the number of occurences as value. In the pivot table the values are shown as 2 decimals. In the chart it shows more decimals, even when the number of decimals is determined in SQL (cast .. as numeric(11, 2)).  Is there a way to change this behaviour? Is it possible to reduce the initial scale?   

Hi all,I am using Azure SQL (not the managed instance!) and run in the problem of all dates being UTC. Ofcourse I want to see the dates as if they are in my timezone (UTC+1) Have any of you handled with this before? And if so what solution did you use?I'm really curious on the different approaches.

Hi. We have quite an extensive flow and I noticed that after the initial task (start flow), it sometimes tasks some seconds to get to the next step. However there is no indication in the Universal that the flow is running. Is there a way to get a visual indication that there is an active flow and the user should wait for it?

For our application we what to show actions and messages in HTML. When a message is to long we want to collapse it and give the user the possibility to unfold it manually by clicking on it (see image) and therefore we added some javascript to the HTML. I have tested this in a form and in a cardlist but it seems the script gets filtered out. Also tested this with a preview-screentype as mentioned in this topic but it seems this is not supported in Universal.Is there a way to achieve this in Universal?  

Hi,I’ve created a task where a user can select and a shift_id. A process flow opens a view. In this view I want to show only records with selected date and shift_id. In the where-clause this doesn’t work for some reasons. Do I need to set [parameters]? I now open an empty view, and tinkering with the filter-settings.. but either it’s all or nothing so far. Any tips on the matter? Alexander

When selecting a control with content type ‘data’ the control in the universal GUI has a white background. This is for example not nice when viewing the GUI in dark modeGUI versie2022.2.17.0.0GUI uitgebracht op09-12-2022Platform versie2022.2

Due to performance reasons, we have created some views on top of some main tables and linked them to the original table.From the grid (view) we show in the detail screen the form of the table itself.But then the add button is disabled.For the table itself the Add options are enabled in the subject settings.Also in the layout procedure we don't manipulate the @add_button_type and it is parsed with value 0I think this is because of the 1:1 relation between the gridview and the table itself.How to enable the default Add button? 

hi,We have a table that needs some (say 10+) extra fields to display in a list, mostly calculated fields, some fields from a related detail (like address, pc and city from the same record).I could make this with calculation type expression and get this data, but is this gonna give performance problems? And I need to query specific tables more than twice (address, pc, city)So another option is to switch the table into a view, and get all the wanted data in a complex view. But there I see far more problems recreating the references to other tables and all tasks referring to data in this table as it is an important source table in the solution.There must be something I overlooked or don’t know about in Thinkwise, how can I solve this properly? Any thoughts?

I've tried to configure our production environment to only use Azure AD login. Therefore I disabled the local login, however it still works. Indicium does not actually hide the button. Is there some other setting I need to change as well? https://docs.thinkwisesoftware.com/docs/2022/iam_dev/openid#disable-signing-in-with-a-local-account 

I have a question regarding the (error)logs from indicium and indicium legacy. It is really easy to look into the indicium logs via the HTMLpage: However, the error logs for Legacy are not available in the same way. Is it possible for TW to create a link via the HTMLpage?  (TW_att_1 and TW_att_2)Also, how can we enable the logs on the legacy server?  (TW_att_3) For us it is pretty complicated to access the windows logs and only 2 people are able to access it. The most errors for us happen on Legacy, so we want to be able to see those logs easily instead of using the windows logs. Kind regards, Loes

I added the extended property ShowTitleActiveChart=Yes, to show the title in the chart. Is there a way to set the used font size (theme)? It also seems that it's not only showing the title but also the name of the application. Can we avoid this?  

Hi,I have a table with multiple details and want to use auto save and auto edit in the main screen and the details. So I set auto edit and auto save on in the SF. But some strange things happend when I switch between the screens. As showed in the GIF   So it looked like that the column not save if you switch to a detail.

It doesn't seem possible to subscribe to Ideas in the community portal.Could this be made available?

When using the standard Export functionality, given that Indicium is on a Linux server, I got the log error: “Unable to load shared library 'libHarfBuzzSharp' or one of its dependencies”System.DllNotFoundException: Unable to load shared library 'libHarfBuzzSharp' or one of its dependencies. In order to help diagnose loading problems, consider setting the LD_DEBUG environment variable: liblibHarfBuzzSharp: cannot open shared object file: No such file or directory   at HarfBuzzSharp.HarfBuzzApi.hb_buffer_create()

Hi All,Is it possible to use Common Table Expressions (CTE) in DevExpress report designer like in SSRS where you can use CTE’s in datasets ?I know you can put CTE in a view in Software Factory and use this view in DevExpress designer. I get an error (see picture). 

We have two modules in our app. Both modules have a lot of Tiles in the menu.I would like to have 2 tiles, each opening a sub menu to display all tiles relevant for that module. This prevents a lot of clutter on the main screen.I’ve tried with a view with detail references, set null as the sub_menu-table_id in the template, but - as expected - it does not open the whole table, only the subtable_id of the underlying table. Any way this can be done? 

Hi, We would like to embed an image in DevExpress from our Azure File Storage. DevExpress doesn't seem to like it though. It handles Blob files without a care in the world.Anybody that knows of a possible solution?Thanks!

Hi EveryoneI am looking into testtooling to automate regression tests for apps build with Thinkwise software factory. Does anyone here have experience with automating tests for Thinkwise applications and can you help me what tooling might be best compatible? We are looking into Toolchain, Cypress, Playwright and some others. Yet we are open for suggestions. I am really hoping that people have experience with Thinkwise and Test automation.  Best regards, Marjolein Pordon

Where in the generation process are calculated columns generated and written to the database?This question came to me after I saw that you can modify the calculation query at Subjects.  Changing a calculated column is not a GUI but DB change, right?  

The details in the yellow and blue box are details of the one in the green box. Is it possible to get the blue details on the same level als the one in the green box?  

Hi everyone,We've implemented an auto-lookup for address data using @cursor_from_col_id. When both a zip-code and a house number is filled, the street name and city is retrieved. This works great.The table that contains the address data has over 9 million rows. Searching takes a few seconds. From a usability point of view, we would like to show an hour glass once the searching is starting in the fields that will be automatically filled.We tried setting the field variables to the ASCII hour glass (⧗) manually, have two temporary variables filled with a SELECT statement that retrieves the data, and once the temp variables are filled, move their contents to the field variables. However, a field can't seem to set to a value more than once. So, we don't see the hour glass at all. Instead, the fields remain blank, until the data is retrieved from he database.How would we set up a spinner sort of thing correctly, so that the user has visual confirmation that activity is going on? The form its

I want to create a ticket but not able to select a product, which is a mandatory field. can you please help. 

When we edit a template in SSMS, and import it to the SF, we get the following popup: What does it mean? The SQL script seems to be imported correctly, and it can be executed so that it gets "active”. The arrow expands the following stack trace:"   at System.Data.DataRow.GetDefaultRecord()   at Thinkwise.Shared.ObjectModel.Obj.BuildMultipleRowsQuery(DataRow[] dataRows)   at Thinkwise.Data.TSFController.refreshMultipleRowsCore(DataRow[] dataRows)   at Thinkwise.Data.TSFController.refreshMultipleRowsAndUpdate(DataRow[] dataRows)"Just curious about the implications of this.Thanks, -Alex.

Hi Community,Is there anyone who integrated tableau PDF export with the Thinkwise platform that could point me to the right direction? Regards, Remco Duijsens

By Evelien Duizer and Marjolein van der Vegt-Verstraten Let us start with a question: Do you know what software testing means, and what a software tester or a software test engineer is up to all day? Let’s be honest, most people, whether they work in IT or not, would answer this question with a resounding ‘no’. But isn’t that a bit strange? For most professions, the average person has a pretty good idea of what the job includes. A teacher educates students, a police officer enforces the law, and a doctor treats diseases. People can even hazard a good guess about what software developers do. They create websites, applications, and video games. So what does a tester do? First and foremost, a tester is responsible for increasing and guarding the quality of a system. This involves a lot more than people think. A tester has to find out how functionality should work, analyze the differences between the actual and desired situation, create test plans and scenarios, analyze risks, report test