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.
-
Sorting an Entity
I have an easy question, I have the following entity "Role" which appears like this in the Content tab: It seems that I can custom the order in which they will appear in any Dataview by dragging the elements in this content tab. My question is, if when the DataReader that creates the elements runs, it will mess the entity.…
-
Performance analysis tool to find out why a dataview report loading very slow?
Hi BOARD team, I built a simple data view report using Tab. Couple of tables are loading much slower comparing to others. The table is simple and highly summarized. Is there a tool in BOARD we can use to find out why certain reports take much longer to load? Thanks a lot
-
Substitution Formula in Broadcasting Not Working
Hi all, I can't get the @Selection substitution formula to work on the email sent by Broadcasting. Others are working like @User, @Date, @Time. Is there anything I need to do to make it work?
-
Overall Total for an Entity to be shown overriding the screen selection
Hi, Is it possible to get the Overall Total of an Entity so I can get the % of Total even when there's an active Screen Selection? The sample table below show all Entity. Let's say Entity A is selected in the Screen. I still want the All Entity Total to show 75 even when the table is filtered. I will use this value in a…
-
Alternative to "Feed" for Banner Communications in On-Prem Version?
Hello everyone, We are currently looking into the feature called Feed, which is intended for banner communications (e.g., displaying important messages from administrators to end-users, deploy notes etc). According to the this link Feed , this feature is available in the cloud version of the system. We are running the…
-
Last Value Funktion
Hi All, Is it possible to display the last value of a date type cube in a dataview? The cube contains the following time entitie: day, on which a Validity date is written. I tried it with the last value function, but that doesn't work. Does anyone have an idea, thanks.
-
👋 Fixing the article on OpenID for on premise
Hi @Board Community, @Board Support, Is it possible to correct the template openid.config at the end of the article in link bellow ? It's full of typos and not even valid xml (<add /></add>!) and apparently not the right redirect url path too.…
-
Add a calendar month entity within the time entity
Hello, I'm trying to add a calendar month entity within the data model properties. Calendar month is an entity which contains (JANUARY, FEBRUARY, MARCH) without the current year written. I mapped all the month to the level below which is Month but the basic relationship functionality does not work properly. I can't select…
-
Restore original screen view after - Apply my screen view -
Hi, any idea who I revert My screen view back to the original screen view? Br, Maik
-
Can we scroll data in bar chart horizontally?
Hi all, I want to know that can we scroll data horizontally in bar chart by limiting the amount of datas let's say total amount of data is 10 data and we want to initiate only 2 data will be shown and the others left we need to scroll it horizontally. Is it possible to do like that? Thank you.
-
Limitations when pushing data from MDB to RDB via Dataflow
All, Are we aware of any limitations when pushing data from an MDB cube to an RDBMS using a dataflow? Scenario Overview: We have an MDB cube composed of four entities - 3 General Entities + 1 Time Entity Entities Max Item Item Count Entity 1 100000 30141 Entity 2 1000 41 Entity 3 100 8 Month Infinity 204 The goal is to…
-
Drill Through popup : How many rows it can safely handle ?
Hello, Is-there any BOARD tech lead here ? Our users are using the drill through feature towards an SQL server database to see invoice accounting lines on SQL DB. However on some accounts, we have approx. 100 000 lines of invoices to display on the BOARD drill thorugh popup Question : Is the drill-through feature natively…
-
FileRead ERROR:File Missing what is the causes of Datareader file missing?
Hi all, I want to know the causes why when I tried to run Datareader manually, FileRead ERROR:File Missing always be shown? I have checked the path is ok. Any ideas about this issue? Thanks.
-
Search function / Excel PlugIn
I want to use the search funktion in the Excel plugin für an entity's ID. Unfortunately, it's 20 characters long. Can I configure the search function so that I get the correct result if I only enter the last digits and not the full 20 digits? Look at the screen shots. 1.) 2.) I get no result :( I'm looking forward to your…
-
Best practices how to show many columns in dataview (>10 columns with a hundred thousands data rows)
Hi all, I want to know the best practices how to show many columns in dataview with approximately >10 columns with a hundred thousands data rows in a dataview. Because I am stressfull a lot about limitation error rows limit issues. I have read many references from other forums/discussions about this one, and overall of…
-
Aggregate functions for Board Cubes
Hi, if you display a Board cube in a DataView and group it by an entity, then a sum is always formed for the values from the cube. Is there also a way to form an AVG(), MAX() or MIN() on the individual values instead of the sum, so that an average or a maximum value is obtained from the individual cube values? I would like…
-
Calculate Mix including Subtotals
Hi there, how can I calculate percentage mix including subtotals? At the moment it is calculated by group. The algorythm formula GT doesn't work since I have Years in the columns and it does the math for the sum of all years. However I need it by year. Thanks maik
-
Unsynchronized Procedure names
Hi, I needed to adjust a procedure that is assigned to a field in a Dataview. However I could find it in the data model. Because it has been renamed at some point How can I synchronize the names to ensure someone can find it? Thanks, Maik
-
Why does the "Previous Year" time function still return current year data?
I would like to understand why, when I enable the Previous Year time function on the cube, the result still shows the current year's data. For example, I only have data for 2024. However, when I activate the function, the values returned are still from 2024 — instead of returning nothing (since 2023 data doesn't exist) or…
-
Sorting in Data view with Detail by
Hi can someone shade some light into sorting logic with "Detail by" activated? a - is on the first spot and Detail by Year is activated - However it isn't shown in the preview When I move it to spot - b - I can see Occ TY by Year - However now the order of the other columns is screwed. Any idea how to fix this? Thanks Maik
