-
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…
-
Need support for normalize data
Dear All, Currently, i want to create a forecast report. I will explain my situation. Please take a look at below table. I have a part id 'A100' and this part is manufactured in CN currently and will be manufactured in VN from Nov-2018 completely. In this case, i need to create a forecast for CN Factory from Jan-2018 to…
-
Data Entry - doesn't work for all items
Hello, I have a cube that has a Sales Team and Month entity. Data Entry is enabled in order to manually insert values. However, not all of the teams are "enabled" meaning that not for all teams I can write a value (see below). Do you have any idea on how could I investigate the cause of this? Thank you, Cosmina
-
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…
-
How to create a Square Metre Symbol
For me, understanding how to insert a superscript 2 for m² was one of those little niggly things which drags on and on because 'I will google it at some point, but just haven't gotten round to it yet'. Well, I finally got round to it and thought I'd share. * Type m2 * Highlight the 2 * Press and hold the [Alt] key then…
-
Office add-in excel, keep format
Hello all, is there something like @selection for the Excel Office Add In? And how can I avoid reseting the format of my excel sheet when I refresh? KR Annika
-
Filter visibility of rows based on PDF cube
It's possible filter by a PDF cube? I want filter a layout by a PDF cube and see only the row where the PDF is present. What is the condition?
-
Cannot Run Requested Analysis: error
Hi everyone, I'm trying to run a detailed layout but getting error 'Cannot run analysis'. However removing any of the entity, layout is running fine. Is there a way to fix that? Are there any limits in terms of entities/results/etc? Thanks