Platform Q&A
This forum is dedicated to Board platform questions, generally applicable to all members.
Please select 'Yes' if a response answers your question to better identify possible resolutions.
-
Total by doesn't work
Hi there, I try to create a data block by country with the Total By setting. Example for Belgium 2 records Total in block C is 79.175 Total by Country block d shows millions. example for Denmark 1 record Totals aren't matching Any idea why?
-
CLEAR RDB-cube?
How does the "Clear " function work on an RDB cube? Will the table be cleared in the data warehouse if we use that function?
-
Hide specific rows
Hi BOARD Community, I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot. With…
-
Single Sign-On email
When SSO is enabled for users. When adding a user in IDP with SSO authentication do they get an activation email? Best Regards Peter
-
Rule with datapicker by column
I am trying to apply a rule on entity displayed by column. It doesn't work if I use a datapicker in the rule. If I instead use the entity by row, the rule works as expected. The question - can you not use datapicker in a rule if the entity is displayed by column?
-
Closing / Locking and Unlocking Periods
HI, We recently completed the implementation of Board's Consolidation module using the latest version GCR. We run into some issues when closing prior periods wherein it prevents the 'Run Conso" command from executing. The only way around that we found is to unlock all locked periods, run conso and then relock the prior…
-
Extract layout
Hi all, i want to know if it is possible to extract a date cube A (dimension: Entity) on premise: into something like this in a txt or csv file. sv0001 20241107 1 My final goal is to use this file for a data reader to populate a cube B with two dimensions (Entity and Month) with the same values as in the picture. P.S. I…
-
Best practice data import and update CSV
Hello, I'm new to the board world and am having a bit of a hard time finding the right way to import weekly updated data from a .csv file. What would be the correct/best procedure to import the data and update it weekly. I'm really missing the common thread, where should I start? First create the entities or cubes or data…
-
save quarter value in a monthly cube
Hi all, I have a cube with a Quarter dimension, and I want to transfer the value to a Monthly cube, specifically in the last month of each quarter. I tried with the dataflow but each month of quarter will be populated. I hope you can help me Andrea
-
Optimal Management of Temporary Cubes to improve RAM Efficiency in Procedures
In my current Board implementations, I rely on temporary cubes extensively due to their impact on readability and performance management. However, I've noticed they can consume considerable RAM, especially during data-intensive procedures. Given this, I’m wondering: does it make sense to clear the content of temporary…
-
Board onpremises with SSO over Azure Application Proxy
Hello, We use the Board service via an Azure Appiction Proxy. Now we would like to use SSO. Unfortunately, we always get an “internal” redirect URL https://server.internal/identity/sso/Acs as a return from the Board system. However, this is not accessible on the Internet. Is it possible to specify the redirect URL in the…
-
Filter Option in Layout
Has anyone encountered issues with the filter in the layout? I'm tryng to filter with min value >1 in some Cube value but report show all items also with zero value. Thanks
-
@selection_EX with Multi database
Hello all, I have a screen with the option "Multi Database". In this screen I have add 2 DataViews with 2 different databases. In both data views I add a label with an "@Selection_EX" to an Entity. As shown in the following screen I get only the Entity from 1 database displayed. Regards Stefan Batalia
-
Not more than one custom icon for capsules?
Good morning, I have copied a capsule, associated it to another data model and changed the custom icon it had in the first place. Now the copied capsule and the original capsule align their custom icon. This is how they looked at the beginning after the copy was made: After making the custom icon change, the next day, both…
-
exchange cube on premise
Hi everyone, My colleague and I are currently trying to modify the same data model on our respective PCs on premise. How can we exchange data cubes once we create one? (i don't want to send every time all the database) Thank you!
-
Delete/Update Entity members
Hi BOARD Team, If we want to change the Max Item for an entity, the best practice is to do it in test environment and then use the Transporter to update the production environment. Question 1: If I need to delete members from the entity, can I do it safely in the production environment? Question 2: I want to reload entity…
-
Creating Versions for Info-Cube
Hi Board Team, I have watched BOARD Academy video about optimizing cube performance by creating different version. Is there any disadvantage / issue for creating versions? Can I create version directly in the production environment? Thanks
-
Report Header in Excel
Greetings everyone, When I export my board report to an excel file, Headers are not export I need the Header(in red0 to be export with my report. Plus timestamp Any suggestion on how to get Headers exported with the report Thank you
-
DataClear log
Hello everyone, We have a question about data model log, it seems like not every DataClear steps shows on the log and we were ondering why. Does anyone of you have an idea please ? Sometimes the DataClear show and sometines not, as an exemple we have a procedure with many DataClear but only one is showing in the log and we…
-
Identify last non 0 value
Hi, I have a cube of 2 dimensions, Month Entity 1 In a procedure, I would like to identify the month with the last non zero value. I tried with the time functions as well as the analytical functions. I may have gone through those features a bit quickly and probably missed the solution. Would you have any idea how to do it…