-
extract a file (XML) with setting we have in Board
Hello, Is there any way to extract a file (XML) with setting we have in Board? This can be very useful to check if layouts are well set without going into each of them.
-
Integration of dbf (Fox Pro) with BOARD
Hello, I try to connect BOARD to Winbiz that has a dbf file type. Basically it is a Fox Pro database. Is there somebody who has experience with this? Thank you and best regards Marcel
-
Find function in block alghoritm
Hello I tried to use the find function in an alg. block but it doesn't work. Probably it's not supported , but I would like to be sure about it. For sure I can do this using nexcel, but in this case I would avoid it. thanks
-
Extracting and re importing a date cube
Hello, I am trying to build a solution to record guest stays at a ded and breakfast, the idea is to have a number of cubes to data entry some details about the stay, i.e. date cubes (no time entity though) by guest and property to enter the check in and checkout dates, (the number of nights will be calculated in a process.…
-
Normalization after changes on tree
Hi, I have to change a relationship in a tree (having a lot of entities and levels). In particular I have to link "Riclassificato Paese" directly to "Riclassificato Centri" instead of "Riclassificato Gruppo": After this changes, Normalization between CDC and "Riclassificato Paese" (1 indirect level) doesn't show the name…
-
Pager in print configuration does not print out totals
Hello to all, we have a screen with a Pager, let's say products, that we want to give out as a PDF with one page for each element shown in the Pager. We therefore use the Pager in the printing Options (see screenshot below). Everything works fine except that the PDF does not contain a page with the total figures. The only…
-
Two zero lines in a chart with two y-axis
Does anybody have a solution for the following issue: We have a Chart with two Y-axis, the months are in the x-Axis. The data for both blocks is positive and negative. We get two Zero lines, one for each Y-Axis (see attached screenshot) I didn't find a way to get only one Zero line. Anybody's got an idea?
-
Single precision cube vs double precision: how to anticipate the effects ?
Hi everyone, I'm currently reviewing several possibilities to optimize the size of our cubes. By default, everything was created as double precision cubes, but this might not be necessary. After some testing, I found that the gap between single and double precision cubes is not always significant, however I find it…
-
What is Open Sparsity?
I've seen a few cases now where checking the Open Sparsity option on a dataflow does the trick to ensure data makes it to the destination cube correctly. I was hoping someone could help articulate when and why this should be used, or avoided? As I understand it, the opensparsity option removes any assumptions about where…
-
managing scales of several different charts
Hello everybody, Does anyone know how to manage the scales of several different charts in BOARD ? In the example below: * there are 3 different graph objects and 1 pager object * the KPI 1 and 2 have close values (4 millions), the KPI 3 has another range of values (1,5 million). * the respective values of the KPIs vary…
-
Should i use Fix Relationship?
Dear everyone, I found some orphans in my database. Should i use 'Fix Relationship' function. Because i found that if i keep the orphans, my report is not correct. Do you have any suggestions? Thanks and best regards William Le
-
setup colors code in charts from the legend
Hello, Could anyone help me to setup a color code from a chart legend ? I don't understand the BOARD error message saying "not a valid HEX string" (see pictures below) However #29D5FF is an hexadecimal string (Link). What am I doing wrong here ? Does anyone know a website to convert my color code into a format compatible…
-
Board server 10.1.4 upgrade
Hi community, after uninstalling board serrver 10.1.0 and reinstalling the latest one 10.1.4, the databses are conserved in c:\Board......, but after launching the same old conncetion in my latest board server localhost, the board server do not give me access, i tried to login other board server outside my localhost, and…
-
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
-
Installation on a Shared Workstation
On a Thick Client installation, is there a way for a single Hosts configuration file to be used for all users?
-
Blockchains in BOARD?
Hi folks, Before I try to build my own data model for Ethereum statistics, I thought I would ask if anyone has built one already? ethereum is a cryptocurrency like bitcoin. There are many blockchain projects underway, with many in Switzerland. Has anyone developed a model that can load data from a blockchain? In…
-
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
-
Dynamic Block Headings
Hello, our users want the block heading to be dynamic. Is there any way I can go about changing a block heading through procedure or dynamically based on conditions and/or selection? For example what we often see is, the user will select 2015 to compare to 2017 side by side. They want the block heading rather than being…
-
Detailed logs for Data-reader (http)
Are detailed logs available for Data readers? For example, I have a data reader that extracts from an HTTPS endpoint (hosted on AWS). This keeps failing randomly (from what I have observed), what are the possibilities of maybe checking for the connection status or response header and body ?? So the above data reader…
-
blocks by row
How do I view multiple data blocks as rows. i.e. when I add multiple blocks, it defaults each block as a separate column
-
applying an entity select to trellis object
Hello everybody, Is it possible to apply a select on the entity which is set as the "pivot" entity of a trellis object like in this example ? Let's say: * I have twelve months in my screen select, * a few objects of the screen are showing values for the twelve months, * I want to show only 3 months in the trellis object, *…
-
How to insert an empty column?
Hey, in the past it worked to create a new block, put column algorithm "-" (without quotation marks) and that was it. I got a column which I could format with grey colour to have a seperator in my table between different blocks. What is the best solution for that nowadays? Beste regards Hannes Keller
-
Function Month on a date cube
Hi, I need to calculate prepaid expenses. By writing, I have: - an "Amount" cube, - a cube, in date format, "Start date", - a cube, in date format, "End date". I just need to retrieve, in a calculated field, the month of the "Start Date" cube. So, I just tried month (b) and it does not work because it looks like the Date…
-
Full Year Cube
Hi, I have a monthly report driven by month entity and I want to have a cube to show a Full Year budget for the year from Jan-Dec. Although I can use a Reference To 'Year' function which only set it to a static year, I want it to be dynamic so when navgating through the month into next year the Full Year budget figure…
-
status of BOARD knowledge base
Hi everybody, What is the current official status and place of BOARD knowledge base ? I cannot find a few document on the community.board.com website. * on the one hand From the official page (Link), the knowledge base is defined as https://community.board.com/, see screenshot below * on the other hand, the website…
-
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
-
Auto connect user with SSO in iframe
When opening a capsule from a command line it is possible to control the server/host, capsule and screen to be opened, along with telling it to 'auto-connect' using either /username and /password, or the /sso switch as described here help.board.com When embedding via iframe it is possible to also set the capsule/screen,…
-
Tree map: Colours
Whilst using a tree map, I have set an alert from red to green red if its lower than 0 and green for above however the smaller the number (below 0) the lighter shade of red but the closer to 0 the stronger the shade of red... This seems counter intuitive to me, anyone have any ideas around this?
-
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…
