-
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.
-
bubble chart object: what is the meaning of X and Y Positions?
Could someone explain the meaning of X and Y Positions in the settings of a bubble chart object ? What are they for ? what happens if I set X position = 1000 and Y position = -25 ? the help.board.com doesn't explain it. Thank you very much !
-
selector color
Is there a way to change a selector's color ? Thanks
-
Total Sum on top of the report
Is there a possibility to show the sum on top of a dataview?
-
Data entry on totals for column algorithm
Hi, I have a dataview with two infocubes and a column algorithm c=a/b with summary algorithm calculated. On the row axis there are aggregated entity and the data entry is enabled. It is possible to write on the deepest entity. It is also possible to write on totals for the columns a and b (infocubes), but I can't write on…
-
Hide grand totals | Changing the language of time axes
Hey everyone! I have a dataview with downtotals activated, as i needed. But the problem is that I don´t want to see the grand total..Is it possible to hide it? Second problem is, I have months on my x-axis..timerange setup is on german but it still shows everything in english.. As always a huge thanks and have a nice day!…
-
Board Engine Not Starting
HI All, I Have some issue with board engine. Board Engine not starting, I check in community it cause the license expired. So I want to uninstall License First. But when I use Key Manager, it shown error message. How to solve this?Thanks
-
Save data in ROLAP cube with DataFlow
I get the concept of data being stored in the DBMS vs database through rolap cubes. I have a dense cube linked and the table exist (can we override the default table name with something that is more meaning full to our organization?). Then I define a dataview with this cube and enable data entry. The list of ALL entity…
-
Forgot Password
Hi, Are board can "Forgot Password"?i have lost my password.
-
@% total Editable
I have attached screen shot, I want my total to be editable , marked in red ,please suggest the solution.
-
Profile update for data entry doesn't get refreshed
I wanted to grant a user access to data entry. I created a new role, assigned a Lite Plus license, and database profile with "Ok" to relevant cubes for the data entry. Still, this user doesn't get access to edit the gridview. The i assigned the same user an admin profile which i was using to dev and update data, no change,…
-
menu sametab
Hello Citizens, i'd like to know if i can open a screen from a menu on a new tab , i know that i can do it using a label or a button but using a menu is that possible? Yo thank you!
-
Sum Column with Parameter
Hi All, I Have data like this How Board calculate when safety stock is sum Demand Next Week until 3 Weeks?
-
Automotive Webinar content
BOARD in Automotive .... recent Webinar. I have a client in Perth Australia who is a large manufacturer and distributor of Caravans, Recreational Vehicles and Transportable Accommodation for Mining Sites. There was a recent webinar from the US on BOARD in the Automotive Industry which is very relevant. Is it possible to…
-
Yearly cumulated value
Hey everyone! For the most part, the yearly cumulated value function is working fine.. But I have a problem right now, where the result is on every month 0.. the normal value shows me correct numbers, so there is nothing wrong with my data.. Is there anything I have to care about using this function? Because on other…
-
How to programmatically (re-) load a database?
Hi all, we need to reload every other day one of our databases as there is an odd effect (potentially bug) that is solved by unloading the db and then reloading it into memory. The effect is that analytical functions will not have results although they should. Now we would like, as part of our daily routine unload the…
