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.
-
Numeric cubes only in double
Hi, A long time ago I received the following advice: only use "double" cubes. Loading values between int and double, or single and double types could be buggy and fail unexpectedly. Is this still advice we should be following? I have been creating all my numeric cubes as double types, even the matrix cubes that are always…
-
Data view formatting
Hi, I want to format the heading of a Dataview and a I don't find how to do it: I want to get all the blue headings from the below screenshot in green. I have tried to do it through the Block Format but I could only modify what it already appears in green. And I also tried to do it thought the Templates but I could only…
-
Unexpected behavior when setting up database security
Hi, We are trying out a new database security setup at a client. For now, we are adding security on one hierarchy, cost center lv0-3. Our security cube has the Lv0 entity, and has user. In the custom selection script, we have Select User = @User. This ensures that the system always only looks at the security set for that…
-
Data flow: Copy cube down to a more granular one
Hi, we have a cube with data at Regional level and would like to copy it to another Cube at Country level. So we are going from a higher and aggregated level to a more granular one. The target cube has already data so we would like that the copy spreads the total by Region to its different country members. It should be…
-
In capsule, how to restrict procedure launch for read only user ?
Hello, In BOARD we have a P&L capsule shared between 2 user groups Controlling user that are allowed to launch procedure that may change data like clear data / reload data from ERP / launch allocation Reporting user that should only have read only access. They should not be able to launch procedure. The issue is that "Read…
-
How use an algorithm picture on parents aggregation
Hello, I would like to use my algorithme picture on parents aggregation, When I use it it's working on children but not on parents. Have you a solution to display the picture on parents ? Best, Shanèse Rouabah
-
How to manage three different rules in the same layout
Hi, I'm in the situation described by the title. The rules are based on the same entity, but I want to use them in the same layout due to the type of calculation the user selects. Have you got any tips?
-
Programming language
Hi, which programming language was used to program the Board 12 Engine? C#? And which web framework was used to implement the Board 12 clients for the browser?
-
SQL LOG 👀
Hello Dear community ! 👋 Where can i find the Log after running an SQL DataReader? (the log box is cheked) Thank you in advance 😉
-
Switching versions in a single screen
Let's suppose we are on same screen and I want 2 versions of the same screen. In first version "v1" user is entering the data and then user switched to second version "v2" where data entry is locked. I want that after entering the data, user can go to the "v2" version by just clicking on the label.
-
updated ETL Functions list 🫡
Hello dear community 👋, Can you please share with me the latest list of ETL function (other than Right/Left/Len/concatenate) By the way, we are using Board V 12.6 Thank you very much in advance👍️
-
Error during installation of OPC
Hi, during the OPC installation, this error appears in the step where the DATA PIPELINE credentials are entered, does anyone know why?
-
How to color only the top of DataView
Please tell me how to color only the top 3 numerical values in the data view.
-
Label subtitution formulas to view a layout selection on a specific entity
Hello using substitution formulas I can highlight in a label the selection for a specific entity. e.g. @Year returns the selected year. But, as far as I understand, if I want to show a layout selection I can only use @Selection_Ex(Layout="Layout_Title") without the capability to choose one entity Is there any way to obtain…
-
Function similar to ABS of excel
Is there any function similar to ABS function of excel to set rules in board.
-
Task Scheduler in on-prem
Hello, In a Cloud environment, we have the Cloud Administration, where we can use the Task Scheduler to schedule Procedure starts. In an on-prem environment, where can we access Task Scheduler, or something similar where we can schedule Procedures? I'm looking to schedule backups and also loading data and entities.
-
How to : Mass renaming of member codes
Hello, I have a requirement to rename 10 000 members codes for 1 specific entity I know it is possible to rename a member manually through the entity interface but I have 10 000 members… Clear and reload does not seems to be the right solution because I have selection on procedure on that entity (+ lots of cubes to export,…
-
Calculate difference between two dates?
Hi there, I am trying to calculate the difference between two dates as part of a dataflow, which has previously worked, but is no longer working after the 12.6 update. This is a smaller subset of a larger calculation, but have narrowed down the issue to be related to the dates. You can note below the cubes have different…
-
Multiple subtotal lines in a granular data view
We're a homebuilding company and have a granular data view of our Gross Margin Analysis. It lists all of our addresses by community with their respective prices/costs/etc. Currently, we're only able to display one subtotal line for each community. However we would like to show multiple: Total, Average, etc. Has anyone…
-
Problem Mass-Modifying Users on IDP (Subscription Hub) with a csv file
Hello community, We faced an unexpected problem lately that paralyzed operations for one day. When modifying the security of our application, we had to mass-modify the User roles on the User management screen (Sub Hub IDP). The quickest way to do this is loading a CSV file. At first, we exported the then current User file…
