-
WebClient: How to change Display mode of "Entities & Relationships" in layout builder?
Dear community, I have received a seemingly trivial question from my end user, but I was perplexed to not find the answer. I am searching for an option to determine the display mode for an Entity inside the layout builder of the web client. More specifically I am searching for the web client equivalent of this: I found the…
-
How to programmatically (re-) load a database?
Hi all, we need to reload every other day one of our databases as there is an odd effect (potentially bug) that is solved by unloading the db and then reloading it into memory. The effect is that analytical functions will not have results although they should. Now we would like, as part of our daily routine unload the…
-
Change PDF page size in the Export procedure
Hello, I did a procedure which extracts the objects contained in the screen. How can I set the output pdf page size? Currently, the file has the dimensions of 76x50 mm. Thank you
-
Drill Through with total
Dear Boardville Citizens, when I perform a drill through, I see i.e. the single document reference of a combination account/cost center but I have no total. Has anyone a way to explain the total in a separate column? Thanks a lot. sqls drill-through
-
Age banding
Hi Board community. I need to show claim amount by groups of ages of the claim e.g. 0-16, 16-31, 31-46..... How do I do this kind of age banding in Board? Regards Thora
-
@Year_Selection
Problem Statement- (a) Cube A contains Data from year 2010 to 2018. I want to plan for year 2019. My Selection contains reference data from year 2014 and I need to copy it in year 2018? Please suggest how to achieve it.
-
Webclient known issues
Hey, is there a documentation or tool tips on using the webclient? And does it contain known issues? For example, layouts that work good and normal in the desktop version but in webclient: - waterfall charts that do not work properly (empty layout)? - "Oops"-Layouts just not working? another empty layout! - zeroes shown…
-
How does BOARD handle concurrent execution of procedures?
Hello, We have a procedure which clears some cubes and then runs some data flows to reload the cubes. The procedure may be triggered by user activity. If two users cause the procedure to run at about the same time what happens? Does one run and complete before the other is executed? If not is there a way to single thread…
-
Can you run multiple procedures concurrently
Wondering if anyone can point me in the right direction here. I'm sure there is a way, it could be in procedure setup or it could be in BOARD server setup, i'm not sure, but keen to hear what suggestions others have. Is there anyway to get BOARD to run multiple procedures concurrently? At this client there are several…
-
How to give control to delete/remove an entity member to end user?
Hi all, I am currently building an retail planning application in which the we are giving the flexibility to the end user to load the master data (Store details) into the entities. In addition to this, we want to give the flexibility to remove a particular store detail in case the use want to do so. Let's suppose the user…
-
Creating a metric in board
Hi all, We have only just started using board so this may be a pretty basic question but any help/guidance would be very much appreciated! In order to get an understanding of how Board works we started with an example. In our example we are working with product groups, products (each product has a corresponding group) and…
-
Using Date Cube as a Time Entity
Hello I've some peculiar report requirement that has to be done in BOARD. I have 2 cubes, let's say cube A holds an transaction amount value, and cube B holds a transaction payment due date value. So the data type for cube A is double, and cube B is date. The cube B data is from a calculation that has been done inside…
-
ASCII Datareader file location
We've recently upgraded a client from B9 to B10 and we now have an issue where an #ASCII #datareader that works in B9 no longer works in B10 because it cannot find the file which is in a different network location to BOARD. The file is saved to the 'finance' network drive, and in the B9 (production) datareader (below) you…
-
Export DataView in Excel: what about alerts?
Hi all, just a question regarding the export in excel (flattening mode) of a DataView. In Board Client if a User performs an export in excel (by right-clicking on the dataview and then clicking on "Export in Flattening Mode"), the generated excel file will not show all the alerts actually shown in Board's dataview. In…
-
Not wanted behaviour of Export Excel Flattened
Hi all, we are currently struggeling with a function (or bug :-) ) with the export of a flattened excel file. WHAT? We got a procedure, which has nothing more in it then two info messages for the user and the function Export Excel Flattened (see attached). The screen which should be exported has a P&L dataview in it, which…
-
CSV inbound data with multiple columns per product
I have a CSV file, which contains inventory levels and stock movements by location. The file is structured that each line contains detail by location, with multiple product headings in the columns and the volumes then in the row. How do i go about mapping this to the various entities? I have set up a product, movement and…
-
How user will upload a file ??
Hi, I want to give an option to user to upload a file (he will be able to browse to a specific file he want to upload). Helmut HeimannOliver BeirneSimon Scullion
-
Use webclient and desktop at the same time?
Hey, is it possible to use webclient and desktop version at the same time? Or will it usually lead to user- oder licsenseproblems like getting blocked/banned (like formerly using to instances of board desktop)? Or is it a question only my office it can answer :-) ? Cheers Hannes
-
Dataflow processing time - what is happening under the hood?
Hi, apologies for this being a bit long but I really want to know what is happening 'under the hood' in this instance to make two almost identical dataflows take very different lengths of time to process. I discovered the following when looking to speed up a procedure (now that a client is finally on B10). A dataflow was…
-
WYSI (not) WYG - labels in Panel Containers on Web
Has anyone else encountered a problem with how labels are displayed (in relation to each other) when they are in a panel container - where it looks fine in Desktop, but in Web the positioning goes 'to pot' ? Trying to use labels as containers for text, some with borders, and one with an image. Outside panel container, each…
-
unselect master
Hi folks, is there any possibility to unselect the master-function. Once I have selected one item by unsing the master-function I don´t want to scroll down all the way to hit total again, but using a "Unselect" or "Deselect" function/procedure instead. I´ve tried the "Remove Selection" in the procedure already, but still…
-
GVA Introduction video
I was asked by my company to put together a short high level video demonstrating three aspects of our external client tool. Whilst discussing this with Andrew Rae, I found that I could not share with him the content and so decided to share it here for all to see. I welcome any feedback and opinions. At the time of…
-
how to make bar chart columns with different width?
Hi, right now I have this type of chart: And I'd rather have it look like this: The idea is to have bars with different width in order to put some behind others and still be able to see their value Is this possible at all and if so how? BR, Ray
-
Align cube from ROLAP version
Hi, is it possible to refresh the aggregated versions (align) of a cube with a ROLAP version that is on the lowest level? BR, Ray
-
enable broadcast / mailserver feature
Hi board members, we would like to use the mail function in board. I tested it with several smtp accounts (e.g. gmail) and still got the same useless error: "Procedure usermail failed" (without any further log informations). Are they any hints and tips? Best Paul
-
how to create bar charts with several stacks?
Hi, I would like to create a bar chart with many stacking groups as in the following example: Right now there are two stacking groups - combine by stack and combine by stack100. I don't see the option to have put some elements on the first stack, then combine others on a second stack and so on. There would be the…
-
MXC Cube - No Totals
Is it possible to get a grand total of rows and columns when using an MXC Cube? I want to understand MXC cubes more. One thing I have found is that I cannot get row and column totals when using an MXC cube and so have to create a duplicate of the MXC cube, setting the datatype to DOUBLE and not MXC. I then have to create a…
-
Is it possible to "drill to screen" as an action of a procedure?
Hi, Using the drill to screen action I'm able to set a selection for the target screen. As procedure action there's a "Apply selection to current screen" that allows to make the selection for the current screen. As a second step I can use the "Go to screen" action and go to the screen of my choice. The disadvantage of…
-
Extract layout to local machine
Has anyone been able to extract a layout (in csv) to the users local machine rather than the BOARD server? I've tried a few things with no luck so hoping someone else can help. The client's current workaround is to map the drive with single folder access on the users machine to allow them to access the file so they can…
-
Full RAM Mode / Benchmarking : how much time does it take to load your DB in RAM ?
Hi everyone, I would like to do a bit of benchmarking to understand better our performance and look into possible infrastructure improvements. My current issue is that we have large databases (typically 50Gb) that takes a lot of time to load into RAM when used the first time. Usually this takes between 20min and 40min. So…