Thinkwise Platform

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.

We have developed in our application some process flows to support complex functionality that requires the execution of several tasks (including calls to external connectors) in a specific succession and with multiple possible options. It would be nice to be able to provide some feedback to the user about how long it might take before the whole process is finished, something like a progress bar but spanning the whole process from start to end. At the moment I can't find any option in the SF to enable such a progress bar for process flows. Does anybody know if it is possible and how?

Is it possible to create a task which opens the import function (ribbon) on a screen for table ‘x’? We want to use the import function but not only on the table itself. If this can be done by a proces flow in which we go from point A to the table where we want to import we will be satisfied.Import button 

It's not possible to filter in the grid on multiple conditions. I don't know or it's a bug but in an earlier GUI version I thought this was possible. When I try to filter in a grid by more than one filter condition the first condition is switched off. For example:I would like to search all articles with the material "HDPE" and the colour "Blue 1% (1)”. My first filter condition is material "HDPE”. Extended filter | Material = HDPEAs second filtering condition I choose colour "Blue 1% (1)”. I expected all rows with both of these conditions. Instead of combining these conditions, the first condition is overwritten with the colour filter. Extended filter | Material = HDPE  + Colour = Blue 1%Filtering not by the column header but from the Filtering pop-up or the Quick filter the system gives the expected result. Filtering (Ctrl + R) or Quick filter (Ctrl + Alt + R)​​​​  

I am attempting to set a grid and a formlist side by side in such a way that the lines and fields of both line up perfectly. I set a grid row height of 34 pixels and a formlist field height of 33 pixels. This makes the rows of both appear equal in height. However the formlist is shifted downward somewhat. I have already attempted to tweak both field height and height between fields in the form settings but that doesn't produce the result I am after. Is there another option I can try?

I am on SF 2017.1 and would like to add a printer to my project to be able to select a specific network printer for a report (see attached screenshot). I chose this approach to be able to influence the printer settings for a report (e.g. orientation, collate etc.). Any help is appreciated!

I am not able to format the tooltip with html. The text is shown literally as written starting with !doctype html , tag html and body what do i wrong

Issues When using a formlist it's not possible to have form buttons such as edit and save. The alternative is to make the form editable by default and to enable form auto-save. This gets us a workable solution. This brings up another issue though. Radio buttons in the form are greyed out and only become editable when clicking another field of the same table row first. The reason for radio buttons is to prevent drop-downs to minimize mouse clicks. Request I would like to see formlists tweaked by the developers so that they behave somewhat more like a normal form, including buttons that can be relevant for formlists (such as edit, save and cancel). And ideally radio buttons in formlists are clickable immediately. Note Maybe this should have been an idea rather than a question. 😉

When can we expected the release where Service Pack 22 is compatible with the Thinkwise user interface? In the Knowledge Base Thinkwise describes the following: To use Crystal Reports in the Windows GUI, Web GUI or Indicium application tier, the Crystal Reports drivers must be installed on the client or web server. This concerns Crystal Reports Runtime 13 with service pack 20 for the right OS. With both, the support for the ASP.NET Web components must be installed. Service Pack 21 and up are currently incompatible with the Thinkwise user interfaces. A Windows 10 update forced us to upgrade our financial system (Exact). The upgraded version of our financial system uses CR16 Runtime servicepack 22. This feels like a challenge because it seems that our financial system uses the same dll as our Thinkwise application for generating reports. When I execute the SAP Crystal Reports Runtime 13.0.20 (64 Bit) as advised by Thinkwise our financial system doesn't work properly. When I exec

For a detail tab with a fixed amount of rows per parent item I opted for a formlist without a grid (to have radio buttons in a pseudo grid to minimize mouse clicks). The tab has 3 displayed columns. To get all fields in a row I selected "field in next column" for the 2nd and 3rd column in "subjects > components > form". That doesn't work however. To illustrate the problem I made a screen type for this tab with both a formlist and a standard form of the same table, stacked on top of each other. There's only one row in the table. This shows that "field in next column" works in a normal form (bottom) but doesn't work in a formlist (top): The labels of the first and third column are hidden (0 width). Is this a known issue?

