-
Board onpremises with SSO over Azure Application Proxy
Hello, We use the Board service via an Azure Appiction Proxy. Now we would like to use SSO. Unfortunately, we always get an “internal” redirect URL https://server.internal/identity/sso/Acs as a return from the Board system. However, this is not accessible on the Internet. Is it possible to specify the redirect URL in the…
-
Filter Option in Layout
Has anyone encountered issues with the filter in the layout? I'm tryng to filter with min value >1 in some Cube value but report show all items also with zero value. Thanks
-
@selection_EX with Multi database
Hello all, I have a screen with the option "Multi Database". In this screen I have add 2 DataViews with 2 different databases. In both data views I add a label with an "@Selection_EX" to an Entity. As shown in the following screen I get only the Entity from 1 database displayed. Regards Stefan Batalia
-
Not more than one custom icon for capsules?
Good morning, I have copied a capsule, associated it to another data model and changed the custom icon it had in the first place. Now the copied capsule and the original capsule align their custom icon. This is how they looked at the beginning after the copy was made: After making the custom icon change, the next day, both…
-
exchange cube on premise
Hi everyone, My colleague and I are currently trying to modify the same data model on our respective PCs on premise. How can we exchange data cubes once we create one? (i don't want to send every time all the database) Thank you!
-
Delete/Update Entity members
Hi BOARD Team, If we want to change the Max Item for an entity, the best practice is to do it in test environment and then use the Transporter to update the production environment. Question 1: If I need to delete members from the entity, can I do it safely in the production environment? Question 2: I want to reload entity…
-
Creating Versions for Info-Cube
Hi Board Team, I have watched BOARD Academy video about optimizing cube performance by creating different version. Is there any disadvantage / issue for creating versions? Can I create version directly in the production environment? Thanks
-
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…
