-
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
-
Display Cube meta data
Hello community, I am wondering what capability or solutions people have come up with for displaying cube metadata to a user, for example when a user is looking at a list of cubes in a data layout for example How can we guide them as to what information a cube holds, besides a consise naming convention, i.e. what…
-
Disable scrolling in Dataview
Hey ! quick question I want to disable the whole scrolling in my dataview not only the scrollbar is that possible? Thanks again and have a nice weekend! Regards Antoni Theodorou
-
Dinamic Data Reader
Hi community, I've the following issue to solve. I have a manual SQL that populates a cube, I need to dinamically pass a parameter in the query in order to let the user "move between days" on a comparison column. I would like to let the user populate a field somewhere where he can write the desired number of days…
-
WebClient: How to change Display mode of "Entities & Relationships" in layout builder?
Dear community, I have received a seemingly trivial question from my end user, but I was perplexed to not find the answer. I am searching for an option to determine the display mode for an Entity inside the layout builder of the web client. More specifically I am searching for the web client equivalent of this: I found the…
-
Get active person by selecting a date
Good afternoon, probably someone has a good instruction guide or example on how to create cubes to resolve this: I have a mssql table "person" and "person-activity". In the table "person" I have the name, code of the person and other anagraphic data of the person. In the table "person-activity" I have the code of the…