I have the following process flow. In this flow I use a Print Report action that saves a report as pdf-file. To make sure that the user doesn't get the "file already exists" dialog. I decided to delete a possibly existing file with the same file name (row dependent) first. Although the process flow looks great 🙂 It doesn't work! What I see happening is, that the pdf-file is created and immediately deleted. Only the last pdf from the collection of records is not deleted. It looks like the Print Report step is executed before the delete file connector has been executed. My first question: How can I prevent the Print Report action from starting before the file has been deleted. I already created a process procedure to control the transition to the next process step, but unfortunately this didn't help either. My second question: Is there another way to prevent the "file already exists" dialog, when overwriting a report?

Hello, I’m working with the Windows GUI and indicium. I have a website ‘https://website.acto.nl/new’. I have a second website ‘https://oldwebsite.acto.nl’. I’m not able to change the ini file of all the users at the right moment, so therefor I would like to redirect users with the Windows GUI which still trying to reach the oldwebsite to the webiste.acto.nl/new Is this possible and if so, what is the best way to accomplish this? Eric Bosman

I'm trying to move our product to the Cloud using this blog post: https://community.thinkwisesoftware.com/blogs-21/to-the-cloud-leveraging-microsoft-azure-paas-155. I'm facing some difficulties regarding the differences between an on-premise environment (SQL Server and a file system) and Azure (Azure SQL Database and Azure File Storage). To start with, it's the difference in handling files. In the on-premise setting I'm able to upload files and read them using methods in SQL Server like xp_DirTree for reading a directory, and openrowset / bulk insert reading the contents of the file. In an Azure environment this isn't possible. Lets say the steps for the end user are currently as following: The user starts a task where it can upload a file using a 'File upload' control. This upload is bound to an Azure File Storage location, so it'll upload immediately. The user executes the task: The sql procedure of the task is called to process the uploaded file. In example the user uploads a

I want to upload a contract for a employee. The file should be stored in a employee folder on the file server. The domain assigned of the file-upload column contains a predefined network path. This path should be variable depending on the employee name. For example: I upload a contract for the employee "NVP\d.vanleeuwen". The uploaded file should be stored in the following file path: \\fileserver\file_upload\Employee\d.vanleeuwen\contract.pdf In this case the path must be created as follows: \\fileserver\file_upload\Employee\@variable_employee_name\@uploaded_file I've created a domain with control_id "File upload" and a file_storage_id who is linked to a storage location on our file-server (For example: \\fileserver\file_upload\Employee\). I've already tried to write and executed the following code for the insert_trigger of the employee_contract table. Unfortunately this doesn't work because it changes the path but does not move the file. code:-- parameters declarendeclare @us

I'm trying to move an on-premise environment to an Azure environment using this blog post: https://community.thinkwisesoftware.com/blogs-21/to-the-cloud-leveraging-microsoft-azure-paas-155. I've deployed the product and IAM databases to an Azure SQL database, and the Web GUI also to an Azure App Service (IIS). This works, but I don't know how to get the images of tasks / filters etc. visible. The help document / blog post isn't very useful for me. https://office.thinkwisesoftware.com/docs/docs/deployment/web_gui.html#images-are-missing The blog says this: Any files that would be on disk will have to be deployed together with the package. This process is a bit like how mobile applications are deployed and how it is currently done by the Web GUI or Indicium developers. Currently, all files in the application model are files on disk and must be packaged. This would be background pictures, icons and report files. I have no clue about how to deploy / package those resource files, I cann

Is the Android version of the Thinkwise mobile GUI compatible with Android 6.0? We have a customer with a tablet that is used as a vehicle board computer that is running on that Android-version.