Thinkwise Platform

For certain contexts where we show a difference between values it makes sense to display positive numbers with a plus sign. For example a difference of 5 displayed as “+5” in a list or a cube. I looked for a domain control to see if the gui offers such an option but I couldn’t find it. Is there a straightforward method or do I have to convert numbers to varchar to accomplish this?

We have a request from Customer Aartsen if we can provide (besides custom background and logo) opportunity to have custom colored (Aartsen red) progress bar on Windows GUI splash screen starting the application.  

When I was studying the present situation in our system, I came across attached database design. I would never have designed it this way myself, but since I'm relatively new to database design and eager to learn, I wonder what the advantages and disadvantages are of laying out the references and private keys in this way.A 'calculatie' consists of one of more 'calculatie_onderdeel' which consists of one or more 'calculatie_onderdeel_blok' which consists of one or more 'calculatie_onderdeel_blok_vak'.When I would have been the one to design this, I would have used one private key per table. E.g. calculatie_id for the first, calculatie_onderdeel_id for the second and so on. Then I would have created PK / FK references on these id fields.Please see attached picture of the design I'm referring to. Any thoughts on this, or some background information are welcome.

As a follow up on this topic, I'm trying to replace the application icon in the web gui. According to the documentation, the value for ApplicationLoginLogo must be an absolute (UNC) path. But when you're hosting on Azure, or an IIS without network access, you cannot specify a absolute path. In the settings.ini file i've tried to use .\MyLogo.png, MyLogo.png, .\App_LocalResources\MyLogo.png, App_LocalResources\MyLogo.png (placed MyLogo.png both in the root and App_LocalResources for all cases, just to be sure). But none of those work. According to the documentation, a full path is required, but isn't there a way to fix this using a relative path?

I would like to be able to assign a task to a taskbar like we assign details to a detailgroup. I want to be able to show other tasks in the taskbar above the grid than the tasks on the form.  In case we use 2 taskbars in the same screentype you get all the tasks in both bars (see Any ideas/tricks to running tasks from different parts of the same screen?) .It would be easier to assign the tasks to the ‘taskgroup’ of the taskbar. Maybe It could also be used to omit tasks in the taskbar (see Configure task, report and prefilter bars). The same could apply for reports.

I have a Long list of test question evaluations.  Because rther e is no indication of the Learning Pan or Course, onbly the Question is repeated, it is very hard to look up a specific evaluation.

The notifications of evaluated questions would greatly benefit from adding the Learning plan and Course the evaluation is for.  Currently only the question is displayed.  If you want to retake the test, searching for this by opening all the courses is way too much effort.

Currently is a question is ndoes not receive full marks no reason is given.  Since the student already proved incapable of providing the correct answer, this leaves the student in a non-learning position. Clarification: I do not suggest you should proviode the answer.  I do request to provide the reason of the rejection of the anser, a bit more descriptive as ‘incorrect’.

I have done heaps of tests in the Learn platform.  The evaluations sometimes do not award the full points.  how do i get more information about the result?Now I cannot continue since I do not know what I should answer to get full points.

I have created a table where there are different types of stands and they have different color code. I have a cloumn where you create a stand type and specify the color to that stand. I do know how to use conditional formating but conditional formating is for static data and only developer can assign the color. I want the end user to enter the stand type and the color code which will be assigned to the stands in master tab and detailed tabs or views where ever the stands will be displayed.

We run into problems with our rapport_queue. Problem is that we have more than 1 process adding rows into the table. Sometimes there is a conflict. We think a unique id could help, so a key with seed. Is that possible, why is that not done?

I think it would be really nice if a learner viewing the notification or an evaluated question would have some way  like a button to contact the evaluator about the result.  

I think it would be really nice if a learner viewing the notification or an evaluated question would have some way  like a button to contact the evaluator about the result.  

I don't like the distinction between the colors in the default color palettes (see attached image) and would like to create a color palette myself. I would like to know if that is possible and if it's possible, how it can be done.

I'm trying to reduce the amount of deployment packages necessary to be executed.Currently we're developing with several branches, resulting in a lot of project versions. We don't want to deploy each version to the customer (i.e. the changes are to minor), but only when we think it's needed.Using the deployment package, a package can be created. Unfortunately this creates an upgrade script based on the previous version, and not on an earlier version. In other words, we've created V1.00, V1.10 and V1.20. We want to skip V1.10, but it does contain database-updates that are necessary.How can I create a deployment package in the Software Factory creating a package that allows upgrading from V1.00 to V1.20 including the V1.10 update?In the documentation of the manifest file it looks like it could be there ( https://office.thinkwisesoftware.com/docs/docs/deployment/deployer.html#manifest). And as I can see it's used in the SF and IAM. By having multiple "supportedVersions" values in the manif

