-
Bar Chart in HTML5 - Cannot click on bar due to hover window
Hi everyone, I am building a reporting for a client at the moment and they want to be able to click on a bar in a bar chart which will take them to a detailed report which shows more information. In theory no big deal, I have set up everything accordingly, but now I am running in an unexpected problem. My chart is at the…
-
Fiscal Calendar in Board
I am have some issues trying to implement the Fiscal Calendar which start in April... Also When a prompt is created can it use hierarchy or trees Example: Year 2017 Fiscal Year Fiscal quarter Months
-
Text Cube
Hi, I have a text cube that is linked to two entities (lease and currency) but not day, month or year. I'm using the text cude to record comments for the entire period in the first report and I would like to reuse the same cude in a second report to display the comments which is driven by the month entity. Is there a way…
-
Performance trade-offs : 128 bits sparse versus dense and 64bits sparse ?
Hi all, everything is in the title: very often when designing cubes or cube versioning, I have a choice between these two kinds of structure: - Entity A (D), Entity B (S), Entity C (S), Entity D (S), Entity E (S) => Smaller physical cube size but 128bits sparsity file. - Entity A (D), Entity B (D), Entity C (S), Entity D…
-
block-specific cell border color within a dataview: how ?
Hi everybody, In a dataview, i try to have different colors (for each block) in terms of cell borders. A parameter for cell border is also nice to have. I don't find where to set this up. I have looked there: * Dataview Menu > Layout > Block configuration > Format: I can set foreground and background color of the cells,…
-
data reader file name substitution variable
We have data files to load that have been prefixed by the Business Unit and Month Year e.g. BU123_Jul.17_SalesDat.txt We have corresponding Month and Business Unit entities in the database. These are available as pagers in a screen. I would like to utilise these to dynamically pass the user selections to the data reader…
-
Can i copy/paste data from Excel into BOARD?
Hi, would it be possible to copy data (or a set of cells/a range) from Excel directly into BOARD? i need to feed some data from excel into a planning table and i am not sure this can be done. Are there any logics to be considered? Thanks
-
What kind of database is BOARD? Graph, relational or something else?
BOARD does some great stuff with the HBMP database technology, but what type of database is it? Is it a graph database? Is it strictly OLAP? I don’t think it’s relational. I’m just trying to understand more about the theory behind it.
-
Passing values - no CSV in here please
Hello BOARD community. I wanted to contribute before I asked a question but this issue is perplexing and I really want to know if it can be achieved. I want to disseminate values of a cube to other cubes which have the exact same members but use differently named entities and live as parents in other trees. I do appreciate…
-
Format kept in the "groupby"
Dear All, How to have the "GroupBy Background" in the same format of the block ? In my attached file (collapse view) I would like to have the total of the first column in orange, then the 3 next columns in red... Thanks for your help. Hervé
-
examples
New here and looking for a few examples of what others have done? Tried looking around but wondering if there is a specific place to go with some samples and ideas?
-
AWS MySQL Connection
Does anyone have any experience connecting to a Amazon MySQL database? I am having difficulty getting it to connect to the datasource.
-
Calculate contract value per month
The question is how we can calculate the value of a contract. We have the value per month, as an example: 12 Months with 100 euros per month. January 100 euros February 100 euros March 100 euros etc. In Board I would like to see as a result January 1200 euro (sum January to December) February 1100 euros (sum February to…
-
Values in Dashboards/charts overlap with the bar
Does anybody here have an idea or already had the same Problem and has a solution for it: We often have the case that values in Dashboards/charts overlap with the bars (see attached screenshot). Our customers are not amused about that fact as you can imagine. We do not have any clue how to influence the chart where to…
-
Read Log Files into a Capsule
Good morning I have a personalized admin capsule where i do administrative jobs like load cubes data and i would like to reads the logs file generate from the import into a screen. do anyone has experience on that matter ? A good example is the task manager screen where you can see e formated log with head columns
-
Setting up security for hundreds of users
For a large number of users, is there a way to quickly and easily setup the security access rights rather than doing it one by one manually? Is there a template that can be uploaded into BOARD or can we import a Windows Group? Can you please send very detailed information and step by step instructions on how to do this in…
-
How to use 'Reset to current screen' feature in select action
I really confuse about the feature below in select action in process modeling. Can anyone explain it and give me an example? Reset to current screen. Resets the selection to the state of the select when the procedure was launched.
-
Problems with uploadin data via EXCEL AddIn into a Cube
Hello, by accident a Cube was cleared and shows no data anymore. I was able to retrieve the data in EXCEL from another resource and tried to upload the data via the EXCEL AddIn. It worked, but once upon a time it doesn't work anymore. For this cube we have a limitation, that you can only enter data in the current month.…
-
How to calculate days difference and excluding Saturday Sunday?
In Excel/Google Sheet, we use NetWorkDays formula. How to do this in Board?
-
Data Flow does not run in HBMP mode
Hi all I have a data flow that is expected to run in HBMP mode, but it doesn't. And it takes too much time to run. Only setting "Try Force HBMP mode" it runs properly# See picture. Can someone help me?
-
Top Bar in iFrame when navigating to other screens
When navigating to another screen with clicking on the button, the Top bar is reappears itself again. (See screenshot below) Aim would be to hide the #top bar permanently - not reappearing after #navigation to another screen. Since the Board Reports are going to be implemented in an existing #web #portal. It is not an…
-
Excel - SetSelection
Hello, I am trying to use the SetSelection formula in Excel to control multiple layouts (Board v9). The following formula works: =SetSelection("Finance","Year=2018") but when I try and change the entity to Fiscal Year it fails. I thought it might be because Fiscal Year is technically a custom time entity or because there…
-
Export screen with two objetcs to pdf file
I need to export (or attached via broadcasting) a screen with two objects o more. I need all screen objects in the same page
-
Drill down in the web with flattened layout
Hi all, For excel export reasons (see Export Data to Excel in Flattening mode for Web client ) I built a layout using the flattened presentation, with 2 entities by row (Legal Entity then Material). Before using the flattened option, I could drill down by clicking on my Material entity. Now that it's flattened, I can drill…
-
Day description British / Australian format
Hello community, We have installed Board on a new Azure cloud server and the day description is giving me a hard time. I have changed the date format on the server to what we need and changed the region to Australia, the description has changed in tables but not for the entity (in selections) itself. I have a selection for…
-
"The given key was not present in the dictionary" error
Hi community, The following error message shows up when trying to access a specific database: "The given key was not present in the dictionary". It is not possible to access the DB, and the capsule linked to it can't retrieve any data. Can anyone tell me what's the root cause of this error? Thanks.
-
Sliding panel LAYOUT - not getting all 3 options
Just wondering if anyone else out there has had this issue, when I try to edit the layout using the sliding panel I can't edit 'everything'. Some DV's will only give the 'dot' for columns, some don't give any dots at all. It's just my machine, the exact same capsule/screen on the same server works for my colleagues. Has…
-
How do you load data from a postgreSQL dB?
Greetings everyone, I'm a brand new user to BOARD software and am simply trying to connect to some of our various data sources including our IT Ticketing system powered by Service Desk Plus ManageEngine. I've downloaded and installed the PostgreSQL ODBC connectors and was successfully able to configure and test the…
-
Dataflow resulting in small digit differences
Hello, i have an unexpected behaviour with a Dataflow. Performing a simple calculation, C = A + B, a double cube is somehow getting tiny amounts. All cubes are Double type. Representing the information in a dataview, all rows only have numbers with 2 decimal places: yet the subtotal shows very small digits differences…
-
All masks disappeared!!
Hi, all of a sudden, all of the Capsule Masks disappeared and i cannot browse through them even though i can see which one is associated to every screen using the Screen Settings options. What happened? Does anyone have this situation or has faced this situation as well? Thanks everyone for your help! Regards