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.
-
XIRR calculation
Hello, Does XIRR work with NEXEL? I cant seem to figure out a syntax that generates any results. Not getting any error message or anything. Thanks,
-
Dynamic Color Alert
Hi All, I am seeking a solution for an issue I am currently facing. Specifically, I require a dynamic color alert, but it appears that I need to select the number to link to the color. Unfortunately, I am unsure of the maximum number that should be used. Kind regards, Andrea
-
Export Data to excel
Hi , when exporting an entire screen to excel. How is the order of the data views = worksheets determined?
-
Substitution Formulas
Morning, quick question I have a substitution formula in a dataview Selected is 31/01/2025 however it is showing today's date. How can I see the selected date?
-
Dynamic Visibility of Data Blocks (Hide When No Data is Present)?
I have a data view object that is storing 5 different report types in 5 different cubes. The rows are dimensioned by fiscal year and month and there is no dimension on column, meaning that the 5 columns are the 5 data blocks in the layout. I would like to hide data blocks (Legal Income Statement & Legal Balance Sheet in…
-
Can you highlight or show a marked value for a specific month in a bullet chart ?
Similar to this visual:
-
Data Entry with filters
Hi, In a dataview, there is one data-entry block, which is a cube with dimension by A and B. I need to have A on the row and B on the column. However, I need to show only specific members on B (Which I already flag by using another cube) Is there anyway I can do that as the filter on that flag cube does not work; the data…
-
Direct Links Don't Work When Capsule is set to "Hide Screen List"?
Our platform team made the decision to turn on "Hide Screen List" for some of our more common capsules, specifically to avoid inundating our users with reports that they don't need to be bothered with, amongst other things. However, whenever I try to send the direct link for a report to a user, it launches the home page of…
-
Cubes
Let's suppose I have a cube with dimensions month, scenario, version, competency and another cube with dimensions month, scenario, version, los, location. The end cube in which I am storing the value also has location at it's dimension. LOS and competency entities are in relation LOS being the parent and competency being…
-
Filter in Data layout
I have added a filter in data layout and the main value should be 1. Even though in 2 of the members of the entity (whose codes are used as filters) values are here but these members are not visible when in playmode but are visible in dataview when in design mode. Any resolution to this issue.
-
Validation rule smart import
Hi everyone, is it possible to set a validation rule in the smart import object that validates my data only if the column total (column F) is equal to 1? I tried different syntax but I'm always receiving syntax errors, can you help me? Thanks in advance for the support! Andrea
-
Total Calculation algorythm / nexel
Hi all, anyone an idea how i can fix the total / grand total calculation? You can see that i calculate the average per country however the calculation doesn't work on the Grand total line. the expanded view looks like that 42 isn't recognized as a number. any ideas? thanks maik
-
When a DB is loading in RAM, Board platform is freezing
Hello, When database "X" is loading in ram, then users have to wait for the end of DB load to access data on that DB ⇒ OK normal behavior. However, it also impacting other users that are working on DB "Y" already loaded in RAM. Users of DB "Y" are also stuck and can no longer access the data. They also have to wait for the…
-
Setting Up Version-Based Security for Drill-Downs
I am working on Board and have created a cube with two versions: one that includes an 'Employee' dimension, and the other without it (version 0 being the base with the 'Employee' dimension). In our Board screens, we have the ability to filter by 'Employees' and drill down to see the list of employees. However, some users…
-
Question Related to Data Integration
I have some question related to Board I hope that i will be able to get help for this, it would be really appreciated Here is the question : 1. Is it possible to board to import data with an insert update mode ( where there is a difference in the cell it will be updated , but if there is none it will be left as it is, and…
-
NEXEL + CROSSVIEW + COUNTIF not working?
Hi all, On the row "0" of the second layout, I tried a deepest entity formula Nexel: =COUNTIF([#Data;@a;*;Range.Vertical],"=A") but can't make it count how many "A" lies on the first layout. I've also tried: =COUNTIF([#Data;@a;*;Range.Vertical],"A") =COUNTIF([#Data;@a;*;*;Range.Vertical],"A") And many others, but can't…
-
B.E.A.M Forecasting Feature
Hello, I'm using board 12.6 version. Currently working on a project that requires some predictive Analysis. In my Data Model designer space, I can't find the B.E.A.M Forecasting tile. Is this tile unavailable for board 12.6 version? Does anyone have another approach that I can look into to perform predictive analysis?…
-
copy "date" type cube into a "text" type cube
Hi All, I’m looking for the correct formula to use in this dataflow: Cube D is a "date" type cube. Cube E is a "text" type cube. Don't worry for The selection I’m unable to find the correct formula in the IF Statement to paste the value into the text cube (TEXT(D),"DD/MM/YYYY"). As a result, the output of the dataflow is…
-
CLOUD DATA PIPELINE PORTAL
Dear , I am asked to use provided credentials on first login to the CLOUD DATA PIPELINE PORTAL. However when using the credentials shown on the screen, the login fails. Even using my board credentials , authentication fails Any idea please Rgds
-
Data View Layout
Hi everyone, hope you're all well! I was hoping someone could show me how I would go about creating a variance value between each individual month for and entire calendar year ? I have created an algorithm block for Net Investment and then created a 2nd block using the same algorithm to set it as the prior month value,…