-
dataflow problem
Hi All, i have a problem with a calculation between 2 cubes First of all, i want update the cube B (5 dimension) using the value of Cube A (2 dimension \the other 3 dimension i used the filter in the procedure) without delete the other part of the cube B. the Algorithm use the cube A and B explained before. The reason of…
-
New capsule not showing in folder security
I created a new data model and capsule in our sandbox environment and moved it over to production via the cloud admin site. I can assign the data model to different user roles and they show up for the user (Powerusers can see it in the data model section). However, the new capsule won't show up under folders for these same…
-
When procedures triggered from screens fail you 😯
We are looking at all cases where a procedure executed from a screen can fail and stop. We have found what I relate below. ⚠️ Could you, please, point to additional cases? This way they are registered for future consultation by other members of the Community. ⚠️ When a procedure is launched from a screen, it can be with a…
-
Export screen data to xlsx
Hello, I am currently experiencing an issue with exporting the Data View to Excel and would appreciate your assistance. When I select the "Standard Microsoft Excel Workflow" export option, the generated file maintains the exact format of the Data View, which is ideal for my needs. However, I lose the formulas required to…
-
Board logs out automatically when inactive
Hi, we are using Board version 12.6, revision 0.2.88217. Board does not run in the cloud, but on our own server. We use IIS. The following is stored in C:\Program Files\Board\Board Server\BoardEngineParams.xml: <EnableSessionExpiration>false</EnableSessionExpiration>…
-
Adding Comments or Highlights in Data View
Hello, I was wondering if it is possible to add a comment or note to a cell in Data View. Moreover, is there a way to highlight or change the color of a specific number within a cell ? I have been searching for a way to achieve this but have not found any clear instructions or options in the documentation. Thank you in…
-
Session expired (reason: 0x0419)
I encounter periodic session expiration with message "Session expired (reason: 0x0419)". I lose some of unsaved work. What is the reason for this? How I can turn it off?
-
How to export the list of BOARD capsules with folders and screens?
Hi BOARD Team, During our development, we have created too many screens. Now we are trying to do a tidy up and remove unnecessary screens. Is there a way I can export the folders and screens name into an Excel list? Showing Folder and screens under each folder? Thanks
-
Board restarts after a short while
Hello, In our organization we experience that users are kicked out of Board after a short period. It can be both when Board is not in use, and when we are working in a capsule. Board restart and we are thrown out of the capsule/ screen we are in and Board sends us back to the main page in Board. Does anyone have a solution…
-
IIS - What is to dow with an Update to a new Version from Board?
Hello all, we have installed the IIS from MS instead of the Web Server from Board. What is to do for an Update from Board to a new version, e.g. to the new Version 14.1.0.1.233740? RegardsStefan
-
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…
