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.
-
Board Engine will not restart after server was unresponsive
We came into a server this morning that was unresponsive after a reboot the Board Engine will not restart we get the following error in the event log.Board 10 Server is starting. Configuration: C:\Program Files\Board\Board Server\server_config_v2.xml License: C:\Program Files\Board\Board Server\Nampak Production 19-20.Key…
-
Colours for Risks & Opportunities chart
Hi, I would like to use the red and green alert for my risks and opportunities chart. It is a very simple bar chart with one data view. I turned on the data alert on the cube but it doesn't come through in the chart. I looked at every option in the chart but I can't see anything in the settings. I can't use waterfall for…
-
How to add alerters to a chart
I need to add an alerter to a chart to highlight the week a product is on promotion. The chart is by week. I have a layout above that shows the data for the product by week and the weeks the product is on promotion are highlighted. The layout is a master layout that drives the chart below. When the user selects a product…
-
Timebar/Selection to current month
Hello again! On my Screen im using a timebar for the selection. If someone enters the screen, it jumps to the actual year 2018. The problem now is, that it shows me all the months in 2018. What I need is, if someone enters the screen, the timebar and all the charts should only show values from january until the current…
-
Drill through more than 7500 rows.
Hi, I have a trouble with drill through. When the user make a big selection, specially under "Total", I received an error message like "The query returned too many rows." this happened when the query result is more than 7500 rows. In this case the most value is 27000 rows for one month. I use this kind of query to run a…
-
How to substract last month from this month using procedure
Hi there, We use Board 12.3. I want to know how to calculate the total of product B. Please see the table below. I want to know how to create cube and use procedure to calculate this result. Jan.22Feb.22Mar.22Apr.22productA999b.200100100productBa.500c.300200100 (c)300=(a)500-(b)200 This cube has Date types. Thanks for your…
-
Power User prohibits procedure execution
hello I want to limit the procedure execution of a user who has a Power User license. Even if you turn on "Deny procedure editing" in the profile the following situations cannot be avoided. -> Procedures can be set with label actions -> You can execute the procedure from the label in play mode. I have a Power User create a…
-
Pager different selection in a container "Panel"
Hello I would like to create a 2 panels with the same dataview but with not the same selectors. The goal is to see the data in both dataview in same time and then easily transfer data from the first layout to the second layout through a procedure. Currently when I select a pager in the first panel, that changes also the…
-
Slow DB loading
Hi, I have a scheduled daily procedure to load the data into Board. I noticed that before running the procedure steps the Board Engine loads the DB in memory. This is correct, since I scheduled the service restart every night. The problem is that the DB loading takes around 2 hours. I can't change the time schedule of the…
-
Cell Formatting
Rich Wojcik, Paola Mason and I are working on a scorecard solution. We would like to refine the formatting to be cell-specific. Consider the following scorecard as our starting point, and I'll describe our challenge. On the above scorecard, we want to be able to identify percentages with a (%), dollars with a ($) and…
-
BoardEngine service will not stop
Hi, I'm running Board 12.2.0.0.67608 on-premise. I need to change the diagnostic log level settings in the config files, but when I try to stop the BoardEngine I get an error,Windows could not stop the Board Engine service on Local Computer. Error 1061: The service cannot accept control messages at this time. The service…
-
Excel and Web log in at same time
Hello, It would be very helpful if we could be logged into Board Excel and Web at the same time. There are many times that I am monitoring users submitting data on the Web and I'm in Excel refreshing files. This causes me to get logged out of the web and go back in, click on the capsule, then screen, then select the…
-
Get cube values for first and last element of selection
Hi, I need to show in a data view a column with the values related to the first element of a selection. I also need a column with the value for the last element. For example, the selection is for the months from January to June. I want the values for January. I used the ANALYTICAL FUNCTIONS > First Value, setting the From…
-
Effective approach to copy data from one version to another
When we need to copy data from one version to another, we usually adopt the temp cube approach. Copy data into temp cube without the version entity and then write it to the original cube into another version. This could be quite a bit of a task if you are required to copy data for all models, there could be a large number…
-
Block hidden if
Hello, I have a layout with 3 blocks. All have data entry available. I would like to display the third block only if the user has selected a specific entity. Let's say my entity is the year, I would like to display the block "c" only if the user has selected the year 2022. If the year is not 2022 i would like to see only…
-
Month entity without year
Hi, I'm using a dataview for sales analysis. On the rows I have the year entity. I need to put the month on the columns, to get 12 columns of data (1 for each month). If I use the Month entity I get one column for each month of each year. My Year entity has 5 years, so I get 60 columns. Can the month name be extracted from…
-
[IFRS16 APP BLA] Cube Corruption
Hi, We recently had a problem with a procedure because some cubes were corrupted, are there any best practices to follow for to prevent this problem in the futute? The version of the BLA database is 12.1. Thank you in advance for any response, Francesco. ------------------------------ Francesco Tufaro Consultant TECHEDGE…
-
Hide screen in menu
Hello, I'm starting with the new board (V12.2) and I'm struggling a bit to add a menu. With the previous version (V10.7) I was able to select manually the screens to add in the menu. Unless if I'm wrong, it seems with the new version we cannot exclude some screens ! (it's all or nothing) I have some screens that i want to…
-
Data View with data entry and pre-set values
Hi guys, I have come across this when trying to create a new screen for a revenue centre. What I want to create is a similar function to Vlookup in Excel (see below). Client is existing entity in Board. Class is a data entry cube. And i'd like to have revenue to look at another mapping table. When user entered class as…
-
Corporate Identity Designer in BOARD 12.2
Dear community, We are going to updated from BOARD 10.3 to BOARD 12.3. Currently, we are missing the Corporate Identity Designer in BOARD 12.2 Has anyone seen this feature in BOARD 12.3? Regards, Jörn ------------------------------ Jörn Constabel Controller Braunschweiger Flammenfilter GmbH Germany…
