-
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…
-
how to move reports from desktop client to the cloud?
I received Board training for the desktop client however I didn't get to use it much as the Board consultant provided our dashboards and reports via a website link. Now I wish to continue building reports so that they show on the website login but I don't know how to do so. To be clear, I have no idea how to move the…
-
loading a JSON file into BOARD database
Hi, Has anyone already experienced loading a json local file directly into a BOARD database ? If yes, could you describe roughly the technical way to do it ? Thanks in advance,
-
Beam &(Predictive analytics & Clustering)
Hello citizens, Someone here would have the best tutoriel to Learn how to use The Beam on Board? Merci, Fethi Z.
