-
Procedure to populate cube
Hi all, i just want to ask how to do the following thing: basically i have Cube A (1 dimension as Entity ) and Cube B ( Month dimension) i want to create a procedure that can use Cube A to populate Cube B based on a month selection. I hope you can help me with this problem. Best regards, Andrea
-
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…
-
When a DB is loading in RAM, Board platform is freezing
Hello, When database "X" is loading in ram, then users have to wait for the end of DB load to access data on that DB ⇒ OK normal behavior. However, it also impacting other users that are working on DB "Y" already loaded in RAM. Users of DB "Y" are also stuck and can no longer access the data. They also have to wait for the…
-
Geo Maps with OpenStreetsMap ( GoogleMaps) not working correctly
Hello everybody, we are trying to create Maps in Board 12.5 to show sales in countries where we are active. I tried to do it like described in the manual, but it is not yet working correctly. What do we have already - created a .json file with the six regions which we want to see - Marker Entity exists - Latitude and…
-
YTD Calculation problem
Hi All, I’m trying to figure out an easy way to do the YTD calculation. For example, if I have a cube where each month in 2019 has the same value (10 euros) and in 2020 has the same value (20 euros). i want to show on dataview the YTD data as following: Jan 19 (10 euro) Feb 19 (20 euro) .. and so on Dec 19 (120 euro) Jan…
-
Data View Configuration Options : zoom out, zoom in and change the scrollbar size
Hello, I’m looking for more configuration options in Dataview. Specifically, I’d like to increase the scrollbar size and explore the possibility of zooming out, similar to Excel, to view more columns in the table. If these options aren't available, is there any alternative? For exmple, could the Dataview be placed inside a…
-
Mass Communication To All Users for Planned Outages
Is there a method to manage communications to users through the sys admin section in Board? For example, we want to send a "planned outage" email to all users whenever we apply a patch or perform maintenance. A setting in the sys admin section would make it easy to send a mass email communication using the user's email…
-
Backup methods during the maintenance and operation phase
Hello. Currently, I am performing maintenance operations while having clients use capsules created with Board. I would like to take data backups as part of my regular work. As I understand it, the way to take backups in Board is to create a snapshot of the data model by making a copy of the files in a backup directory from…
-
Environment variable %COMPUTERNAME% into a txt cube
Hello, I'm trying to get the returning value of %COMPUTERNAME% variable in a data flow. I tried to the following solution : %COMPUTERNAME% and "%COMPUTERNAME%" in the target section and in an algorithm @COMPUTERNAME and "@COMPUTERNAME" in the target section and in an algorithm Using the ETL in a datareader with :…
-
Max occurrences shown in a @[entityname] label
Using a label with the caption set to @[entityname], it shows the codes of the selected occurrences up to a maximum of 12. From the 13th occurrence onward, it shows the number of selected items out of the total items in the entity (e.g., 14/5000). Does anyone know how to display the latter format (selected/total) even for…
-
Azure Storage Certificate Access
Dear Community, I got a good one for you. My customer wants to enable a certificate authentication on the Azure shared storage (Access Security) , would you have any documentation to put it up? Is there any best practice in order to secure the Azure Storage ENV ? Thanks in advance