-
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…
-
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
-
How to query active directory from Board ?
Hi everyone, I am currently looking for ways to import in a Board database a few key information about our users, coming from Active Directory. Basically, our user names are email addresses, and I would like to use AD information to associate the location, company, manager name, etc. to our users. This would be very useful…
-
Any Big Data Samples?
Does anyone have any bigdata sample applications I could checkout? Are there any features specific to big data analytics I should review as part of a big data project? I’ve reviewed the Best Practices for Performance Tuning on big data models document, but a sample to play with would be helpful. I’d like to understand more…
-
Execution time in database logs
Hi everyone, We noticed a few months back, while analyzing the performance of our data loading processes, that the information available in the logs was not always accurate. Yesterday I noticed a strange behavior: in the DB log, the "time elapsed" info is half of what it should be. Action…
-
Formatting datetime
Good morning I have a cube with a long date registred on it with US format 1/29/2018 3:50:28 PM it is possible format a screen with this UE format 29/01/2018 15:50 Massimo
-
How to automate upload of multiple Excel workbooks?
Hi, I'm currently developping a budgeting model at a client. That client has decided to only use Board at the HQ for the time being. This means that subsidiaries don't have access to it and still use Excel templates to submit their annual budget. The client wants to aggregate those excel in Board and compare them to the…
-
Copy Layout from a dataview to a chart - error
Hello, I always get an error when I try to copy a dataview layout to a chart. Instead of the info box I only see a white box and have to break of with escape (or that's it). My colleagues have no problems with that move. Can someone help? We already checked all the Board options settings... KR Annika
-
'Try Force HBMP Mode' in a DataFlow
I have recently noticed there is an option under the 'High Performance Mode' in setting up a data flow that tries to 'Force the use of HBMP mode.' I was under the impression that the use of 'High Performance Mode' would have the data flow use HBMP calculation method if parameters were suitable. A few questions: 1) What is…
-
How to save changes in hierarchies?
I need to store and navigate the changes i have in my Customer hierarchy. In our business, each Customer is assigned a Salesperson, and this is replicated into our BOARD data model where the entity "Salesrep" is directly linked to the entity Customer. Over time, this relationship changes and we need to keep track of this…
-
Save credential of web login page on iPad using Chrome
Hi, One of my customer use Chrome installed into iPad to connect to Board web (HTML5, version 10.1.2). He saved password and at login page the username and password fields are correctly filled, but login process doesn't work (after clicking on the right arrow or pressing return button, nothing happen), he must change…
