-
Level 200, module 212: Running the Update P&L Procedure
Dear, My P&L Data view isn't populating when I press the Update P&L button. I checked all the instructions twice and can't seem to find a mistake. I played around a bit with a data view object of the BUD - DF - Profit and Loss Statement GBP cube to find out where the problem lies. It seems like the problem lies with adding…
-
Is there a simple way to rename a data model name (in bulk) in call procedures?
Hi all, I'm wondering if there is an easy solution to rename the data model name in call procedures in bulk. I've just read the best practice with regards to data model names, and it's to bad that during the implementation of BOARD (years ago) we didn't take this into account. While implementing BOARD, the consultant used…
-
Going to data model > cubes > structure is making IIS CPU load to 100% and super slow
Hello, We have this issue for a long time. Each time we are going to Data Model > Cubes > Structure our BOARD platform is instable / super slow because IIS CPU load start to increase to 100% and IIS memory also increase a lot. As a consequence, our PROD platform became super slow and unstable for users. Most of the time we…
-
Format Template - Mass font size assigment
I have a rather lengthy template - I want all rows to be the same font size, but it seems I have to click on each row individually. Am I missing a "select all" option? Thanks! Matt
-
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…
-
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?
-
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
-
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?
-
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…
-
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…
-
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…
-
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…
-
Columns in Excel Add-in
Version: Board 12.6 Hello, I need help setting up a layout in the Excel Add-in.If I have two entities in the column field, I would expect one of them to lay on top of the other. But I can't get it to work. Without it, the layout is not so readable. Setting up the layout like this, I expect to have the Month on top of…
-
Week Description
Does anyone know if there's a way to get Week to have a description which shows the first day of the week instead of the Week number?
-
DB extract & reload
Hi Board Platform, do you know how can I clean up db sparsity, if I have a big application? I have cube extracts going beyond 30 Gb and Board can't load them back in?
-
Ranking Function
Hello Board Platform, I have a ranking function (cumulated value) in block b. I am then trying to create an algorithm in block c, which uses the value from block b. This block will not show. It seems if you try to reference a ranking function in an algorithm it will not show the column. Currently I am doing an export…
-
Weather Feeds
Hi All, Has someone successfully connected and ingested weather data to Board via an API? If so how did you do so? Thanks in advance
-
Google Analytics Integration
Hello Board Platform , has anyone successfully set up Google Analytics integration previously? If so can you provide some details on the integration steps?
-
Hide Home icon?
Hi All, do you know if the standard home icon can be disabled?
-
Documentation Request
Hi All, is there documentation on how to upload as capsule & DB to board cloud - Does this exist ? thanks in advance
-
Headers Orientation
Hi Board Community, does any of you know if it's possible to change the orientation of headers to display them vertically?
-
Aggregation: Distinct Count
Hi Board Platform , I'm trying to use the distinct count function within aggregation to give me number of weeks on sale and number of stores from a sales units cube (for an algorithm). Behaviour seems really intermittent, it seems to work, but then when I put the entity I'm counting on the row (i.e. put Store on the row,…
-
File Size Broadcasting
Hi Board Platform, has anyone ever encountered a broadcast failing due to the size of the attachment in the email? A customer has a new report including product images and we're thinking this might be the case as exporting a printable report makes it 48mb
-
Dataview Formats
How do you show the vertical lines on the dataview for the group group by? You can see in my image that the vertical line does not go through the parent that the rows are grouped by.