-
Firewall in Windows 2016
I have install Board Web HTML5 Server and I want to know what programs I have to allow into Firewall. The OP is Windows 2016 server. Regards
-
corporate
Hi, I am trying to add my Corporate Colors ID to the Corporate Identity. The standard Color Palette shows the following colors: But when I add one color, for example (#FF6E1432) all other (standard) colors disapear. So my question is: Is it possible to add a color to the standard color palette? Because I am free to use…
-
Data flow not working
Dear all, I want to make a data flow action with 3 cubes. 1. Cube A: 5 dimensions: month, base article, customer, production article, production manufacture. 2. Cube B: 3 dimensions: production article, production manufacture, sub article. 3. Cube C: 6 dimensions: month, base article, customer, production article,…
-
Dataflow and Ranking Functions?
Hello, We have a capsule which uses ranking functions (for example Cumulated Vertical %) on a dataview. We need to save the results, which depend on the ranking, into another cube for further analysis*. The regular way of outputting a cube is to use a dataflow. However, the dataflow does not have ranking functions as an…
-
Dates shown in Browse and used in WHERE are offset by 1
Just wondering if anyone in the community has come across this issue before and found a robust/correct way of dealing with it. BROWSE doesn't match what is loaded into a CUBE. The Browse on a SQL query shown below lists several dates by employee. The Dataview below shows what is actually loaded into the relevant date…
-
Cloud| database restore
Hello there ! I just configured my database backup as follows I can find my backup now in the cloud admin portal and also in the azure storage explorer. How do I setup my restoring path now? Z:\backup"databasename" ? Thanks for help ! regards Antoni Theodorou
-
Ports used for BOARD WinClient
Hi All, What are the ports used for outgoing and incoming connections from the BOARD WinClient to BOARD Server on Cloud (Provided that everything is installed on defaults) ?? Regards Chris
-
How to print multiple objects from a Board Web screen
Hi All. Is it possible to print multiple objects (eg dataview) on a Board Web screen with a single procedure / operation? In Board client environment this can be done either by manual printing (configuring the print settings) or by procedure. The result is a print with a sheet for each selected item. Is it possible to…
-
Fast Search in Dataview - exclude mode
Hello I discovered that in the dataview fast search available in the sliding toolbar the "Exclude" option is achieved typing a "-" before the string. example: in the dataview I have folling items in row Jan Feb Mar if I type "-Feb" I will see only Jan/Mar. This behaviour is not described in the manual. has someone detected…
-
Postfix in donut-chart | cube ignoring layout selection
Hello there ! The first question is quite simple, but I cant find the solution for. I want a "€" Postfix for this value..i´ve tried with axes postfix and layout format postfix nothing worked . Second question. I have a layout with two cubes. I also have a layout selection for one of those cubes. Problem now is, the second…
-
Overlap Calculation
Hi All, Please help me how to get my "End Stock from week 27" and will be place to "Opening Stock week 28" Formula to get Opening Stock = If (Demand last last week is 0 then get Opening Stock last week else get End Stock) Formula to get End Stock = Opening Stock + Incoming - Demand
-
Dynamic selection in procedure
Hi Community, I'm struggling with a procedure I'm creating. I ask the user to select a month and I do a dataflow using this month. Then I need to get the month following the selected month if not December. I'm not sure how to do that. Could you help me please ?
-
buble chart on the web
Hello everyone , it that normal that the buble chart isn't working on the web? thanks for your help!
-
select on higher level in hierarchy
Hello all, I have this dataview where the products are on the rows. There are a couple of columns that are higher level entities: Now there's always the possibility to select by the rows' axis in the context menu of the dataview. I would like to expand that feature, by means of procedures, and build a context menu like the…
-
Entity Row Template - Default
I have a few Row Entity templates set up for different P&L formats. They all have a 'default row template' set, and then total/subtotals lines are formatted a as required. What I'm noticing is that when the user adds a new member to the 'P&L line' entity it doesn't pick up the format of the 'Default Row template' even…
-
Dataentry directly on DYNAWRITE
Dear all, does anyone knows if is possible to enable dataentry on a dynawrite with text cube? Thanks
-
Dynamic Year
We have a year selection on a screen. Based on this selection, the data gets filter.. We have Columns like Current Year Budget, Prior Year Budget, Prior Prior Year Budget. For eg: If i have year selected as 2020. Then columns are 2020 Bugdet, 2019 LE, 2018 Actuals..... I want to make the year part dynamics across the…
-
Dynamic display order for folder containers
Hi everyone, I'm trying to do the following: I have 2 folder containers on the same screen. I superpose them and have a button that aim to display either one or the other (i.e. when clicking the button, the chosen container is brought to the front). In order to do that, I created a flag cube. If the entity corresponding to…
-
How to Calculate a Day and Today?
Hi All, I want to calculate day and today, How Board handle this case?
-
How can I group specific entity members?
Hello, I created a dataview with about 1000 rows ordered by quantity. I need to see the first 3 rows with the related data and a 4° row with the sum of the 997 remaining members. How can I do? thank you
-
Calculation between entities
Hey ! For the first day of the week, its me again. Lets say we have a cube with an entity called "position" it has like 30 members showing various numbers. Now I put them into a Dataview and everything is fine. One of those entity members is the total output. What I need is, a column with the percentage amount of the total…
-
Screen get distraught
Hi all, I have created a screen in my PC. I looks fine. But when I send the same to someone else in his PC or i m trying to show these through the projector, the screen object get distraught. I have tried with screen lock property also. Please suggest what to do.
-
Problem filttring on a cube
Hello, I have a cube Reporting Group with 3 dimensions : Month, Company and Group chart of accounts[R]. Group chart of accounts[R] is the replicate of Group chart of accounts which is in the following hierarchy : |------ Company General Ledger --- Local chart of accounts |------ Group chart of accounts ---- Account…
-
Broadcasting & pager
Hi, I would like to use broadcasting to create a series of files (subdivided by a particular entity) each of which has inside it, a panel container with "n" objects (dataview, graphs). Obviously, there is a pager for this entity. There is also a dataview to which the broadcasting refers, always expressed for the same…
-
Max Value
Hello! Is it possible to compute the max value of a cube on a not-time entity? I need to memorize this value inside another cube. Does anyone have any suggestions? Thank you!
-
Chart on Screen using other Database/time selection
Good morning everyone! I have a screen with 4 charts. One of them is using a different database. The problem now is, if i´m making a time selection on my timebar, that chart is still using the time selection from the other database and its not changing. How can I manage this? Thanks for your help again and have a nice day !
-
How to filter data with (not)exists?
Hi all, I'm trying to select customers that buy a certain product (sql equivalent of exists). And I want to display their total sales, not just those of that product. Similarly I want to search for customers that don't buy a certain product and display their sales. How'd you best achieve that in a dataview or for the whole…
-
Giving alert/warning in cell based on Total
Hi everyone, I'm new in Board, it's very helpful, for beginer to create dynamic culumativeCreating a dynamic current month flag (or previous nth month) --> (MTD / YTD is created from 'add block' after you clicked 'Edit formula' in Dataview). Then now, I just wanna know, Is it possible to put an alert/a warning in the last…
-
DataView, creating a table 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)…
-
How to align graph with 2 axes
Hello All, I have a graph with 2 axes, first axes for EBITDA and second axes % EBITDA vs revenue. The 2 zeros of the axes are not aligned as you can see in the attachment. Any suggestions? Thank you and best regards Marcel
