-
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…
-
Screenerror with web client
Good afternoon, I have a strange problem with a screen. When I open it with the Windows Client it works without problems, also the items in the pager are shown. When I open the same screen with the Web Client, it shows this red message box with a reference and the pager is empty. Probably there is a solution or do I have…
-
How to use period offset for previous previous year
Hello all, I'm trying to creat a data view with the following layout (for the selected year 2017). I want to see my current plan qty (here 2017), the current year qty (here 2017) and the previous year qty (2016) and the previous previous year qty (2015). But the data for the previous previous year (2015) I get is wrong. I…
-
BOARD Win Client occupies a lot of memory on Windows10
Hi All, Currently, i'm using the BOARD Windows Client latest release on Windows 10. I found that the BOARD Client occupies a lot of memory. It makes my Laptop very hot and slow. I think may be BOARD Client is not compatible with Windows 10. I captured task manager status when i work with BOARD openning. Does anyone have…
-
add "distribute horizontally/vertically" function to arrange screen objects
Hi, this is actually a post for the "Ideas" sections, but i seem not been allowed to post an idea on my own. Reason is, i cannot fill the field "publish locations" 1. What is your idea? Could you "transform" this question into an idea ? Thanks in advance…
-
Load CSV using ASCII when there is missing data
Hi, I receive a daily CSV from a third party. The first row is the column header, the first 5 columns always have data and the next two columns only occasionally have data. When I load using ASCII data reader, I can't load columns 6 and 7 because the first row of actual data is almost always blank for these columns. If I…
-
Display data on dataview with date entities
Dear All, Actually, I want to display data on data view like the picture below, but i dont know how to do. In the left side is the sample input and the right side is the output i want to see on data view. The difficulty is both rows and clolumns is date type, but in Board we can only create one date-time entity only. Thank…
-
Extract and Reload of entities/trees to fix corruption
Hi there, Performing an extract and reload with clear entities is one of the fixes to a corrupted db, depending on how the database was corrupted; however when entity members were deleted manually, obviously there will be empty index numbers in between without a member. As a consequence, BOARD reassigns the empty index to…
