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.
-
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,…
-
Dynamically select the Last 12 months based on the Pager value
Hello, I am trying to find a way to select dynamically the LTM for a bar graph in a screen that has a Month pager. I created LTM Flag cubes and a procedure based on the example made by @Sudeep Palkar and modified it to work with months but no success. Please how can I make the procedure that sets the flag work? I am…
-
Conditional Formatting on Bar Graph
Hello, I may have missed something here but is it possible to apply conditional formatting on a Bar Cartesian so that all bars that have positive values will be green and negative values red? As of now, I can only format the graph background by using the Color Alert, and Visible and color blocks in Object Settings.
-
Rest API - Post-Call
Hi, we are currently exploring the REST API and the process of using the POST method to push data to board. While we have figured out how to use the POST method to initiate a procedure (by making a GET call to retrieve the data), we are specifically looking for a way to directly post data to the board. Is there a way to…
-
Board starts in a loop after login with Board v14
I just installed Board v14, and when I open Board it pops up the log in screen, after entering my credentials it stars in a loop that never ends, if I downgrade to v12.6 everything turns to normal, any thoughts about it?
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
-
BEAM - Outlier Cube not populating
Hello, For some reason the outlier cube is not populated with I run forecasting. Other output cubes are populated just fine. I introduced a significantly large value so it should clearly identify it as an outlier. However, It does not populate the outlier cube. The structure of my outlier cube is in line with the actuals…
-
Top n, Others, and Total in Data View
Hello, How can I display the following in a data view: Top 5 Clients with its total which is "Top 5" Total of the remaining clients in the "Others" Lastly, the Overall Total in "Total Revenue" I think I can do this by having 3 separate data views (Top 5, Others showing Totals only, and then Total Revenue also showing…
-
Edit Max Item Number
Hello, I noticed that it is not always possible to edit the Max Item Number of an entity. In which cases the max item number is locked ? Is there a way to change this behaviour ? Thanks for your help. Ian
-
Can we make one entity Parent of 2 Child Entities
I have a Use Case where I must show totals as KPIs for a few Data Points. The Data Points are at an intersection of 2 Entities - non-related to each other If I use these cubes directly to show the KPI, the KPI Value changes by changing the page's selectors. I was trying to bypass this by creating an entity that is the…
-
Change the TOTAL text in Data View
Hello, Is it possible to change the TOTAL text in the row and column header to something like "Top 8" and "Year Total"?
-
Data Flow calculation to total
Hi all, when i have a Data Flow setup in the procedure it does the calculation for the entities but not on the Total Level. How can that be done calculated (not average) on the total line, too? Thanks Maik
-
Vertical % Not on Grand Total
Hi, is there a way to show the Vertical % in Data Views as well for grand totals? (FC REV MIX in my data view) I can see it by column