-
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:
-
Is it possible to have a different layout for the drill-through and main dataview?
We want to filter the drill-through based on a specific block so we want to create a filter block. We want the drill-through to hide rows where the Fiscal YTD is zero, and we want the main dataview to filter where WS P&L Filter is zero. Is it possible to have a different layout for the drill-through and main dataview? We…
-
Rounding not working in dataflow with BOARD 12.5.1.1
Dear all, I am using a BOARD Cloud instance. I have a cube V10, type double. Since this cube manages quantity in a planning process, I need to first perform Qty: V10 = value\price then I need to round the value. I have tried this: 1. Define a dataflow with round(V10,0) 2. Copy the value from the cube V10 to another cube…
-
How to flow data among blob cubes using dataflow procedures ?
.
-
Dynamic Selection
Cloud Version: 12.6 0288217 In a Procedure, I use a Dynamic Selection within a Selection (see screenshot 1). The cube, the selection is referring to has one entity (DustinUser). But no DustinUser is ticked in the cube. The cube is totally empty. When running the Procedure (Step 12), all members get selected (see screenshot…
-
How do I change the font size in a gauge?
We've got 2 gauges in our dashboard and they seem to have different font sizes. The size of the gauges is the same. However, the option to change the font size is disabled (in light grey). Sooo: Where do I change it then?
-
Cube Visibility & Cube cells locked by
Cloud version: 12.6 0288217 Hello, I can't get Cube Visibility (Deny cell editing in Database Security) combined with Cube cells locked by to work, even if the cubes are not conflicting. This is the error message shown on the Screen when you log in as a User (not Developer). The error message itself is not explanatory. Is…
