-
if-condition in a data entry reverse algorithm
Hi ALL, I would like to write in data entry a value in a column algorithm in the block c and based on the value of the block d I would like block a or block b to become equal to block c. To do this, I enabled data entry on blocks a, b and c. The algorithm in c is "if(d=0,a,b)", and tried entering as reverse algorithm…
-
[BOARD 12.5.1] - Max Entities per row into dataview
Hi, What is the max of Entities per row (par ligne) into a dataview?
-
Data Sources list (latest version)
We are talking with a client who is curious with the data source connectors for Board. All what I know is the picture in attached article(Data Pipeline section) as we can't access to data pipeline due to current license we are using right now. Is there any place or any way that I can find the latest list? Thank you.…
-
Review Activity after Foundations of Building in Board - Part 1
Step 11: Build TEMP - ACT - DR - Units Cube Problem: Salesperson entity is required in the cube's structure but hasn't been defined in the course yet. Solution: Create the Salesperson entity with Group: Salesperson, Code width: 50 and Desc width: 50. It will get populated in Step 12 because the Mode for Salesperson is set…
-
Level 200, Module 209, Build Actual Expense Data, Step 16
Hello Board Academy, I've started to have problems at the step 16. After the sub-step 'Run the "2. Publish Data" Procedure twice, in Play mode, for each "Country". (use the Country selector)' I have an empty Data View object after clicking on '2. Publish Data' label. I've checked everything, and I didn't find a mistake.…
-
How to replace REST Connector with REST API Call
1. Abstract This document illustrates how to adjust and optimize your REST API connection to leverage the more recent and advanced features and remove the technical limitations of previous solutions. Board 12 introduced new ground-breaking integration capabilities. As a Board solution is periodically upgraded to newer…
-
Is it possible to separate the values of the cube when the same screen is opened in multiple tabs?
Hello. - Hello. As the title says, when the same screen is opened in multiple tabs, Is it possible to separate the cube of selected values used in that screen? Example: "DisplayEntity" member =A,B,C,...,Z,not selected "parent1" member =A~G,H~N,O~U,V~Z,not selected "parent2" member =1,2,not selected Relationship: child…
-
[Board 12] - ETL concat String
Hi, Is there an ETL function to concatenate string data format into the Data reader ETL ?
-
Community Voices: Fethi Zerara - Four Tips to Support a Successful Board Implementation
The Community Voices series continues this month with frequent Board Community contributor and Partner—Fethi Zerara. Fethi joins us from Fastcube Consulting as a Solutions Architect and shares with us his top four tips to support a successful Board implementation. Check out his thoughts below! In our quest to empower our…
-
[BOARD 12.5.1] - CREATE DATABASE into CUBE via RDB
Hello, Where can i find a manual to explain how works the button: CREAT DATABASE into the Cube creation via RDB during the Mapping step:
-
International Women's Day - Inspire Inclusion
Did you know that International Women's Day (IWD) has occurred for well over a century? The first gathering dates back to 1911 and was supported by over a million people. We think that's worth celebrating! Today, International Women's Day is recognized globally on March 8, recognizing women's achievements and setting a…
-
[BOARD12] - FastTrack issue with SQL - ODBC
Hello, We receive a page with no data when we try to use Fast Track for MS SQL Server 2017 via ODBC. We did some test with other sources and it works (Ex: csv files). Do you have any idea how can we fix this issue?
-
Connection to Google API
Hello, I wanted to get data via API from a Google form. I set everything up in Google and with postman it works. However, when I try to establish a connection in Board I always get an error. My problem is that I do not know where to place the JWT or which settings need to be taken to get the connection via service account.…
-
[Board 12.5.1] - FastTrack since MSSQL Server View
Hi, Is it possible to do a fast track from a MS SQL view? Il only find all the table into the combo box.
-
Master Layout - reset upon screen refresh
We are currently migrating from Version 10 to 12.6 and found that the master layout is reset upon screen refresh in B12 - which was not happening in B10. As we are using calculations on these screens, the screen refresh is needed in any case. It is quite annoying selecting the same entity member over and over again, after…
-
[BOARD 12] Simple way to show flat data
Hi, Is there a simple way to show the result of this flat file into an object( via a Capsule\Screen…)? Something like a dataview object but not for multidimensional data input?
-
Level 300 Module 302 Section "One Time Bulk Load of Sales and Expense Data for New Stores"
Why do I don't get data after running the data model procedure "MANUAL - ONE TIME - Load Sales and Expenses"?
-
Build-A-Board Series
Build-A-Board Series Build a Demand Planning Application in Board
-
Level 300, Module 302: New Sales Person Master Data File Required.
Hi Support, I'm using the Board Academy Cloud to complete the course Level 300, In the data Reader ONE TIME - ACT - Units and Sales, there are many records rejected because of new sales person in the file. Could you please help to provide the file for new sales person? Moreover, since Board training environment is quite…
-
Move specific screens from one datamodel to other
Hi Is there a way to moye specific screens from one data model to another data model? The data models are on the same server. We have build some screens in a Capsule for data model A and want to move some to capsule for data model B. The capsule snapshot does really do it since in this gave in whats to level B with…
-
[Board V12] - Admin console port 8443
Hi, Where can i change the 8443 defaut port for admin portal url? 😶
-
How to do top-down allocation of an integer value
1. Abstract The article explains a possible method to ensure that top-down allocation of an integer value generates integer details through the redistribution of decimals. 2. Content In this example, we have a cube QTY [Year, Customer, Product] which is planned at a high level [Year, Product, Country] where Country is the…
-
Level 300, Module 302: Create a temporary validation test Screen to confirm all data has been loaded
Hi I'm using the Board Academy Cloud to complete the course. In step 15, we create a temp validation screen to check that the MANUAL - ONE TIME - Load Sales and Expenses procedure ran successfully. My ACT - DF - Sales GBP column is empty. I eventually tracked the error down to an [Rec.0] Error : RBT0071 Out of Memory,…
-
Data Reader Upload files
Hello I would like create a Data Reader and use my own files to try some use cases. Would you mind tell me how to upload my files in the Board local storage so I can use them in the data reader Best regards, Anis
-
Level 300, Module 302: seems there is no data has been loaded
Hi I'm using the Board Academy Cloud to complete the course. In step 15, I created a temp validation screen to check that the MANUAL - ONE TIME - Load Sales and Expenses procedure ran successfully. Both columns - ACT - DF - Sales GBP and ACT-DF-Expenses GBP are empty. What could be the reason? Thanks
-
Numeric cubes only in double
Hi, A long time ago I received the following advice: only use "double" cubes. Loading values between int and double, or single and double types could be buggy and fail unexpectedly. Is this still advice we should be following? I have been creating all my numeric cubes as double types, even the matrix cubes that are always…
-
Monthly Customer News Update - February 2024
If you are not receiving our monthly newsletter, please let us know and we're happy to add you to the subscription list. The beginning of the year always seems to move fast with new projects, kick-off meetings, and more. We hope you can steal a few quiet minutes to enjoy the February newsletter. Here are some…
-
Data view formatting
Hi, I want to format the heading of a Dataview and a I don't find how to do it: I want to get all the blue headings from the below screenshot in green. I have tried to do it through the Block Format but I could only modify what it already appears in green. And I also tried to do it thought the Templates but I could only…
-
Unexpected behavior when setting up database security
Hi, We are trying out a new database security setup at a client. For now, we are adding security on one hierarchy, cost center lv0-3. Our security cube has the Lv0 entity, and has user. In the custom selection script, we have Select User = @User. This ensures that the system always only looks at the security set for that…
-
Data flow: Copy cube down to a more granular one
Hi, we have a cube with data at Regional level and would like to copy it to another Cube at Country level. So we are going from a higher and aggregated level to a more granular one. The target cube has already data so we would like that the copy spreads the total by Region to its different country members. It should be…