-
Creating a dataview (help) ?
Is it possible to make a table as such in BOARD (image attached) Could someone guide me in terms of what I should lookout for the in the development of the dataview. I will have data for the manager, employees, employee targets, current revenue, % target ( which is a column algorithm current revenue / employee target *100)…
-
Go to screen and apply selection
Hello, I try to do a go to screen either by using a go to screen (drill down on a line) or with a procedure. The point is that when the destination screen is reached I would like to apply a dynamic selection on one entity based on a matrix. If I use the go to screen (drill down option go to screen on the line) the dynamic…
-
dataflow hbmp+ or CellBased+
Hello, I create a dataflow to divide the planed article sales on the customers. First cube (ZW2_Umsatz) has the dimensions month and Produktmodell (article). Second cube (percent per customer) has only dimension customer . If I calculate this two cubes to a new target cube (ZW3_Umsatz) with the dimension month,…
-
Erroneous dataflow from text to single type
Dear all, While doing some tests, I came across a problem with a dataflow from text to single type in BOARD 10.3 (Didn't try in older versions). Let me explain the whole business case. 1) I pull in a "creation date" column from an Excel file and apply an ETL function on it during the data reader. The ETL function is…
-
how to add a new screen
This might seem super basic but how to I add a new screen to a capsule in Board? A consultant set-up the cubes and I attended the training (over a year ago) so I'm very rusty. Once I have a blank screen I think I'll be ok to start using the cubes but I just can't remember how to get there and I also can't find anything in…
-
Last value function
Hello, Somebody can explain the behavior of this Last value function? Thank you and best regards Marcel
-
Syntax to filter on a date block
Hello BOARDVille, What is the syntax to filter a block that is based on a date cube? I would like to filter for dates >=20160101? Thank you and best regards Marcel
-
How can I limit the x-axis display (of time) in a line chart to the latest 8 quarters?
Hi All, I have simple cube that has a single time dimension in Quarters. It stores discrete values for every quarter. It currently has 4 years of data up to the current month (quarter). I have this data displayed in a line chart. How can I dynamically limit the x-axis display of the data points to the latest 8 quarters?…
-
Demand Planning using TOC (theory of constraints)
Has anybody implemented / developed a solution with Board for demand planning using TOC (theory of constraints)? Thanks
-
How to block access to a screen when it is already opened by another user?
How to block a screen when it is already opened by another user? I would like to block the Access to a certain screen when it is already opene by another user. I made the following steps: - create a cube with the Entity screen - the screen gets an open trigger which checks if the cube already contains a value >= 1, if not…
-
Is there an option to choose whether negative values are bracketed or have '-' prefix?
How, in Web or Desktop, can we as developers choose how to display negative values? I've found that in a DataView layout using an entity in Axis 'By Column', the negative values appear in BRACKETS. Elsewhere, where a DataView layout is using an entity in Axis 'By Row', the negative values appear with '-' prefix. It would…
-
Relative Cycle Using a Cube
Hello Everybody, Does anyone here knows how to use the cycle in time functions tab but using a cube? Relative offset can be done via data flow with relative offset in the advanced tab. But how about cycle? Thank you. Regards, William
-
Adjust Relationship data by procedure
Hi, I have the following case: I have an Employee/HR dashboard containing the entities subsidiary (A & B) and sales office (1 & 2). After loading data from the server I have the following picture: Employees of subsidiary A & B are all assigned to Sales Office 1. The problem is that this is not 100% correct, which relates…
-
Customize the Drill Through Table
Good morning! I have created some drill throughs but im not happy with the way the table looks like. Is there a way to customize them a little bit?
-
Financial Consolidation Implementation
Hi there .... we are submitting a proposal for the Financial Consolidation solution to a new client here in Western Australia. This is our first site for this and whilst we have 6+ years experience with BOARD we are looking for some advice on implementation timing and also asking if there is any documentation out there on…
-
BOARD daily data upload
Hello, I have a question about data upload of BOARD. We have created a procedure that fills cubes (SQL Data Read) and executes data flows in a specified order. I have noticed that this procedure runs for a very long time and I cannot see very well at which step it is currently. We have a total of 149 steps that need to be…
-
board 10.3 and the support page
I went to download the BOARD 10.3 release and was greeted with this: Maybe it's down to address the BOARD 10.3 issues that have been posted on this forum? I'll just have to wait until it's back up.
-
BOARD 10.2 and 10.3
Hi, I'm not sure, wether this is the right place for this question. On the roadmap at Boardville in Baveno, Pietro announced BOARD 10.2 for May 2018 and 10.3 for July 2018. Currently 10.1.4 is the latest version. Is there a new roadmap? What are the reasons for the delay? Thanks!
-
Excel Add-in function
Hi Everyone, I'm working on a report in excel using Board Add-in. Just wondering if there is any syntax or macro function that can get the current selection? I'm looking into the help section but couldn't find anything Thanks, Chi
-
column offset
Hello, I've stumbled in a report requirement that requires using a column offset in a rule. I've defined it and applied in the dataview, but it have no effects on an entity that I've applied the rule. Details in the screenshot. Any help would be appreciated. Thanks in advance.
-
treemap chart: colours seems incorrect (positive values only)
Hi everybody, I try to setup a simple treemap chart, and i can't get a correct background colour of the single tiles, when i compare the colour with a dataview having the same layout as the treemap. I guess I forgot something but i can't find out what. Here is my current result: the dataview shows that the colour depends…
-
View a schedule
Hello, I start on Board and I need help. On my home page, I would like to display the schedule of the budget process. I wish it were dynamic rather than just a picture. Would you have a suggestion because technically, I block. Thanks for your help.
-
Cannot start Board Services
Please help! I cannot start Board Services. On Event Viewer getting the error message: Starting Core Service on port 9700, 9702... Cannot start Board 10 Server. Original cause: Only one usage of each socket address (protocol/network address/port) is normally permitted" Our Staging environment is still working and it uses…
-
PDF functions in the BOARD WEB (10.3)
My first imrpressions: Nice! This is a promising update! The update itself was easy, except for the topic: Upgrading to 10.3 First of all: Many good approaches. Creating a PDF from a single DATAVIEW works. That's nice. But the devil is in the detail! What I have noticed so far (in a hurry): * The representation of the…
-
Upgrading to 10.3
Hi I am looking for some advise from anyone who has upgraded to 10.3. I attempted to do this today and have experienced a problem signing in afterwards. In the past when I have performed upgrades (just on my laptop) it has been a simple matter of uninstall old version, reinstall new version and everything works. This time…
-
Users' personal images
Hi all, I am testing the new Board 10.3.0 version. How I can upload images for users? I suppose I have to write a folder path but there is no way to upload any images. I have also tried with png and jpg images, larger and smaller, but nothing. Any idea? Domenico
-
design capsule
Hello everyone, i'd like to know how i can put a panel which contains many labels and in the same time this panel has to be with 0 % transparency , because it's working in the client on the windows but not on the web! thank you !
-
Analytical functions > more details regarding "average"
Hi, I would like to use one of the availableanalytical functions : average According to the help, Average: it returns the average value of the series (Total/Time Length); Can anyone give more details on how the average calculation works ? * how happens the aggregations ? * Does the function apply after all aggregations and…
-
A little timebar problem
Hello there! I have a little problem with my timebar selection and I don´t really know how to solve it. I have a dynamic selection on month ( current date and period) so that my dataview is only showing me the actual month july. the little problem is, if I start to select a different month in my timebar, from july back to…
-
Migrate development capsule changes to production
Whenever I create / test new / modified enhancements I apply and test them first in Development capsule. When there is consensus about the change I manually apply the changes to procedures / screens / etc.making very very sure that I migrate everything (sometimes this can be a rather tricky process). How do you guys do…
