-
Apply Selection to Layout Block - Chart / Dataview
Hi i would like to change the apply a different selection to a block however I receive an error in chart and dateview: When i change it manually it works. Interestingly despite of the error trackball is still showing but with the wrong numbers. Any idea what the issue is?
-
Allow drag & drop reordering of cube versions
Hi there! It would be really useful to be able to reorder cube versions by dragging and dropping them. Right now, if you create a new version that, for performance or logical reasons, should be placed in position 2, but you already have 6 versions, you must delete all of them and rebuild them in the right order. It would…
-
SCIM/SAML Provisioning No Longer Updating Users Automatically
To successfully update a user's access in the Board Application by replacing their existing AD group with a new one. The following steps are followed. Step-by-Step Process 1. Remove Existing AD Group • Sync to Microsoft Entra ID occurs within 15 minutes. • The SCIM provisioning job, which runs every 40 minutes, updates the…
-
Problem Loading images with Data entry
Hi everybody, I’m currently struggling to upload some images into a BLOB cube. I already have a cube containing different items, and I’d like to associate each item with its corresponding image. To do this, I created a BLOB cube with the same dimensions as the original one. Then, in a Data View, I tried to enable the Data…
-
Board Scheduler
Hello, It's my first time trying to schedule a nightly procedure run. I'm on board 12.6 and I'm having a hard time finding the scheduler in system admin portal. I will appreciate any resources and/or screenshots on how to locate the scheduler and schedule a nightly procedure run. Thanks, Walter
-
Clarification on “Max Item Number” when creating an Entity
Hello, I would like to ask for clarification regarding the Max Item Number option when creating a new entity. When the Max Item Number is set to Auto, what exactly does it mean? Does the entity accept an unlimited number of members? Or is there still a hidden system limit that we need to be aware of? I want to better…
-
Send Blob Cubes Attachment through Email
Hi , We need to send multiple attachment through email currently it is not feasible in Board. It would be great if we could take this up in the latest releases
-
How to create bar chart in Data View
1. Abstract This article describes a specific use case: visualizing a bar chart in a data view object. 2. Context In some projects, it can be asked to render a bar chart in a data view object, to provide an immediate visual representation of the numerical values directly in line with the data. This allows users to more…
-
Best practices for using "Back Compatible" option in Dataflows?
Hi everyone, As part of a migration project from Board 10 to Board 14, I’m reviewing the use of the "Back Compatible" option in Dataflows. I know this option should not be used with HBMP dataflows, but I’d like to go further and understand: Are there any additional recommendations or best practices related to this option?…
-
Simplify Selection of Descendants in Unbalanced Hierarchies
Currently, when working with unbalanced hierarchies in procedures, there is no simple way to select descendants of a parent element in a dynamic way. This limitation creates a lot of extra work during integration and makes maintenance difficult, as developers have to rely on complex and fragile workarounds. A simple and…
-
👋 Fixing the article on OpenID for on premise
Hi @Board Community, @Board Support, Is it possible to correct the template openid.config at the end of the article in link bellow ? It's full of typos and not even valid xml (<add /></add>!) and apparently not the right redirect url path too. A ticket was open, but we are currently going by a trails and errors methodology…
-
How to set up a 4-4-5 calendar
1. Abstract Board offers the possibility to create custom time entities in addition to the standard time entities to customize the calendar to specific business needs. Our goal will be to build a retail calendar based on the scheme of a 4-4-5 quarter, which is a method of managing accounting periods, mainly adopted by some…
-
Issues with 'Detail by' sorting feature
This issue has popped up in the layout editor after I added an entity in the configure drill down. The data is tying out correctly for all my data blocks, the only issue now is when I try to drill down on a specific P&L line. The drill down shows every member in the entity rather than the specific line I am trying to drill…
-
Data Reader Configuration From Local System
Hi Team, I attempted to configure the data reader to load a CSV file from my local system. However when i specify the file path, no files appear to be available or recognized by the system. Please advise if there are any prerequisite configuration or settings that needs to completed before this step? Thanks for your…
-
Linear Programming Problems in Board
How can we solve Linear Programming Problems in Board - Nexel or Procedures or any other tool ? Example contribution maximisation with limited machine hours, what should be the product mix. In Excel we can solve this using solver addin.
-
Suggested value in Excel Add-in
Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?
-
Selecting Months for Single Month & Multiple Month graphics
I am trying to set up a screen that uses a single month selection for a waterfall chart and multiple months for a graph of monthly figures. I have managed to get a procedure that selects the last twelve months, however I could not use this selection alongside the waterfall chart. I have tried using a custom time entity but…
-
Data entry on if-function with inverse algorithm
Hello, I have no values in the column HR (Forecast) in some months. I would like to pre-populate these cells with a small number (here, for example, 5) in a new column to enable the cells to be filled by manual data entry. I have used an If function to fill the column: h= if(g=0,5,g). How can I create an inverse algorithm…
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
-
B14: Adjust the DataView Layout Editor - Configure a drill on last block option missing
Hi @Product Management Team, I think it would be great if the possibility to configure a drill action on a block in a dataview was available on every block. The last block in a layout can't be configured due to the "preview" button which obscures this feature: Best, Helmut
-
Handling of .cfg Files in Text File Data Reader
In Board 12 & 14, the Text File Data Reader has a limitation in how it handles .cfg files when a pattern filter is used in the "Connection" tab. This impacts the automatic mapping of fields and the correct configuration of the file settings, such as delimiters, headers, and other parameters stored in the .cfg file. Issue…
-
Level 200, Module 207: Data Entry is not working
I am configuring Sale Planning worksheet within Module 207 task. I am adding a Dataview object for Cube BUD - DE - % Increase, and I put Data Entry option = ON, but after applying and saving the configuration, the fields are not coloured yellow, and Data Entry is not allowed in Play Mode. I would like to know, what…
-
I need help to configure my GCR Application
I have pasted the capsules and clicked on "Version#".Then I clicked on the reset application button in GCR Admin capsule.Now when i click on "import" none of my entity gets loaded.Can somebody share easy step by step guides for GCR configuration.I have been struggling for a month.
-
Filename substitution formula in Data Readers
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: A new substitution formula @filename that returns the name of the file being loaded in the Data Reader. This formula could then be used in the ETL. Usage example: The client's cubes have the dimension "Month of…
-
ASCII Flat File DataReader - Move data file after reading
Dear all, I really appreciated the new "Delete file after reading" checkbox in procedures. I guess that, like most of you, our customer(s) require to move the flat file from its folder to another folder after its data was integrated into Board. However, most of the time, keeping the file in order to control the data loaded…
-
Substitution formulas in Data Reader path
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Have already existing substitution formulas recognized on the path field of Data Readers. Usage example: By using @database on the Data Reader's path, when duplicating a database, and renaming it, we wouldn't have to…
-
ASCII Data Reader - Load first/last rows
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Add a new setting on the Data Reader "properties" tab that allows developers to specify a certain numer of rows to be loaded, and choosing wether to load the first or last X rows of the file, and ignore the rest of…
-
Database security: Cube visibility
In the "Database Security" section, we have noticed that if we use cube visibility to define user action perimeters, it works everywhere except in dataflows. This behavior, despite being documented in the manual, seems quite illogical because if the functionality helps in profiling security profiles in a faster and more…
-
Procedure steps improvements
We would like to request certain improvements to the "Edit procedure" screen, to have a greater level of detail about each step's configuration and the overall view of the screen. New detail for procedure steps: The "Detail" column in the edit procedure screen shows information regarding certain configurations made inside…
-
Grand Total Group by format
Hello, It would be helpful if we could, in a layout, change the format Color and Font) of the Grand Total Group by. For now, it is not possible to identify easily the line (see capture attached) when the groups are collapsed. Thanks