Propose your fantastic ideas regarding the Thinkwise Platform to our Product Team.
In the pivot of my cube it is possible to turn on grand totals, however, it is not visible in the chart. It would be nice if the grand total data also becomes available in the chart. As a work-around, the data in the picture below is calculated as a sum in a union for my view. This is not ideal because it cannot be filtered and this data will also be added to the original grand total.
Hi. There is a PDF merge action. I really am looking for a PDF splitter at the moment. Can a splitter be added? Basically I have various PDF's of 50-100 pages and I only need certain pages, which are made known via page-ranges. Like 4-7,9,11-12
Currently it is not possible to show 2 different subjects on 1 page. In order to do this, you have to create a reference between page and remove all the reference columns. This is not the most logical and best looking way to implement this.Since this is asked for by my clients quite often, I think it would be great if we could set up something to configure this in the SF without having to apply this workaround.
For columns with invalid information we want a red background. When applying this to date_from and date_until we have a single condition, but want to apply it to both columns.In the current situation we have to create a conditional layout for each column and each set of AND-conditions. It is very easy to make a mistake here, especially when there are a lot of combinations.An improvement would be to have the option to add multiple columns to a Conditional layout.
When using a Cardlist the columns are not responsive. Example if you have a description of a product of say 70 characters and you use a small size screen that you would want the descrption to be displayed over two lines. Now the last characters are not visible.Now it’s not responsive
To make certain forms more user-friendly, I’d like to be able to use the well-known ‘switch’ as a control.It would behave exactly the same as a checkbox, just have different visuals (and be placed on the right instead of the left of the label).You can find examples in your Android or IOS system settings, where the switches show on certain settings on the right side. Bootstrap example: https://getbootstrap.com/docs/5.1/forms/checks-radios/#switches offonThe ‘on’ color could be set to the accent color set in the theme.
We have a few indexes in our application where due to the keys and ordering it is required to adjust the fill rates of the index to avoid instantaneous fragmentation when any record is added. Currently we have solved this with some after upgrade scripts but it would be convenient to be able to set this as a parameter on the index within the SF model.
Currently, the OAuth User Login connector within Thinkwise always requires the use of PKCE (Proof Key for Code Exchange). While PKCE is a secure method for protecting the authorization code exchange, there are still OAuth servers and systems that do not support this method. This can pose challenges for integrations where PKCE support is unavailable. To facilitate integration with such systems, it would be beneficial if Thinkwise provided the option to enable or disable PKCE based on the server configuration. This would increase flexibility and help simplify integrations with various OAuth servers.
I have some system flows with more steps. If there is an issue with the system flow, it’s hardly undoable to debug. There’s no logging at all. I now created some logging in the application self, but with steps with no code attached it’s not possible to track the system flow in the debugger somewhere.
It should be possible to run most of these processes in the background or trigger them automatically when adding or updating tables, tasks, columns, parameters, etc..
Recently an undocumented change has been made in Indicium (see this comment from Vincent Doppenberg). As a result a lot of our users (and those of other customers as the Community shows) experience the below annoying behavior:After a bit of idle time, they return to the Application and see the screen still open on the Subject where they left it They then click to continue their work and instead of the GUI suddenly throws a Session expired popup (this should be much more elegant, as per this Idea: Universal GUI - elegant session timeout | Thinkwise Community (thinkwisesoftware.com)) However, the user's login is still valid (for example because they checked the Remember me box on the login page, or because they use Azure AD as Identity provider for which the login is configured to stay valid longer) Then after clicking the ‘Close’ button on the Session expired popup, the GUI automatically redirects, reauthenticates, and reopens the original screen (unfortunately the Start Objects start after the remembered last page is loaded, for this we have TCP 6388S open) After this, the user can continue the workThese steps feel annoying and unnecessary for a user that is still authenticated. Can this be surpressed/prevented/made configurable so the user can continue working uninterrupted as long as his authentication is still valid?
In order to support public clients make the client secret optional (and enforce PKCE when empty).
During the IAM synchronization process there is a chance that an object is changed. In that case you will get a warning. If the synchronization is finished, you can filter on a certain result or you can scroll through the list of resulsts. Result prefilters (such as successful, warning, error) will make the search easier.
As a developer, I aim to unit test my table-valued functions independently from the functionality where they are used. This approach provides better results and simplifies the setup of unit tests.Unfortunately, the current documentation indicates that testing table-valued functions separately is not supported. However, I propose an alternative approach:Setup: Use the same setup as for a scalar function. Output Testing: Verify the function’s output using an assertion query.Below is an example of how the generated code might look:-- Declare parametersdeclare @first_id int = convert(int, '1');declare @second_id int = convert(int, '2');declare @return_table table ( "id_1" "int" null, "id_2" "int" null, "value_1" "varchar(10)" null);-- Execute unit testinsert into @return_table (id_1, id_2, value_1)select id_1, id_2, value_1from dbo.table_valued_function(@first_id, @second_id);-- Assertion queryif exists (select 1 from @return_table)begin exec tsf_send_assertion_msg 1, 'Successful';endelsebegin exec tsf_send_assertion_msg 0, 'Failed! No results returned!';endThis solution leverages the UI input for the function and validates the results using the assertion query. The “table_valued_function” takes two input parameters (“first_id” and “second_id”) and returns a table named “return_table” with three columns: “id_1,” “id_2,” and “value_1.”
Please make the tsf_optimize to be a system flow so that it can be run automatically by Indicium.Right now it is only as a manual task in IAM.Similar system flow is available in Software Factory to run automatically in v2022.2.As an additional note to the idea, Please add it by default when a project is created to inherit this Stored Procedure and system flow.
We would like to see information regarding the domains of the mock data. When entering the data it is not clear what you can enter in the forms. Sometimes you have to enter an element number of a domain, or just an int or varchar. It would also be nice to have an field after the form where you can add notes regarding the data entry.
A lot of times I create prefilters for a subject based on domain elements. For example, in my order table, I have a column order_status with domain order_status with elements like concept, confirmed, cancelled etc. I want a prefilter for each of those statuses. Now I have to create a dynamic model procedure to create prefilters based on a column, which works, but is a hassle. I'd like a task within Subjects > Prefilters to generate prefilters based on a column with the corresponding domain elements. The task should generate the prefilters including the icons, translations, prefilter columns etc and could group the prefilter in a group that is named after the column. This would save a lot of work and really improve the developer experience.
When enabling the setting “System versioning” we'd like to have the parameter HISTORY_RETENTION_PERIOD to be added to the screen so we can configure the retention period of the system versioned tables.
When the System flow schedules frequency is set to "Recurring", can starting at/to be not mandatory.. if empty then it's the whole day. I keep forgetting that 00 to 00 means not running.
Hi, Sometimes we create a domain manually. For a quick fix.However, the 020_upgrade script does not check if the domain already exists. So, SF outputs something like: /* Create domain T_bl_claus2 */create type T_bl_claus2 from nvarchar(250) grant references on type::T_bl_claus2 to public goCan this be wrapped with an 'IF NOT EXISTS’’?Does not happen often, but sometimes the deployment breaks on it, which is some work to fix.I think something similar happened when a deployment failed. Some constraints were already dropped. However, the script stopped because it couldn't find a constraint to drop. I manually created the constraint, and the script ran fine. A check for an IF EXISTS would be nice. ThanksBlommetje
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.