-
Level 200, Module 209
When I get to the functional test of the solution, and click on step 1 of load data, after selecting Italy, the data reader does not seem to work. However, when I created the label and clicked on it after selecting Italy it worked, I mean, before arriving to the functional test past everything was working fine. Please…
-
Extract and Reload Bookmarks by Users, in order to keep them after clearing and reloading Entities
I have this requirement on Bookmarks from a big account. They are happy to use bookmarks since it is a big upgrade in their daily work compared their previous solution. The big problem here is that they need to clear and reload their MD's because it's a FMCG companies so their MD's have a high rotation. When they do that…
-
Level 300, Module 304: How to access the Tips and tricks 2023?
Hi Board Academy support, In Level 300, Module 304, there is link to access the Tips and tricks 2023, however, this link redirects to a microsoft authentication page and it seems that this link is only for Board employees with a Board email address. How partners can get access to this? Thank you. Nicolas
-
Displaying revenue data for bissextile year with previous year function
Hello, I am facing a challenge with displaying revenue data for bissextile years when using a previous year function. We have a cube by day, and a screen selection on the current fiscal period (March2024-February2025), a dataview that shows the revenue for N and revenue for N-1 values. The issue regards the N-1 column on…
-
Announcing an enhanced search experience
The Community team is excited to share two new features to the Board Community search experience which will allow users to more easily drill down on topics they're interested in. Thanks to the use of tags filtering in results and the addition of the AND operator, you can now return results that have all the tags entered.…
-
Build-A-Board Capsules & Data Model
Hi Community Does anyone have the Capsules and Data Model for the Build-A-Board series on Board Academy? Thanks
-
Triggering a back end procedure on click
Hello, I have a data entry block through checkboxes. I would like trigger a back end procedure on click (said differently, when I select the checkbox). Another question is about the value when I select the checkbox, as my block as set up as Single, the value equals to 1 when selected and to NUL when unselected. Is there…
-
Matrix relationship SQL not working 🤔
Hello dear community, I want to do a matrix relationship via SQL datareader (same as explained in the resources below) : Here is a screen of the ETL : The result is an empty cube with no discard and "1" as a validated record Thank you in advance for your help
-
PRESENTATIONS FORMAT
Hello All in presentations, it would be great to be able to reformat the columns. To date, the columns retain the format of the original report, which severely limits the interest of the presentations. It would also be very useful to have the function available to flatten the data. Thanks for your attention
-
Entity editor
If you place the Entity Editor and the Data View on the same page, you will not be able to see the contents of the Data View. How do I put them on the same page?
-
Level 300, Module 306: Flag the indirect Cost Accounts
Dear Board Academy support team, In the module 306 of Level 300, it is requested to select Indirect Cost Accounts (as per the below screenshot) However, these accounts are not present in the account Entity. As requested prior to this step, I updated the account hierarchies by running the "H - Unbalanced Account Hierarchy"…
-
Level 200 Module 204 Unable to locate files
I am unable to locate files when I enter the C:\Board\Dataset\Hierarchies and Data in Path and *Product Trees*.csv in Pattern.
-
Tree Object
Hi BOARD Team, I created my first Tree Object. The Tree always auto resize itself to the centre of the canvas and make the tree looks small. Is it a way / settings I can force the tree enlarged to fill the canvas ? Thanks Harry
-
Time Conversion🤔
Hello Dear community 👋 In the ETL, how can i convert a date from this format for exemple : /Date(986083200000)/ to this format : 200104 Thank you in Advance 🙂
-
Switch versions
I want to switch from working to final version with just one tap on a label. Can someone suggest me for the same.
-
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…
-
Procedure Execution Flow - Action Status
Problem to solve When modelling, business logics are encapsulated in separate procedures. This has the advantage that they can be called from anywhere without creating redundant logic. With the "call procedure" step, a procedure can call one or more child procedures. There is currently no simple way to return a functional…
-
[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…
-
An Extended version of the Board Substitution Formulas
Board offers a diverse array of functionalities and features, positioning it in a prominent and distinctive position within the competitive landscape that spans both Business Intelligence (BI) and Corporate Performance Management (CPM). One of the standout features that distinguishes Board is its Substitutions Formulas,…
-
"Analysis" For Data Readers and Procedures
I would find it helpful if there was an option for Data Readers and Procedures to have a similar setting that Entities have, the Analysis view. I am referring to the sections that appear when you click on an entity in the data model, that shows Cubes, Sparsity, Data Flow, Screens, Procedures, Rules. Something similar for…
-
[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?