I want to be able to show the help text of a cube view (not context sensitive at this moment). Is it possible to create a hypelink to a cube view like you add a hyperlink to a table (tsfhelp://tab/...)? Or is there another way to link to the help text of objects in the model?

What is the scenario to export a project from one SF environment and import the project into a different SF environment? One way is of course to retype everything: the requirements, datamodel, tables, gui, etc.. I think there must be a better way to reach the same result.

We want to use cdc loging in sql server. Unfortunitly Thinkwise (deployment, creation part) wants to drop the indexes, stored procedure and function which are generated by sql server for the cdc loging. Is it posible in Thinkwise to ignore those indexes?Example to activate cdc logingEXEC sys.sp_cdc_enable_dbEXEC sys.sp_cdc_enable_table@source_schema = N'dbo',@source_name   = N'XXXXX',@role_name     = N'UserRole',@supports_net_changes = 1SELECT * FROM [cdc].[XXXXX_CT]Error in thinkwise by deployment, creation part[INDEXES]Cannot drop the index 'change_tables.change_tables_unique_idx', because it does not exist or you do not have permission.Cannot drop the index 'change_tables.source_object_id_idx', because it does not exist or you do not have permission.Cannot drop the index 'lsn_time_mapping.lsn_time_mapping_nonunique_idx', because it does not exist or you do not have permission.Cannot drop the index 'dbo_account_CT.dbo_account_CT_clustered_idx', because it does not exist or you do not

To set a default font for the RTF control, are options available similar to those for HTML controls?Edit: the options given for fields with an HTML control were:[dbo].[sanitize_html] (function is available in the SF database only) replace () in default or trigger logic (cumbersome in the case of RTF)Crystal Reports is fed various RTF fields and curruntly for each line of text, four lines of hardcoded RTF formatting are applied in the SF.The code that fills those RTF fields in the application is revised so that more of it is applicable for a shared set of fields.I hope to get rid of all the RTF formatting in control procedures, as all text is formatted to a single font anyway. It just happens not to be Times New Roman, which is what the RTF control applies by default. How to change the default font of RTF controls in the 2019.1 suite? 

Cubes, even small ones, use quite a bit of RAM. 1 GB for an average sized cube is not exceptional. One of our larger cubes with lots of dimension and value fields easily exceeds 2 GB and that’s already after applying pre-filters to minimize the data set. This RAM usage is fine when the cube is actually being used but I’ve noticed the application never releases the RAM after the cube has been closed. I checked to make sure that memory optimization for the table is switched off but that doesn’t seem to affect cubes. I’m a bit worried we will hit the limit of our terminal server despite the 48 GB of RAM per machine. We plan to add more cubes in our application in the near future.Is there a way to force the application to release the RAM after a cube is closed? Perhaps even release the RAM when the cube is opened in the background for a while? Because even when there is plenty of available RAM left it doesn’t make sense not to release it, especially when reopening the same cube only seems

I have to add product to different types of stands (high stand, low stand, pallet...) and remove them from the same, according to changes monthly, weekly, seasonal.. I tried executing the same task with the help of blog from Anne Buit but I did not get the result. Your guidance in relations and screen types will be appreciated

We have made an subroutine and mark this as an API (OData). This subroutine works fine when you use no parameters. When we profile with sql server the call is done but the parameter is null. We use the http call in the example but not sure this is correct.HTTP callhttp://web04/indicium/iam/100/fnc_getUserEmail?param_usr_id='itpartner\ronald'Metadata <Function Name="fnc_getUserEmail">  <Parameter Name="param_usr_id" Type="Edm.String"/>  <ReturnType Type="CENTER.subroutineScalarResult" Nullable="false"/></Function>

For a new table we need users to be able to upload files to a folder. To protect the integrity of these files the folder rights are set in such a way that files can be added but not edited or deleted. If users want to change a file in a record we want them to simply upload a new file. This also allows us to keep a history of all the files ever used in a record while keeping all the original files.When I try to upload a file using the gui I get an “access denied” error. The folder then contains a new empty file with the same filename as the original. It seems that the gui always creates an empty file first and then tries to edit it which is not allowed in this case.Is there a way for the gui to simply copy the file to the upload folder with the correct filename in 1 step? Manually copying a file to the same destination in Windows works fine.

In SF 2019.1 it's no longer possible to hide/display expression fields via a layout procedure. The checkboxes (under ‘Subjects’)  are disabled. All existing expression fields (fortunately) still have checked checkboxes. (see screenshot)Why is this CHG made in SF 2019.1? Based on an issue or because of performance? What is the alternative solution to hide/display expression fields via a layout procedure?This CHG is a problem for us because we often use expression fields to display actual data via the underlying query or hide/display the fields based on the filling of other fields/tables.  

Is it possible for a user (or admin) to share a cube view created and saved by a user, with all (or a selection of) the rest of the users?For instance:A user creates a cube view that will not only be useful for himself, but also for all members of his department. I will be great if the user can share it with his colleagues.