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.
-
Flexgrid - Column groupings disappear when I choose multiple Fiscal Years
I have Board 14.5 Column groupings work when I'm just looking at FY25 for example: Column groups in pivot mode are: Fiscal Year ā Quarter ā Month But as soon as I choose FY24 and FY25, the < or > to ungroup or group disappear, and everything is displayed by month with no options to group.
-
B14: Where to configure which options will be available in the contextual menu in Play mode?
In B12 it was possible to configure which options will be available in the contextual menu in Play mode, but I can't find where its possible to do in B14. See the picture how it used to look like in B12.
-
Board 14: selector issue
Hello, Following the upgrade to v14 I have the following issue: I have a selector based on CFI-valeur unbalanced hiearchy which is in relationthip with Etablissement [Enrichi] , as below: My selector is setup like this: With an admin role I see the selection as I expect (though I don't understand why it displays one parentā¦
-
RANK Function Nexel
I have country names in the columns and individual products in the rows. My cube returns the number of products sold per country. Now I want it to return, for each product, the rank for country X (only for country X; the other countries are not relevant here). I have reached the point where I can use the RANK formula.ā¦
-
Struggling with the REST API
Hi, I would like to use the REST API in Board to access it outside of Board. We are currently still using version 12.6.2.88217, but will soon be updating to Board 14.5. We have an on-premises installation. I have read the following documentation on this topic: https://help.board.com/docs/the-api-queries-sectionā¦
-
Flexgrid āFunctions & Formulasā pane
We have Board 14.5, but I still donāt see this pane. https://youtu.be/99bbLkeP0Hg?si=hDyJgpSu_vjnhXWe in this promotional video, minute 1:12 they show āFunctions & Formulasā. Do you know when this feature will be available for flexgrid? Is this enabling users to do formulas on the fly similar to how you would in Excel?
-
extract the metadata Database Board 14
Hi Everyone, is there anyway to extract the metadata from database and find two files "entities.txt" and "cubes.txt" similarly Board 10 Regards,
-
In which screen is a procedure used
Hi there, is there a way to see in which screen a procedure is used? SImilar to the cube analysis? Thanks Maik
-
Is there a way for a cartesian stacked bar chart to show % of total, similar to pie chart behavior?
-
Sort the Months in a Selector - Descending Order
Hi all, Is there a way to sort the Months in a selector with the current month on top and in a descending order? The default is it's sorted in ascending order i.e. very old dates on the top, which is not user friendly as we want to present the latest periods the moment they open the selectors.
-
Report design Ideas to have 2 nested entities on rows with outer entity have calculted measures
I have a question about a report structure and would appreciate any ideas to achieve it. There are 2 entities - Measures & Channel Measures have the following members - The last 2 AOV members are calculated using formulae achieved through rules Weight Volume Revenue AvgOrderVal/Order = Revenue/Vol AvgOrderVal/kg =ā¦
-
cubes best practices
hello, Are there any best practices in terms of entites in a cube ? I have the cube below which has only several entries and I'm not able to display it with a dataview on a screen but I'm able to display it in a flex grid. What is strange is that I'm able to display it when i run a procedure with breakpoints. Theā¦
-
Error when loading files from Azur
Hello, From time to time we have troubles downloading files generated with data exports from Azure with the message below. The same files works for several time and suddenly we cannot load it anymore: thank you, Catalina
-
What do the Longitude and Latitude do for Map Areas?
Hi there, I'm currently trying to use the Map-Feature more often. Espacially shapes. In the options for Map Areas I can choose shape name, Latitude and Longitude. But what exactly do the latter two do? As far as I understand it, all the relevant coordinates for areas are in the json-file you uploud into the Map-Object.ā¦
-
Board 14.5 flexgrid pivot, multiple nested column groups
Board instance: dolby-s1.board.com Screen: Revenue Input It's great that it collapses the columns when I have a 2nd column grouping under it. But now, when i expand a column for instance, it brings it all the way to the left, even if I expanded Q3, it'll bring it to the left of Q1 and Q2. Before expanding: After expanding:ā¦
-
How to join two tables in SQL Datareader in BOARD 14.6
I want to join two tables based on their multiple common fields.How to do that ?
-
Use Entity in Algorithm - Entity showing the count of members not the value
Hello, How can I get the value of Custom A Entity so I can use it in my Algorithm? Currently, I am adding it as a data block in the layout but it's showing the total members not the value. The by row has 4 Entities - Reporting Unit, Custom A, Group Account, and Comment. I need Custom A for my algorithm but when I add it asā¦
-
API Integration
We were loading the actual data in our application in BOARD with manual files. Now we want to integrate it with ADW Datalake. Please let me know how we could connect the servers with BOARD to fetch the data instead of loading it with text files.
-
How does BOARD handle concurrent execution of procedures?
Hello, We have a procedure which clears some cubes and then runs some data flows to reload the cubes. The procedure may be triggered by user activity. If two users cause the procedure to run at about the same time what happens? Does one run and complete before the other is executed? If not is there a way to single threadā¦
-
Pager / Selector change
Hi there happy new year. when changing pager selection or selector selection to whole screen is refreshing including collapsing dataviews. Is there a way to suppress that behavior.
