-
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…
-
Date-time to be shown in label with a different time-zone. Ideas?
Hi everybody, I would like to show in a label the current date (@date) and the current time minus 1 hour. That's why Board server is running in italian time, I would like to show in the label the UK-time. I've done it with a very complex nexel Is there someone with a smarter idea? Thank you, regards, Edoardo Tags: dates…
-
NEXEL: Dynamic calculations on WEB not working
Is anyone aware of issues when using NEXEL on the WEB? I've created a process that uses a dataview incorporating a nexel calculation. The screen works perfectly on 10.1.4 Desktop but fails when used on Web. The action of the routine requires the user to select a SOURCE property. Values are selected from the SOURCE and…
-
Bubblechart goTo Capsule on bubbleclick
Hello there! I have a Home screen with a bubble chart as follows: Those bubbles represent projects and if I hover over one, it shows me some more infos like projectnumber, customer, customer adress etc... What I want is a function , so if I´m clicking on one project bubble, it should * save the specific project selection,…
-
Quarter To Date
How do I create a Quarter To Date (QTD) column in a DataView? I already have current month and Year To Date (YTD). Thanks in advance, Kit
-
Extract Board Metadata using Procedures or command lines?
While waiting for this featuresA "used by" feature on cube - Impact analysis , based on the suggestion of Björn Reuber, I've done quick ETL project using Extract Metadata features to do it myself using Talend (for xml processing) and a Board dedicated database to view the result. + However, I want to streamline the process…
-
Silent Installation BOARD Server
Hello, I'd like to install Board Server in silent mode without GUI, just over command line. Is this possible? If so, how can I do that? Thank you in advance. Kind regards Andreas
