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.
-
Dynamic Data View Block Headings?
Hi, I would like to ask everyone: what options do we have when we wish for dynamic headers in our data views? My client is still in Board12, but we have a Board14 upgrade planned for the near future. Specific issue: the client would like to have a report that has dynamic headers with regards to months and versions. There…
-
Flex Grid displays "No Rows to Show" when having more than 10 000 rows
Edit October 04, 2024: The issue has disappeared over night, Flex Grids are displayed again in full. Best regards, Patrick Hi all, I am experiencing that the flex grid does not show data ("no rows to show") when the combination of several entities is more than approx. 10 000 rows. I've build the same layout in a standard…
-
Wildcards in header failing in export to pdf
Hello, I use entity wildcards in the print header when exporting printable report to PDF. When used with the Page by function, sometimes the header says NONE when it should say a valid selection. The same wildcard in a label on the screen or in the data view header will work, just the export header sometimes fails. Any…
-
Difference between 0 and NULL with Data-entry
Dear all, since it is available the option "Differancate zero and null" on data entry intro the dataview how this information is managed in the cube? On my knowledge of the platform I knew that 0 could be both 0 or NULL under BOARD point of view. If the option is enable and data-entry is performed: 1. DE 0 -----> which…
-
How to calculate % of current month using Days cube
Hi Board Team, I would like to calculate how many percent is passed for the current month. Basically, use today's date divides no.of.days in the current month. For example, today is 9th Oct. I would like to achieve the calculation of 9 divides 31, which is 29%. Can I use BOARD default time entity Day and Month to achieve…
-
Data Model Snapshot - Environment Type Incorrect
I noticed when creating snapshots of my data models in the production site that the Environment is listed as "Dev" and not "Platform." The instance is correct for the production site and I confirmed on our admin portal that the Instance Type is Platform, however it's showing as Dev in the Data model snapshot. I can get…
-
How can I flag all periods between 2 dates?
Hi, I need to load some discount values from a table in SQL but the table does not have a month column. Instead, we have 2 separate columns; for Start Date and End Date. In normal circumstances, I would just take the last value from each of these dates and subtract the two lists, leaving me with the period between being…
-
Top-down flagging in one data layout, on any level
I am wondering if anyone can give me tips on how to flag members of an unbalanced hierarchy (or a regular hierarchy if it would work with that) in one data layout. The client would like to use an unbalanced hierarchy, and just select something on top level and have that pushed down to lower levels. I would like to know the…
-
Accessibility: font size
Hi Board, I am looking for some accessibility tips. A client of ours has an issue where most users are happy with the current fonts our Board solution works with, but they have some users who have issues because the fonts are too small for them and they can't see them. Simply using the browser built-in functionality of…
-
How to track flexgrid layouts performance in the logs ?
Hi all, everything is in the title, I'm looking for a way to monitor the performance of flexgrid layouts in B14 the way we do it for dataview layouts, but I did not find anything in the logs so far. Any idea? Thanks, Etienne
-
Recursion - Loop
Hello Guys Is there a way that we can execute a recursion logic in board for example, for the productnumber ADVE0001, we are looking for conversion from ctn to kg, so we need to look for the fromunitsymbol where it is ea and tounitssymbol = kg, this is the simplest scenario from CTN to ea and ea to kg It could have been…
-
shortcut key ">"Value is not reflected
When using the Board cell input shortcut key ">", There is an issue where the value is not reflected in the cell to the right of the input cell. Please tell me the solution.
-
Use Procedure to dynamic select value for LAYOUT
Hi BOARD Team, I understand we can use procedure to achieve dynamic selection for Data Block reference. Can I do the same to make a selection to LAYOUT? Thanks
-
Hide blank records when Data Blocks alignment is Vertical
Hi Board Team, Normally, we will use the FILTER to hide blank records. But once I changed the Data Block ALIGNMENT to vertically, the filter is not working any more. How can I hide blank records when Data Block alignment is vertical? Thanks My Axis properties are NOT selected as Show all. Thanks a lot
-
Custom Time Entity
Hello Friends, I have a requirement and wanted to know how to approach it according to board best practices. I have a requirement whereby during the year i have two student intake namely April and October. Example ; Current Year 2024, April 2024 and October 2024 are my two intakes. I need to split the April intake sales…
-
UI Layout creation
HI We have a requirement of having UI display with multiple dimensions of Product hierarchy (Vertical), Measures Vertical and Multiple dimensions of Calendar hierarchy (Horizontal) with collapse/expend both horizontally and vertically and editability feature. we also want to see Metrix at every product and calendar…
-
D365 Data Connector Security
Hello friends, Wanted to know if any of you is using the D365 dataconnector to connect to Board and how you are doing it. I understand that the dataconnector allows for read/write on D365 which may pose a security issue. Anyone of you who has succeeded in having a connection with read access only on D365 (Database…
-
Can I specify the position of data label and change the color?
Hi BOARD team, I had a chat as following with primary axis (Bar) and secondary axis (line). I choose to show data label for both. At some months, those two numbers will overlap. Can I force the data label for the bar showing inside the Bar? Can I choose color for the data label? It seems like it is only default to black.…
-
Many -to - Many
Hello, Is there a way to get around a many-to-many type relationship in board? I know bridge table concept……. However, it doesn't seem to help in my case. Thanks in advance
-
French characters (accent) displaying as symbols
Hello Friends, We are currently facing issues with uploading of data which french accent caracters Cedilla (ç) Acute accent (é) Circumflex (â, ê, î, ô, û) Grave accent (à, è, ù) Trema (ë, ï, ü) The accents are converted into strange symbols which should not be the case. How do we overcome this issue. Thanks