-
Running Total
How can I calculate a running total in Board? I want to see how our yearly sales are pacing against our yearly forecast. Jan 10 10 Feb 10 20 march 30 50 april 50 100 may 5 105 ------------------------------ Michael Hyder, MBA, CPIM Global VEG Control Tower Process Lead Bayer Crop Science LP United States…
-
iPad Optimization
Has anyone found any screen sizes, settings or tips/tricks that improve the user's experience on iPad's? Thank you, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime Management (usa) LLC United States ------------------------------
-
Data Reader to Cube, can't find log file
another newbie question, thanks in advance for anyone that can assist !* I have several dimensions / entities + a flat file for a cube, in CSV file on AWS S3 * I am able to load the dimensions with no issue * I load the csv cube file, check the 'log' and 'stop on error' boxes * My log file is not in the same S3 bucket with…
-
YTD Selection Question
Hello, I am wondering if there is a way to have a specific month be selected whenever a year is selected. For example, if 2021 was selected the month would then select December 2021. This might be an obvious thing that I am missing. Thank you, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime…
-
Not working "show all" at row settings
Hi there, I'm wondering if we can't use data view settings "detail by" and row settings "show all" at the same time. If I set "detail by", it shows all data(zero) although setting "show all" . I want to hide row having zero. Could anyone help me solve this? Kind regards, Marie ------------------------------ Marie Kawakami…
-
Best practices on Smart Import object & data control
Hi everyone, I'm doing some testing on the new summer release to evaluate how some new functionalities can help in our internal roadmap. In particular I've been testing the Smart Import object which will definitely help us solve some use cases. I have tested the following settings which seem fine :* Add or discard new…
-
Change Entity to Display Code
Hello, In a dataview, I would like for the @month entity to be displayed in it's code form. I do not see this as an option in the dataview settings but could be missing something. For example, when June is selected and the year 2022 is selected it is displayed as "Jun.22" but I would like its code, "202206", to display.…
-
Conversion from Time (text stored in Text cube) to number?
In Board 10 we used two text cubes for data entry for start and end times and cube with a nexel formula in the Data View to calculate the difference using value to convert from a time to a number. e.g. =value([@a;*;*])-value([@b;*;*]) While this displays properly in the data view, in Board 12 the result no longer gets…
-
Display Entity Description in Data View
Hello, I am attempting to apply logic in a data view only when specific Months are selected. When I use the Month entity in the data view, it displays the total number of months selected. I would like for it to display either the selected Month description (January, February, etc.) or the number associated with each…
-
Error Codes
Does anyone have a link to a page listing error codes with explanations? Does something like this exist? ------------------------------ Matthew Sobon Data Analyst M.T. Maritime Management (usa) LLC United States ------------------------------
-
BOARD R Calculation Step
At this point, BOARD's software includes an R calculation step. This supposedly allows users to run R scripts on data extracted from BOARD, then read the results back into BOARD. Unfortunately, the server package used to connect BOARD to R, Rserve, is known to have several IP connectivity issues when used on Windows. The…
-
Deleting entity members in Board 11
Hi Fellow community members, In Board 10, deleting entity members was/is against best practice. Has this changed in Board 11? I reckoned this might be the case since also the max item# property is not there anymore. If yes, is there a difference between a migrated database and a fresh Board 11 database? Thanks for your…
-
Procedure to Show Hidden Blocks
Hello, Does anyone know if it is possible to show hidden blocks through a procedure? Or something similar. Thank you, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime Management (usa) LLC United States ------------------------------
-
Power BI Connector for Board | Login issue
Hi All, I want to ask if has anyone been successful to set up connectivity between Power BI and Board? I followed the steps as per the documentation. It states that we do not need any redirect URL when working with Power BI, but it doesn't show any login screen. It prompts me with the below error. I have tried clearing out…
-
Trend line in a chart
Hello, I want to make a trend line in a chart like de red line. I tried with the time functions Trend but that does not work. Someone a solution ? Kind regards ------------------------------ carla Janssen Business intelligence specialist Attero Netherlands ------------------------------
-
How to use the pause function with Pagers/Selectors
We have a screen that contains 4 pagers, the setup now you have to select each page and wait for it to display before you move to the next selections, Is there a way you can pause all selectors/pagers so the output is only displayed after all selections are made. Thanks ------------------------------ Olu Shonowo Financial…
-
B11 vs StandAlone partner licenses
Hello With the full web approach it seems stand alone licenses, commonly used by partners, are no more working. How they can connect ?
-
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…
