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.
-
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…
-
Is there a way for an admin to view/edit/delete all the subscriptions users have created?
I am assuming if there were a lot of users creating long running subscriptions it could potentially tax the system. In other tools, I have the ability to shut them down, or create scheduling blocks. I am new to board, and not seeing that…any ideas board community? Thanks! Matt
-
Convert varying to Text
Hi All, I want to import values from a postgre database using Data Reader. However, some values are in varying format. How can I convert them to text in the Data Reader?
