-
Store SQL FileTable in to Board
Good morning: I saved a PDF in a SQL FileTable. Now I would like to read and write it from SQL to Board but I can't get it. I tried to upload the SQL FileTable mapping the differents fields but none of them succeeded. Could you confirm me if it is possible to send PDFs stored in a SQL FileTable to Board? As an example see…
-
Triggering procedures with REST API Calls from within Board
1. Abstract This article discusses the possibilities of triggering Board procedures via Rest API Calls from within Board itself and the how’s and why’s of this approach. 2. Context The Board Public APIs empower external systems to seamlessly interact with a Board application. By utilizing REST API calls, you can, for…
-
Procedure Visibility in Security
Just like Cube Visibility in Database Security, it would be meaningful to have the same security functionality for Procedures, where you can have Cubes that control Procedures that are possible to run. It could also be applied to Data Reader (Visibility).
-
Home Screen by User
I think it would help a lot with solution design if we could set a home screen against the user profile, so that we can design different home screens for different people within an organization and have them taken directly there upon entering a capsule.
-
Data Reader load 1st row only
Hi Board Platform, is there way to force a Data reader to load only the 1st row of a file?
-
Linking Scroll Bars - DataViews
How can we ensure that dataviews move simultaneously together if they are of the same width ? For example I would want the 3 bottom columns to move at the same time as the top as they are linked, but as it's 3 v 1 it tends to go out of sync.
-
Board integration with Monday.com
Just got a question from a Customer if Board integrates with Monday.com. I was wondering if any of you interacted with this software before and if we can connect directly, via DR to pull data in Board? I'd think APIs but unsure from their website
-
Separating Code & Description - Axis Setting
I was wondering whether it would be possible to add an option to separate the code and description of entities added to the axis setting. With the hack mentioned in this post, the sequence of the breakdown of the data via the entities is not respected. Currently I am using the code setting in the axis setting and adding…
-
🚨 1 security filter's unexpected twist will leave you intrigued!
Hi everyone, I think it may be useful information for some of you to know that the 3 options under Security Filters actually doesn't have the same behavior! In fact the "Select Entity based on Cube" feature can be by passed the user itself! And it's by design *! By following the step bellow : Open a layout editor (where…
-
Is there a way to transport Presentations from one server to another?
Hi, I'm trying to move presentations built in S3 to C2. The Data Model and Capsule has already been pushed to C2. How can I do the same for the Presentations? Or will I have to manually recreate these presentations?
-
Logging Improvement - DbChanges.Log
Hello all, The DbChanges log is a great tool to have. It provides at a high-level what changed, by whom, at what time…but it's a bit TOO high-level. Currently, the log shows: 20230822 09:55:25Cubesadmin 20230822 09:55:25Cubesadmin 20230822 09:55:26Cubesadmin 20230822 09:55:26Cubesadmin 20230822 09:55:26Cubesadmin 20230822…
-
Logging Improvement - diagnosticYYYYMM.log
Hello all, Within the file "diagnostic«YYYYMM».log", there are various actions that are called out as part of the log. Specifically, if a process clears a cube without selections. [2023-11-01 08:48:10.648 -04:00] WARN { "Username": "x", "CorrelationId": "x", "Procedure": "cap - Update - Volume MS", "TaskId": "x", "Action":…
-
Level 200 Module 205: Issue with final totals.
Hi, I am having issues with my final totals with the sales actual report. The values are away off the from what is shown on the course yet the percentages are an exact match. I have rebuild the procedures and report several times and am still getting the same numbers. After inspecting the cubes after the data is published…
-
Unexpected behavior with empty Procedure Groups
Cloud Version 12.6. This might be considered a bug, but I will report this as an Idea of changing Procedure behavior. When a Procedure contains an empty Group, Board will immediately jump to the group below and consider the steps from the group bellow to belong to the empty group. However, if the empty group instead has a…
-
Enhance SAP DataReader procedure step with substitution formulae
It is possible to set additional parameters in the procedure step referring to an SAP DataReader Unfortunately, it is not possible to use any substitution formula here where the values to be used could be directly derived from a selection. The parameter is directly transferred to the connector as plain text. It would be…
-
Latest Value Per Month
I have a cube by Employee, Cost Center and Day. I would like to populate a cube which is by Employee, Cost Center and Month with the latest value (as close to the last day of the month as possible) for each Employee, Cost Center combination as shown by screenshot. Doing an extract reload unfortunately does not work as…
-
Level 200, module 204: All my numbers are double those of the screenshots in the course
Dear, After setting up the Data View configurations for the Sales and Units data, all my numbers are double those of the screenshots in the course? For example The units for the product "Bangle" in Feb 21 are two on my screen while they are one on the screenshot. Is there anyone that has an idea where the problem could…
-
Relevant documentation linked in IDP Import
Hi, When importing into IDP, documentation is mentioned in the drag and drop screen. It would be nice if this were a link, so we could click it and immediately start reading the manual, without having to search for it. Thanks!
-
Export and import of users from IDP should use tab delimited .csv instead of comma delimited .csv
Hi, When we export the list of users and their settings from the IDP today, the data gets exported into a .csv file that works with regular commas as separator objects. This can cause problems, as it is possible to have commas in emails, in metadata, in the name of the role, etc. If then the file is opened and worked with,…
-
If a user does not login for a specified time, their account is disabled automatically
In the IDP we have a max number of licences. In order to better manage those licences, could we have an automated feature whereby the user is disabled (in the user profile in the IDP there is a disable tick box) if the user has not logged in for a specified time. For example, if the user doesn't login for 12 months, the…
-
A way to link objects automatically?
By this I mean applying sizing changes & formatting. When selecting multiple objects on 12.6, there does not seem to be an option to apply changes across labels?
-
Track Cubes in Cube Visibility
Cube Visibility in Data Security is a great tool. However, it can be difficult to track which Cubes have been set. Especially when new Cubes are created during development. It would be helpful if you are able to highlight which Cubes have been set.
-
Reporting Layer: Optimize a report
1. Abstract Users are more and more demanding and are looking for the right balance between the correctness of the result and the scalability of the solution at the same time. Improving response time has always been a top priority, therefore the purpose of this document would be to explain the main best practices to apply…
-
Level 200, Module 210: Expense Planning Screen
The data in the data table disappears after applying the default Screen selection for Country = "UK - United Kingdom." Data will populate when the default Screen selections are set for Year and Currency per the instructions. I've checked the Cube and procedures and they match the instructions in this module. My only…
-
Sending data between data models.
Hi Board, We have two different data models and we need to sedn data from the one data model to the other and vice versa. Currently what we have tried is the following: Extract the data from data model A, call a procedure in data model B that would import the extract through Azure using a data reader and paste the data…
-
Ability to Set a Data Entry Trigger in drill down popup
Currently the Data-Entry Trigger can be set only by the master data-view , it will be good to set a custom data entry trigger specifically designed for the drill-down popup. For now, we can work around the issue using 'Drill to Screen', but it would be interesting to have this capability within the 'Drill Down' itself.
-
Cool dashboard screenshots & efforts
Hi Board Wizards, could you please take a screenshot of your best dashboards in Board or one you found that was presented well? I am looking for some dashboarding inspiration. Thanks a lot!
-
Board API query: How to authenticate and use Secrect Key
Can anyone show me an example of calling the board api queries? I have am API user setup with a secrect key, and a query. example. curl -X GET "http://p-p-board4/public/ARGDB/query/indexPricesNymex"
-
@datetime
Hi Board Platform Wizards - Wondering if anyone could help me with the following conundrum... The standard @Datetime substitution formula you can use on layout file name exports as 'YYYY-MM-DD-HH-MM-SS' - Does anyone know of a way I can amend the standard format and instead export as 'YYYYMMDDHHMM' ? A client has requested…
-
Order of filtering in Layout Selection window overrides Custom Sort order ranking on Entities
Hi, I noticed that my custom sort for this entity was not being followed on the data view the way I ranked it in the data model (image 1). It took me a while to realise, but I wanted to make it aware that the order of ranking in the layout selection window overrides the Custom Sort. This is misleading. I believe the Custom…