-
Consolidated view of Infocubes by Entity
Is there a way to visualize in a consolidate view all the Infocubes that use an specific Entity? For example, I would like to know all the Infocubes that are related to the "Channel" Entity.
-
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…
-
How to build an efficient dataflow to transform YTD values in Monthly values ?
Hi Board experts, Everything is in the title, we are working on a computation engine that works both with monthly and Year-to-date values. In a dataflow we currently do the operation to convert a monthly cube in a YTD value cube, but what would be the most efficient way to do the reverse ? How would you set it up to obtain…
-
hide or make more discreet the procedure running window in web client
Hi everybody, I guess the answer is no, but i would like to see whether other users have this question. Is it possible to modify (reduce size, remove the "processing" text etc...) the pop-up window which appears when running a procedure within the web client ? My customer says, it is too big and not discreet enough.…
-
Error when refreshing MS Office file
Hi, I'm trying to refresh an Excel file with some Board Layouts in it. The simplest procedure (1 action, just the "Refresh MS office" action) is not working, and it is showing the "classic" error message: "Object reference not set to an instance of an object" It's been a long time since I last used this Refresh MS…
-
New to BOARD
Hi Everyone I have 5 years of experience in Reporting and Visualization area with tool expertise (Power Bi , SSRS , Tableau etc.,) . I need few hands to help me on understanding how to go ahead and learn BOARD Tool. Thanks, Praveen
-
Maps - can multiple selections be made before action
It would be nice if the drilldown and action buttons could be applied to maps (in Web), having selected MULTIPLE locations on the map. Eg . select location A, B and E, then click on Actions\Drill Down, or Actions\Export or Actions\Print to PDF. I'd like to suggest that a new Action icon would be suitable (in Web), for…
-
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…
-
SQL ODBC Data Reader Cause Primary Key and Index Corruption?
Hello, For the past week now we have been experiencing issues with our CRM's SQL Server and several instances where our primary key and indexes have corrupted on our production server. I'm currently using a series of SQL ODBC connectors via BOARD's data readers on one of our replication servers(not on production). This…
-
The requested screen does not exist inside this capsule
When I create a new screen in a Capsule (not all capsules, just one) I get the message: The requested screen does not exist inside this capsule The screen is created and can be closed and re-opened (whereby I see the same message again). Initially thought it might be because I have a Mask with the same name, but this is…
-
How to use variables inside a select (SQL Server)?
Is it possibile to use variables inside a select? For example I've tried this manual query in a datareader DECLARE @anno as int set @anno = 2018 select * from table where myyear=@anno When I've tried to show the result, I received the error from the Boardserver: Must declare the scalar variable "@anno". It would be very…
-
What happens in Vegas stays in Vegas?
Hey all you lucky BOARDVILLE LAS VEGAS delegates! Will any of the keynotes be streamed for us less fortunate?
-
Data Flow not working!!!
Dear All, I have three single cubes at below. - a: cube 1: 3 dimensions: month, base article (sparse), new article(sparse), it has data already. - b: cube 2: 3 dimensions: month, base article (sparse), customer (sparse), it has data already. - c: cube 3: 4 dimensions: month. base article (sparse), new…
-
Cannot start Board 10 Server. Original cause: This license does not allow Board to run in 64-bit mod
I keep getting the following error when starting the local BOARD instance... This was working until 2 days back. Cannot start Board 10 Server. Original cause: This license does not allow Board to run in 64-bit mode.
-
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…