-
Show Blank Data in dataview
Hi All, I have a problem with the data view. I have a cube that has its data contents. and in my dataview settings it's 'Hide Zerro' and Uncheck 'Show All'. so dataview should only show the existing data only (not Zero). But when the result dataview display is blank, after I try extract cube, the cube have data. does…
-
Board Cloud : is there a way to perform a join ?
Hello community, I'm working on my first project in the Cloud and according to Board support it is not possible to install any tool (SQL server for example). My need is to join two files, in other projects I load them in SQL Server, create view that join the two tables then use SQL data reader. Is it possible to perform a…
-
Please advise how user licences work in Board environments - e.g. if I have an Administrator licence
If I have to access all 3 Board environments, DEV, QA and PROD, do I require 3 x user licences? Or do I only need 1 user licence and the access to the environments are governed by authorization profiles? Please advise.
-
Summary All Data Until Date Selection
Hi, How to sum all data until date selection? Example: Data on DB From 01/01/2014-01/12/2018 (dd/mm/yyyy) And i want to sum Data where day 01/05/2018. I try sum data with function "yearly cumulate" but report just shown data sum 01/01/2018-01/05/2018. I want report shown sum 01/01/2014-01.05/2018. Thanks.
-
Configure Process to add row totals
There is probably an easy solution to this but it has me stumped for the time being. In the image below I have a budget detail page for collecting travel and training info. I have a line item Travel Total that is an algorithm ((b*50)+(b*150*h)+(b*50*i)+(e*200)+(g*.55)+(b*50)) and I want to use this algorithm in a process…
-
Capsule Logs
Hi, Is there a log file in BOARD or a way to find out when a capsule/screen was created and by whom? Many thanks
-
Mask transfer
Hello, somebody know how to transfer masks between applications? Thank you and best regards Marcel
-
How to display week dates
A lot of my reporting is by week. Board only displays the week number and year which is causing an issue with a number of my clients because it makes some of the reports quite difficult to analyse as you need a date reference. For example attached is simple layout which shows the week and the value. The issue is, for…
-
Anyone using data-mart function ?
Everything is in the title I'm wondering what is the intended use of this function and if many people are using it ? And for what objective ? Thanks, Etienne
-
Creating a metric in board
Hi all, We have only just started using board so this may be a pretty basic question but any help/guidance would be very much appreciated! In order to get an understanding of how Board works we started with an example. In our example we are working with product groups, products (each product has a corresponding group) and…
-
Clarification needed regarding BOARD on mobile devices
Hi everybody, I am confused with the several options I have heard and read about which allow to consume BOARD applications on a mobile device. I mean no only tablet, but also smartphone. Can the community confirm or unconfirm which options are currently (BOARD 10.1.4) available, deprecated, to avoid, to recommend ? If…
-
How can I calculate an average stock in my dataview?
Hi, can someone help me calculating an average stock in my dataview? I have a monthly stock information and I want to divide it by number of months <> 0. I tried with a refer to but I can not calculate with the sum. If I try to divide 'a' by 'b' board does not use the total sum, for example 4 (first row), board divides by…
-
Using Date Cube as a Time Entity
Hello I've some peculiar report requirement that has to be done in BOARD. I have 2 cubes, let's say cube A holds an transaction amount value, and cube B holds a transaction payment due date value. So the data type for cube A is double, and cube B is date. The cube B data is from a calculation that has been done inside…
-
Dynamic Rolling Average
I am looking to create a dynamic period, over which I can calculate a rolling average. For example: Daily usage period = 7 Average sales over period will then be from today, backward looking for 7 days. The problem is that the period may be different for every sales location, and could be changed daily. For example:…
-
Is there an equivalent to char(13) & char(10) in BOARD layout?
Hi, I would like to use this to create a multi-line text in a layout / dataflow. I know it works in Data Reader ETL. Thanks and BR Moritz
-
BOARD WinClient Not Auto-Connecting to Server through .bat Command
Good morning! I am currently trying to run a .bat file through Windows Task Scheduler to launch a Capsule that triggers a nested Call Procedure which then runs a series of Date Readers, Refresh reporting Screens, and then Broadcast the latest results to our Executive team's distribution list. However, the .bat file will…
-
Difference between algorithm and Dataflow
Hi, i have a question about dataflows and algorithms Why does the applied algorithm returns different values for the following two cases? 1) as a result of a Dataview algorithm 2) as a result of a dataflow procedure I am performing a simple c=(a*b) dataflow process Thanks,
-
Connect to Azure SQL Database
Hello all, Has anyone tried connecting an on-premise Board instance to a SQL database in Azure? Can't seem to find any available connectors for it. TIA Michael
-
Offline Mode in iPad
hi, i´m trying to use the iPad in offline mode, i already "Save the capsules for offline" and a little icon disk is tagged to the capsule that i saved. After i disconnect the ipad from the wifi, the app keep asking me for the Server Address, and don't allow me to use the offline mode, any suggestion? thank you!! i´m using…
-
ASCII Datareader file location
We've recently upgraded a client from B9 to B10 and we now have an issue where an #ASCII #datareader that works in B9 no longer works in B10 because it cannot find the file which is in a different network location to BOARD. The file is saved to the 'finance' network drive, and in the B9 (production) datareader (below) you…
-
Office 365 AddIn for Windows 10
Hello, currently we are using the BOARD version 10.0.3 and the Office 365 Pro Plus [32 Bit] version 1802. Now we would like to install the related Office Add-In from BOARD. Unfortunately, it terminates the installation routine with the following error message. "You must have Microsoft Office 2007, 2010 or 2013 installed to…
-
Synchronize two folder containers when changing tabs
Hello Community, Is it possible to synchronize two folder containers in a way that if we change the tab in the first container it changes automatically in the second one. Best regards, Ahmed Lattali
-
Excel Export - Selection
Hello, does someone know a way to transfer the selection informations of a screen to excel by excel eport? Hendrik
-
I added a cockpit to a screen and it does not show on the web.  How to fix?
I put a cockpit on a screen with 2 bar charts and a report. The cockpit shows up on the client version of Board but not on the web version. It appears to be there but the graphics are not visible - Just a blank space in front of other graphics. Not sure how to fix
-
Where can I get good icons, backgrounds or palettes?
I’m more of a numbers and architecture person, than colours and aesthetics. Which resources do you use to find icons, fonts, backgrounds and other graphics for screens? Are there any palettes that work particularly well with the corporate branding tool? I like to set the corporate colours, make a few masks, and then reuse…
-
Customize File Name Export
HI, Can Board customise output file name when Dataview Exported with procedure? Example: Dataview-date.pdf sales-10012018.pdf
-
password reset options from web login
Has there been any discussion on here about password reset options for web login users?
-
Export DataView in Excel: what about alerts?
Hi all, just a question regarding the export in excel (flattening mode) of a DataView. In Board Client if a User performs an export in excel (by right-clicking on the dataview and then clicking on "Export in Flattening Mode"), the generated excel file will not show all the alerts actually shown in Board's dataview. In…
-
Not wanted behaviour of Export Excel Flattened
Hi all, we are currently struggeling with a function (or bug :-) ) with the export of a flattened excel file. WHAT? We got a procedure, which has nothing more in it then two info messages for the user and the function Export Excel Flattened (see attached). The screen which should be exported has a P&L dataview in it, which…
-
Chart with different time select
Hello, I am not able to make a chart with two different time select: a) stock value time select December b) turn-over value time select from January to December In the chart I would represent a/b Is it possible? Regards, Gabriele
