-
Load data from MsSql 2016 database
Hi, i need to read data from mssql 2016 /mysql / As400 database, i have create a new connection via Odbc and Olap, but board return this message: The check connection is ok... I have a demo full licenze for 60 days.#
-
Print Screen action not available in web - replacement?
What is the replacement for the 'Print Screen' procedure action that is not available in the web? We have clients producing shareholder certificates, transfer forms, annual tax statements and invoices using multiple objects inside a panel printed as a single object and then capsule procedures to print/save to pdf. I'm…
-
Horizontal percentage
Hello, how is it possible to have a percentage (yellow cell) which is the value of the row related to the total of the row (green cells)? It should be the same we have in the block configuration but working on rows. Best regards, Gabriele
-
Count days
Hello, everyone, I need your help. In order to calculate indicators, I need to count the number of days of the current month. I determine my current month of work via a screen input. I would also like to know how to determine the first and last day of that month. I thought of an input screen to manually fill in every…
-
Screens are not visible in open screens object
I have a list of screens,which are not visible from the open screen object search bar,but if i click the list all the screen are visible and i can select 1.How to get back all the screen visibility in the open Screen object. 2.What are the cautionary steps to prevent this error in future.
-
Hierarchy doesn't get updated
I have noticed that enough a hierarchy (in this instance a Cost Centre Mapping) update is uploaded, they don't get reflected or at least not all of them get reflected. * There were no rejected rows * Most (out of the 600+) of the Cost Centre mapping updates get applied but a few don't * I tried normalising the tree *…
-
Dependent Drop-down List
Hello! Is it possible to create a dependent drop-down list? I have two text cubes (Contry and City) structured by a dummy entity (a counter) and with data-entry option enabled. For the first cube the suggested value is the entity country, for the second one the suggested value is the entity city. If I insert one value in…
-
How to Activate Data entry log by DB ?
Hi everyone, everything is in the title, I'm wondering if it is possible to activate the Data Entry log for one specific database only ? We have an app that would require a precise follow-up of who enters what, but I fear it would impact significantly all other apps if we activate the data entry log for all the server. Any…
-
Web client: Chart show label
Dear all, I have a difference between Web and Win Client. I would like to show labels in a chart, which means that my chart should show the values. Win client is showing the values when I select "Show Label" in the legend setting. But the Web client not. Is there any way to show the labels in web? Regards, Jörn
-
Total Column appearing when it shouldn't
I've just encountered an issue in a dataview where the total column appears even though 'row totals' is un-selected on the block (appearing in 10.3 and 10.5) The ORANGE column below should not be appearing. The cube/block it relates to is dimensioned by an entity called 'Column Header Hours', and the block is set to data…
-
Column with percentages
Hello, I would like to insert a column with the percentages of the Profit and Loss statement related to Net Sales (see example below). How can I do it? The cells in blue are calculated using Rules. Best regards, Gabriele
-
Screen Security
Hello Board, I wanted to know how to define the security of some screens located in a single capsule, so that not every users can access that screen. For example: I have the screen "Purchase" and the screen "Sells" and also two users: "Purchase users" and "Sells users". I want that the Purchase users can only access the…
-
Rolling Forecast
Hello, i want to build up a rolling Forecast modell for monthly data entry and adjustments. I have 2 Cubes. One with actuals and one with forecast (incl. Version). Now i want to select a time-frame for the past month (like 01-03) and a Forecast-Version (like April) an fill the Forecast-Cube with actuals from the previous…
-
Data reader error - table is empty
Hi all, I have a stranger thing case with the data read and the ODBC connections. The thing is that when I try to configure a data reader, I can use all the tables in the RDB area but one: the "User" table. The error message says: Table 'User' is empty. The table is not empty and if I try to select the other tables there…
-
Multiple Master Layouts
Hello community, Is there any way to create multiple Master Layouts with different scopes (e.g.: Master layout applied only to the container)? masterlayout
-
Sorting: screen, Excel, printing
Hi, we have several reports sorted by decreased quantities. When we drill using month we have the situation below. We are able to sort it by month in the screen but when we extract it in Excel or we print it it is still ordered as the original. After sorting in the screen Extraction after sorting by month Is there some…
-
board 10.5 - image in a label
Hello, Could someone help me with a question about the web capsule designer in version 10.5? I created a label an now I want to insert a picture but I can not find the setting for this. best regards, R.J. van Kuppeveld
-
Cumulated values on selection
Hello, I have a chart where I show actuals per week (primary axis) and cumulated values (secondary axis) of milestone progress. The cumulated values are YMT with a cycle of 999. As you can see in the graph the cumulated values are in week 02-2019 about 1,200. Is it possible to start the cumulation of the values in the…
-
(FIXED) 10.5 Functions: WEB Object Copy and Paste
A new BOARD release is a very exciting time. Scrambling to read the release notes, diligently comparing version functions from one to another and then writing up the upgrade strategy utilizing the best 'agile' means to ensure the quickest and most efficient pathway to the update and release of all current models. Ah, the…
-
Export Code & Desc
Hello everyone, I'm trying to export a layout but i'm getting only the code of my entities , is there a solution to get the Description & the code together ? Thank you!
-
Chart pop-up
Hello citizens! i'd like to know if there is a way to remove the pop-up that i'm getting in this chart! Thank you guys!
-
Best steps to create a company master template
Hello all, I'm very new with Board. I want to create a master design template for data view with my company CD. What are the best steps? Has someone a checklist with the best order? I created a mask with the company logo/design. Then I created a draft screen how I want my tables/charts to be designed. And a screen linked…
-
how can I change the codes of an entity without ruining the relationship?
Hello dear community, I have two entities "account" and "CF" where "CF" is parent of "account". what I need to do is to empty the entity "CF" and reload it with a cvs file where the codes of the entity have changed. I also have another csv file (account code; CF code; CF description) I use for the mapping of the…
-
Capsules Log-in
Hi everyone, is there a way to access a capsule without select it when logging in with your user account? Thanks, Francesco
-
Rest API Connections
I cannot get Board to connect to an API using the Board Connector. The query runs properly via Chrome, Internet Explorer and the Command Line, the Log File says it cannot connect to the server. This suggests that Board isn't using the machine default proxy settings, but I cannot find anywhere to configure any Board…
-
Hierarchy data view
How can I view the nodes and child nodes in a hierarchy without using a cube? something similar to the attached image
-
Data Reader Error Log
Hi All, Can anyone help me where can i find data reader error log? Because I made a Text Data Reader, and some records can't import, so i want to check what is the error records and why they cant be imported. Thanks and best regards Minh Le
-
Making Data-view(Layout) colorful
Is that possible to give different header color in the Data-view?betina
-
Unable to detect a BOARD SAP Connector serviceSAP Connector
Keep getting a "Unable to detect a BOARD SAP Connector service" when i test any data reader. But the connections to the SAP Connector works fine via the browser
-
REST API
Hello Board Community, I am trying to get data from my web-based ERP through REST APIs. I have created the data source connection using a Basic authentication mode with my credentials and a query with the parameters I used in Postman previously (witch worked). When I test the query, nothing is returned. I looked at the…