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.
-
Interacting with a Dynawrite Object
Hi Everyone, does anybody know how to write on a dynawrite object on play mode?
-
Drill Down
Hi all, is there a limit how far you can drill down? Thanks< maik
-
Column Entity Always Show the Total Members and Not Display the Actual Value in Dataview
I want to know the causes of why my Part Number column entity always show the total members and not display the actual value? Did I have some mistakes in mapping my cubes? FYI : Cube (Mixing Ratio)→ Have 3 entities mapped into it (Part Number, Plant FG, Supplier/Cost Center) And here captures of my settings in Layout…
-
Blob Cubes (Custom) Upload and Download Functionality
I'm creating a screen within our business planning capsule that will be a single data view object intended to store various file types that offer supplemental information over what's provided in the business plan. I would like for the file inputs to be heterogenous, so that I don't have to create a cube specific to the…
-
Selectors - Active Selection
Hi, We have a Selector on a screen which shows the Active Counter and Active Percentage. The entity of this selector is previously prefiltered by a On Open Trigger procedure. This makes it display 20/50 elements even if the user has not Selected anything. From the user point of view, he/she should only see 20 elements. And…
-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
-
Run an SqL data reader on the current selection
Hello, I'm running a data reader from a procedure with the YEAR (called Année) selection. I would like to scope the data based on the current year (selected when the data reader is run). Below the SqL command. I guess I should write something in the "Where" section. I tried with @Année which did not work. Thank you very…
-
Cleaning data in Data Reader with exclusion rules
Hi everyone, I'm currently working with the Data Reader in the Board Platform and I need some help with cleansing rules. I would like to exclude certain rows from being loaded into the entity based on specific conditions. For example, I want to prevent any record where a value starts with "5HR014" from being loaded into…
-
Account Set up
Hello Community! My boss/Board expert just left, and I have a simple question for your experts out there! Where can I go to see how an account is calculated in the P&L? Thank you for your help!
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Board call API using OAuth 2.0
Hi Community, I want to create a Board "Data Source" connector to Google Drive API using OAuth 2.0 authentication. I have created an id application on Google Dev/Cloud. But I am not sure about the Board Callback URL section. For now, I use url callback: https://my-domain-name/en/Callback.html. When I create a Data Source…
-
Adding Blank Rows that Mesh with Block Format
Hello! I'm working to enhance our current P&L report to improve vertical readability. I'm doing this by adding "Blank" members to the entity used in the by row configuration underneath key metric milestones (ex: Total Rev, Total COS, GP, etc.) No problems there; However, the formatting is clashing with block format since…
-
Example of the new @ProcedureId Substitution Formula
Hi, In Board 14.3 there is a new substitution formula called @ProcedureID. Can someone give an example of how we can use this new substitution formula? thanks RJ
-
Hidden cubes
Hi, Is there anyway I can unhide the cubes for development? I saw some cubes already set up as hidden in DB, not used anywhere, and I want to utilize those cubes. I looked but could not find where I can unhide those cubes. Thank you for your time reading this.
-
Session automatically expires after 15 minutes
Hello everyone, after upgrading to Board 14.3.0.0 (we have an on-premise IIS instance), we're encountering an unexpected session expiry after 15 minutes, even without user inactivity. Is this a known issue in the latest version? We faced a similar problem with v14.1, which was resolved by upgrading to v14.2.1. We haven't…
-
Add new entity worked but disappeared in layout editor
Hi guys, I have found some bugs in Board. So when I tried to create a new entity as usual it's worked and displayed in entity list, but I can't find it in Layout Editor without dragging any cubes inside to the data block first. Can you help me why it is happened?
-
Dynamic Selection on a Layout
Hello everybody, I'm using Board 14.1 and I have a question concerning the dynamic selection. I have 2 flex grid in 2 tabs on my screen and I would like to make a dynamic selection on these 2 flex grid. A dynamic selection on the screen is not an option because the dynamic selection for the 2 flex grid is different. Thank…
-
Radius search for map object
Hello everybody, does anybody has experience or an idea for a radius search on a map object? Means, to type/select a radius on a selected article on the map and draw a circle/select all the customer in this radius. It is to show the salesman which articles has potential to be sold more in this range. Feel free to give…
-
License Management
Hi Everybody. I need some help. I was updating the roles and licenses in the subscription hub and, in doing so, I assigned the role "User" where there was the Developer one. As a consequence, I lost the visibility as Developer since no developer license was assigned anymore. I cannot change and access to the subscription…
-
Algorithms
Hi, is there a possibility / syntax to refer a algorithm block (using the formula “rt(x)” or “dt(x)”) to only one or more certain columns and not to every(!) column of the entity that is set in the column axis? Can somehow specific entity members be adressed? I want to achieve that there are different color alerts for…