-
Best way to select individual Entity
Hi all, i'am struggling with the following problem: I want to make a calculation within BOARD. I have products that can be produced and finished in different plants and production lines. Each production-line has a relationship to a plant with different costs on personal plant) an production-line. So, within a screen i have…
-
Date entity as String
Hello everyone , i'd like to know if there is a way to add an entity in date hierarchy that accepts String , i wanna do that beacuse i'm trying to upload a table that possesses a column which contains "YTD or TYG" so when i try to load it i get "0" and that because i have to put a date format -_- Thank you for your help !
-
Dataview layout not editable
Hello, I made a setting for my capsule that I cannot edit my layouts anymore even in editing mode. Can someone help? KR Annika
-
excel addin delete
Hello, Is there a way to delete an entry in Excel? I have an BOARD app to manage project. I sent a layout with end date for a project to Excel, I activated the connection. Data entry OK it works Delete a date doesn't work Thanks for your input. Best regards, Marcel
-
End of month value
Hi, I want to extract the end of month value of an inventory cube. Day by day, I have the cumulated value but I need a end of month value for the accountancy. Thanks a lot, Sébastien
-
Can you run multiple procedures concurrently
Wondering if anyone can point me in the right direction here. I'm sure there is a way, it could be in procedure setup or it could be in BOARD server setup, i'm not sure, but keen to hear what suggestions others have. Is there anyway to get BOARD to run multiple procedures concurrently? At this client there are several…
-
Export all the cube names
Hi everyone, We have a large Board projects with hundreds of cubes, entities, reports etc. So now I want to create a second project which will be the documentation of the project mentioned before. So in here I want to have an entity for reports, entries, cubes etc. And then we describe for each report, cube, entity etc.…
-
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
