-
How to find the unique ID used by Board of a member of an entity
Hi, Board is referencing entity members based on an internal ID. => How can I see that internal ID for each members ? Because when we want to migrate procedures and screen from DEV to PROD, then procedure and screen are not calling the right member on PROD because internal IDs of member are different in DEV & PROD. If I…
-
Dataview Layout: Impossible to apply a filter when an aggregation function is used
Hello community, I'm quite new here. if this is not the right place for this question, please redirect me. I have a Dataview layout in which I use an aggregation function to display the average value for my block along the time entity "Month". When I try to apply a filter to this layout, it has no effect. However, when I…
-
Culture-sensitivity with @datetime in Smart Import
Hi, I have a bit of trouble with culture and the formula @datetime. I have a cube that is populated 2 ways: either the user uses a smart import object to fill other cubes, and then the datetime information arrives into this timestamp cube using a formula. Or, if the users don't want to input anything, they can click a…
-
Dataview display "NaN" instead of empty ? Bug ?
Dear all, Today some of our dataview are displaying "NaN" instead of empty values Do you know the meaning ? Is-it a bug ? Have you already faced that behavior ? Regards julien
-
% sign with a value.
Hi, I am creating a report and I am using expression in rules to calculate Gross Margin %. It is calculated correctly but I cannot put % sign with the number. Is there a way of doing that.
-
How can I access +Rule to access rules configuration.
I am trying to create some rules for board reporting but cannot find the window where I can create rule.
-
Colors for Bubbles in GeoMaps (OpenStreetMaps)
Hello community, we are on Board Version:12.3 Revision: 0.0.70028. We are trying to create a very simple map with shipped quantity by shipping destination point. The maps looks correctely defined with latitude and longitude for each shipping destination. Bubbles dimension is working fine while defining the Radius by…
-
Presentations are not working after Update to 12.5
Hi, Does anybody has the same problem? Most of our Presentations are not working any more. There is no way to edit or show the data. Even the “sava to”-option is not working. Some of the presentations are fine, but we do not know why.. Kind regards, Marco
-
How to add row number across an entire dataview?
Hi there, I'm trying to add a column which contains the row number across my entire dataview, rather than restarting with every subtotal. Unfortunately, the different entities included in the dataview are not from the same tree, so I can't keep the most granular entity in the rows and display the others in a different…
-
Add all entities to the Quick Layout?
Hello, Is there a way to add all entities, used in the related cubes, to the Quick Layout? So far I have only managed to add one entity at the time. This gets very time consuming when you have many Data Views. I saw a post in the Idea Exchange, suggesting the possibility to add the entity hierarchy. That would also save…
-
Sorting Entity members in a selector
Is there a way to sort entity members other than sorting functionality when you create an entity? I would like to manually sort entity members based on their relevance in a selector. my entity has around 30 members, some of which are not currently in use but are important to keep in the selector due to historical data.…
-
Is there any way to do a REPLACE instead of an INSERT in the BULK INSERT feature?
I'm trying to get a hierarchy directly upload from BOARD to a SQL Server, so this way we have the hierarchy on SQL and we can use it in our Views and Querys. The way that the BULK INSERT works let's me upload it, but every time I try to upload it again I will get a duplicate. I only want to have one register for every key…
-
Unexpected behavior in Smart Import (Value in cell xx must be one of the suggested values)
Hi, I have encountered some unexpected behavior in Smart Import that I hope the community has an answer for. I am building a Smart Import screen, and it involves 4 month columns. One of the columns is mapped to the entity Month, 3 to text cubes. All 4 columns have "suggested values defined", all of them look at Month code,…
-
All about language settings
Hi community, I'm looking for an overview of all language settings in Board. To be more precise, a documentation of the configuration parameters that influence the language and also the decimal separator (DB language, user profile language ....) in order to make our board environment fit for multilingual use THX for your…
-
Run executables within Board
Hi, Is it possible to launch external applications within Board, ex open a MSWord file directly from Board? Thank you. Cheers, Tony
-
Hmmm... can't reach this page. Localhost refused to connect
Hi all, I have installed the on-premise version 12.5.1 on my new laptop. The Board Engine and Board WebApi Engine services are up and running. When trying to open Board in the web browser, I don't even get to the Board login. A message pops up saying "Hmmm… can't reach this page - localhost refused to connect". I've…
-
Creating some uncommun charts
Hi together, I'm a Board newbie. I just wanted to ask if there is any possibility to create some of the following charts in Board since I could'nt find the option to create these (in Ver. 12): HexbinSunburstNetwork GraphMekko ChartBox PlotHistogramGeomapsSlope GraphHeat Table (not Heat Map)I would be very grateful if…
-
How and when to extend tuples: Beyond what is written in the documentation
Hi My question is regarding when to use Extend calculation on new tuples for all members of. By experience I would know when to active on correct dimension, but there are occasions when it’s strange and some even don’t make any sense. What also makes someone confused is the text in the documentation: The values in the…
-
R integration guide
Hello, I am interested into running ML-driven forecasts for data coming from a simple cube using R. From this article from the Board 12 reference manual, I see that it is possible: However, being new to Board and R in general, I struggle to understand where to start and haven't found any guide / steps detailing how to…
-
Mashup
Does Mashup function work - as described briefly in Board 10 Chapter 11 (Board Web HTML5 Server) ? mashup html5
-
Procedure "Background execution" doesn't let me navigate the application while Wait is running
Hi, I am confused about the "Notify execution" feature when creating a new procedure. My goal is to make sure that a cube is cleared after 10 minutes of a client entering a screen. I was hoping to achieve this by creating the following procedure: All the messages are set up the same, only the time and the icon is different…
-
Filtro ( Combo Box) en Drill Down
Hace unos dias queriamos ocultar valores usando el filtro max y min, lastimosamente no funciona con la opcion combo box para seleccionar los valores en la funcion min und max, creo que hay un problema en ello , pero si se inserta el valor con el teclado funciona. Cuenta Anyo Anyo Pasado 2600 121,12 100 2610 0 20 2620 130…
-
Understanding BEAM
Hi everyone, I'm currently testing the Forecasting with BEAM, but I can't get it running. In my first try, I had a cube with month, customer, product, scenario and version and created a second cube for beam with the same dimensions (Absatz & Beam - Absatz). Those two cubes are not in the screenshots, I just wanted to…
-
Error 1064 after update of on-premise installation to Board Version 12.5
Hi all, I have updated on the local machine to version 12.5. However, the Board Engine can not be started, stating the error message 1064: An exception occurred in the service when handling the control request. The previously installed version was 12.4 and this was working. Thanks for any hint on how this issue could be…
-
Checkbox column in Smart Import
Hi, I am building a page with a smart import object, and we would like to have a column that is a checkbox. Is this possible? I have not been able to find a setting for this. Alternatively, we will use a dropdown Yes/No picklist, so we do have a plan B, but I wanted to confirm if this is possible or not. Thank you,…
-
Is it possible to have a different layout for the drill-through and main dataview?
We want to filter the drill-through based on a specific block so we want to create a filter block. We want the drill-through to hide rows where the Fiscal YTD is zero, and we want the main dataview to filter where WS P&L Filter is zero. Is it possible to have a different layout for the drill-through and main dataview? We…
-
Is there a way to have rows with no data not displayed in a drill down screen?
When drilling down through data on a report, I would like to be able to make it more concise by not having rows with no data be hidden. The below highlighted rows are examples of what I'd like to not be shown.
-
Data Flow with Change of Entity Element
Hello :) I want to make a DataFlow that shifts the value from one Element to another (in the same Cube) e.g.: Test_Entity: element1, element2 before DataFlow: cube: element1: 0 element2: 10 after DataFlow: cube: element1: 10 element2: 0 Thank you Kind regards wolfgang
-
Unable to Create Virtual Cube
Hello all :) today one of our Procedures threw the following exception: does anybody know this error? Thank you Kind REgards wolfgang
-
Some Problems with BEAM
Hello, I have some questions to anybody, who has already some experience with BEAM. In order to get some practical knowledge about BEAM, I am trying to produce a model forecasting a time series with sales data, but the results are useless, as the model writes the same forecasted value in every future time entity. The value…