-
Multi Data Blocks in Columns but different rollups
I am currently designing a DataView report layout that shows Customer payment history with conditional formatting illustrating where we collected 1 of 3 options; If we collected payment that month, if we collected more than 1 payment that month, or if we collected no payment at all. Since we have posted payment counts…
-
Multi Data Blocks in Columns but different rollups
Good afternoon! I am currently designing a DataView report layout that shows Customer payment history with conditional formatting illustrating where we collected 1 of 3 options; If we collected payment that month, if we collected more than 1 payment that month, or if we collected no payment at all. Since we have posted…
-
How to give control to delete/remove an entity member to end user?
Hi all, I am currently building an retail planning application in which the we are giving the flexibility to the end user to load the master data (Store details) into the entities. In addition to this, we want to give the flexibility to remove a particular store detail in case the use want to do so. Let's suppose the user…
-
Cumulated value
Hi, I want to create a cumulated value in my Dataflow, not with a Yearly Cumulated Value, or with a Yearly Moving Total. I think it is a basic function in particular for inventory but I don't find it. Thanks
-
templates
Hi Community, I want to ask if there is any prepared design's template for first access and thanks for the reading and answering.
-
Data Reader locked by administrator
I receive this popup message when I click on the Data Reader icon in the Database tab. My entities, relationships and cubes icons all work but the Data Reader appears to be locked. Any idea why this happened and how I can fix it please? Thanks.
-
Diffirent menus in one capsule
Hello everyone! I'd like to know if there is a way to use diffirent menus in only one Capsule ? Thank you!
-
Can I read an active directory attribute from a custom database profile script?
Overview For our HR model, Drew Steans & I are trying to implement security such that each department manager can only see their own department, and nothing else. Original Approach We have 20 departments. Each department has a different manager. Each manager should have a Lite license to allow them to run reports. So far,…
-
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