-
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 😉
-
Session Expiration Timeout
Hello all, I have a question to the following: Does the text highlighted in green mean that the session timeout is now switched off by default? An open Board session is not closed automatically if the user is not working in Board? We are working with the Board Version: 12.6 Revision: 0.2.88217 Kind Regards Stefan Batalia
-
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?
-
Workflows
What are some common workflows? What are some ways procedures have been used to facilitate a process or user experience?
-
How do you build a report that shows Data in multiple Rows instead of columns?
Hi, We are trying to build a report that has multiple Data Selectors say sales and sales PY that show up as rows. Currently the data selectors are showing up as columns. The report Axis is "BY ROW nothing" and "BY COLUMN Quarter Month" The data has two Data Selections. Sales and Sales with a time adjust for PY. When you…
-
Accessibility Requirements according to EN 301 549 (European Directive)
According to the European Directive EN 301 549, we are obliged to meet Accessibility Requirements for people with limited or without vision as well as for people without perception of color. In general, software and web applications shall be perceivable, operable, understandable and robust. Those criteria are specified in…
-
Map chart issue
Hello Board community !!! Im using Board Version:12.6 Revision 0.0.085662 Im trying to create a map (openstreetmap) showing sales by country. The maps is not working and i have bubbles stuck in the corner of the map. I followed all the steps showed in the "tips and tricks" video of @Sudhir Raju. Here is the settings: Any…
-
Problem: Impossible to use special characters on Labels, Block Formats and others
Hello community, Board application is refusing the use of special characters that we need to correctly write in French (e.g. é, à, è) or even currency symbols (I tested € and £). Any time I write a special character inside a label, new cube name, block format, security role, etc, Board will clear the field. This is a big…
-
Data View selection
Hi All, I have the following task: We need a Report -Screen with two Data Views and the following three Pagers for selection: Year, Industry and supplier Two Data Views with supplier in lines and value in column with difference blocks. The first Data View should show the figures of the complete selection. The second Data…
-
Cycle 3650
Hi Board Platform Does anyone know what "Cycle 3650" does? I attach the details of the dataflow where I found this. There's a selection on 40 months (I assume all picked) prior to the dataflow
-
Messages in BOARD 14
Hello, I just saw the Customer Connect Webinar on BOARD 14. And there it was said, that the Pop-Up Messages will now appear in the bottom right corner, instead of the top middle. Is this hard coded or can we adjust that. We use those messages a lot to guide users through procedures, so I want them to pop up in their direct…
-
Analysis shows nothing
Hi Board Platform, do you know what could be behind this situation:
