-
Report Header in Excel
Greetings everyone, When I export my board report to an excel file, Headers are not export I need the Header(in red0 to be export with my report. Plus timestamp Any suggestion on how to get Headers exported with the report Thank you
-
DataClear log
Hello everyone, We have a question about data model log, it seems like not every DataClear steps shows on the log and we were ondering why. Does anyone of you have an idea please ? Sometimes the DataClear show and sometines not, as an exemple we have a procedure with many DataClear but only one is showing in the log and we…
-
Identify last non 0 value
Hi, I have a cube of 2 dimensions, Month Entity 1 In a procedure, I would like to identify the month with the last non zero value. I tried with the time functions as well as the analytical functions. I may have gone through those features a bit quickly and probably missed the solution. Would you have any idea how to do it…
-
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…
-
Geo Maps with OpenStreetsMap ( GoogleMaps) not working correctly
Hello everybody, we are trying to create Maps in Board 12.5 to show sales in countries where we are active. I tried to do it like described in the manual, but it is not yet working correctly. What do we have already - created a .json file with the six regions which we want to see - Marker Entity exists - Latitude and…
-
YTD Calculation problem
Hi All, I’m trying to figure out an easy way to do the YTD calculation. For example, if I have a cube where each month in 2019 has the same value (10 euros) and in 2020 has the same value (20 euros). i want to show on dataview the YTD data as following: Jan 19 (10 euro) Feb 19 (20 euro) .. and so on Dec 19 (120 euro) Jan…
-
Data View Configuration Options : zoom out, zoom in and change the scrollbar size
Hello, I’m looking for more configuration options in Dataview. Specifically, I’d like to increase the scrollbar size and explore the possibility of zooming out, similar to Excel, to view more columns in the table. If these options aren't available, is there any alternative? For exmple, could the Dataview be placed inside a…
-
Mass Communication To All Users for Planned Outages
Is there a method to manage communications to users through the sys admin section in Board? For example, we want to send a "planned outage" email to all users whenever we apply a patch or perform maintenance. A setting in the sys admin section would make it easy to send a mass email communication using the user's email…
-
Backup methods during the maintenance and operation phase
Hello. Currently, I am performing maintenance operations while having clients use capsules created with Board. I would like to take data backups as part of my regular work. As I understand it, the way to take backups in Board is to create a snapshot of the data model by making a copy of the files in a backup directory from…
-
Environment variable %COMPUTERNAME% into a txt cube
Hello, I'm trying to get the returning value of %COMPUTERNAME% variable in a data flow. I tried to the following solution : %COMPUTERNAME% and "%COMPUTERNAME%" in the target section and in an algorithm @COMPUTERNAME and "@COMPUTERNAME" in the target section and in an algorithm Using the ETL in a datareader with :…
-
Max occurrences shown in a @[entityname] label
Using a label with the caption set to @[entityname], it shows the codes of the selected occurrences up to a maximum of 12. From the 13th occurrence onward, it shows the number of selected items out of the total items in the entity (e.g., 14/5000). Does anyone know how to display the latter format (selected/total) even for…
-
Azure Storage Certificate Access
Dear Community, I got a good one for you. My customer wants to enable a certificate authentication on the Azure shared storage (Access Security) , would you have any documentation to put it up? Is there any best practice in order to secure the Azure Storage ENV ? Thanks in advance
-
Is it possible to select the years shown in the columns via selection in a Gantt Chart?
I have two date cube dimensioned by task that I need to visualise as a Gantt Chart. Now, I want to not show all the years but restrict it to only a few, however when I select years in the time dimension it does not restrict the shown years in the Gantt Chart. Is there a way to select the years I want to show?
-
Data Reader limits ?
Hi, I would like to know if there are any Text File Data Reader limits in terms of size of the data loaded. I'll explain : I have this DR which loads only the highlighted cubes without any error message. If I delete this 2 cubes, keeping the others, it only loads the 2 cubes highlighted following. The file I am trying to…
-
B14 Dynamic Engine : Missing tech info about improvements
Hi, In Board14, there is some improvements on the engine called "Dynamic Engine" However the board documentation is vague, it is more marketing oriented than technical. So we don't know exactly in which area we will have benefit and how to measure it when moving from B12 to B14. For IT guys, administrators that have big…
-
Board in Engineering goods / assembly
Hi all, Please let me if Board been used for 'Operational Planning/ Scheduling' for 'Made-to-order' kind of scenario - where BoM is tricky (engineering goods/ assembly). Even if it is not at a day / hourly level production scheduling it's ok
-
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
