-
Revenue and expenses positive
Hello everyone, I had this question a few times now and I have always tried to talk clients out of it, but I thought I ask the community in case someone came up with a solution. Is it possible to have positive values for revenue and expenses and still have subtotals and grand totals that make sense? BOARD just aggregates…
-
Procedure to extract list of users
Hi, I have many databases with special security profile depends on users entities. Today every time I create a new User I have to create the entity and use it in different cubes and others. If I can extract the user list in a procedure I can fix everything I need, but I don't find in the procedure list the option to…
-
Selection in Screen after Reload of Entities
Dear all, we wanted to clean up our database from entities, that are not needed. I decided to do it from scratch. Therefore we are extracting the cubes, clear the entities, reload the entities and reload the cubes. Looking at some reports I noticed, that the selection in the capsule/screen has changed (see screenshot). Is…
-
How Do You Display Percentages on Pie Chart
On a Pie Chart is it possible to display the percentages on each slice of the chart.
-
Set Data Entry to All Row
Hello, I want to set a date in data entry. I just want entry only once, and the another row automatically filled based on entry the first data. Can BOARD possible do that? and How? Thanks, Best Regards
-
Data Reader Warning
Hi everyone, Does anyone know about this message? This is the message when I run the Data Reader. Warning : RBT1826 The value [0] found on column 34 is not valid and cannot be loaded into the cube?? From what I've seen, there's nothing wrong with the data. Thanks.
-
Query Data Reader (SET DATE)
Hello Everyone, I have a case. Just want to read a Data Reader from Excel data. So i used the ODBC Excel Driver. I used manual query, because want to set a entity with a current date (format 'yyyyMM'). So i used (like picture below) this query like SQL Query, but obtain an error. Any solution for this case? or what…
-
Seconday Y Axis - Web Client
I've been working on the web client and I have been unable to set which Cube uses the seconday Y Axis. Cheers ------------------------------ Board Ver 10.5 Jason Ferguson Australia ------------------------------
-
Migrating cubes to BOARD 11.2
Hi, I have been unsuccessful in being able to migrate my cubes from a BOARD 10.5.1 database to BOARD 11.2. The database conversion was successful, but the cube reload fails once it hits a cube with multiple versions. How do I complete the migration of cube data to the new database? Thanks, Stephen
-
Clustering and B11
We have a BOARD customer that need to use BOARD in very remote location(s) via satellite connections. We've done our best to build a solution to allow for the expected latency (tested via latency simulation), but now they appear to be having bandwidth issues at the first/test site. We're wondering if Clustering is an…
-
Performance of a Progress JDBC Driver in a C2P architecture
Hi, question to community: I have a Progress JDBC connector installed on Cloud, and I can't optimize data transfer with Progress options. I have a Board Cloud Application connected to a Oracle On premise DB. My performance now are: ~30k record at second with optimization of oracle table index and the initial query take…
-
New Forum
Hi Boarder! That looks really nice! I'm curious how this community-site will develop! Wish you all good luck and especially health! Come well through this difficult time! ------------------------------ Dirk Magerkord Leiter Controlling - Prokurist Dachdecker-Einkauf Ost EG Germany ------------------------------
-
Missing relationship log
Dear all, does BOARD have a log on the missing relationship? I am looking to allow to the user to check if normalisation occurs and/or if missing relationship happens on the capsule.
-
creating action in procedure is slow
Hi I need someone' help to solve a problem. It cost 10 minutes to creat an action in Capsule's procedure, it was very slow,but it is very fast to open a datavflow in Capsule's procedure.If you know the reason,could you tell me the reason?
-
Column algorithm
Hi, I want to ask how many function that can be use in column algorithm? I have already downloaded below functions from board . --->BOARD - Layout Algorithm Syntax Are there any more functions that can be used in column algorithm? e.g. like date compare function ? string compare function? thank you Hanyue
-
Why it costs so much time when open a dataview?
The dataview that I created is not that complicated, but it cost much time to open. What should I do to adjust it ?
-
Migrating to new Server
Hi all Looking to migrate from our 2008 server to a 2016 server. Currently on board 10 but have downloaded the latest board 11.2 server setup and 11.2 web. Is there a guide anywhere with the correct process to migrate from one server to a new server? Database backup, and all the files etc ? Cheers
-
BOARD Chart Object
Hi, we want to implement a central dashboard (SIOP Graph) for our logisitics guys in the plants. The central chart is a combination of a few kpis, which build the different bars. Another aspects are the vertical lines, which show thresholds. My first question is: is it possible to create a chart like the one shown…
-
Dataview Axes Vertical Alignment Shows All Empty Rows
Hi Community, I have encountered a peculiar behaviour of Dataview (align Vertically) and would love to get some feedback from any Board experts here. I have a Dataview which I changed Align from Horizontally to Vertically, with Show All unchecked on both By Row and By Column. The Dataview (when aligned Horizontally), will…
-
Rule only partially working
I have a rule that is only partially working. The rule itself contains a great many calculations in an entity that has approximately 600 members to emulate an existing calculation. Simply put, some of the calculations in the rule are calculating correctly, and some are not (it matters not whether the rule for the line item…
-
Broadcasting in Admin Console
Hey, we are using 10.6 (Revision 0.1.32761) and I wanted to try out the Broadcasting functionality. Everything is configured so far and we are able to use the "Send To" functionality within the presentation's panel. But there is no "Broadcasting" tile in the administration panel. Did I miss something? After setting up the…
-
bar chart markers
Hi, I have a problem with the rotation angle of the bar chart markers. I'm using the WinClient Version 10.6.0.2. I'm able to set the rotation angle within the WinClient, but it will not show in the live view of the screen. The rotation for the primary x axis is showing in the live view. For details see my screenshot. Can…
-
B11.1 web error message "The client application is not known or is not authorized"
Hello, I am trying to connect to my Board Web server from a remote computer and the web page gives this error message: The client application is not known or is not authorized note that, when using the local browser direct from the BOARD Server, the http://localhost address resolves properly and i can log-in as a BOARD…
-
Dataview with "last day" values in a different column
Hi everyone, I need to create a screen with time selector between two days. The first columns must be the data accumulate in the period and the last columns with the information about last day selected. In this dataview I used refer to "Day" and selected 03/02/2020 but I need to change if I select a different day. Any idea…
-
Read Only cubes and data readers
If a cube is read only as configured on the Database Security for a database profile is it so that in a procedure that clears will work (clearing all cube data regardless of entity access the user may have) but that data reader will not load anything into the cube? We are seeing this behavior but somehow I'm surprised by…
-
Excel DATE and EDATE functions
Hi, Do the Excel "DATE (YEAR, MONTH, DAY)" and EDATE functions work in Data Flow in Board - I tried, but it does not return any values. The cube is just empty - looks like Board is just ignoring any calculation using these functions.
-
Automatic Download of Reports
Hello all, we are searching for a conclusion/function to download a capsule (a report on different screens) in excel and pdf on a regular base automatically in a great/defined format. It is one thing that the reports are now perfect dynamically ready but in some cases we would like to store them for documentation,…
-
Screen Navigation with Procedure breaks Pager
Applying data selection to screen via procedure breaks default pager functionality. Example; I have a pager which defaults to the current period/month. I have a button which activates a procedure which does the following: - Remove Tree (Month) - Selection (some P&L item filtering) - Go to Screen - Apply data selection to…
-
Log-File in case of "Reload cubes"
Dear all, we want to clean up our entities. Therefore I have created two procedures, one is extracting all data from the cubes and emptying the specific entities. The second procedure will then load all the entities and reload the cubes. During the reload cubes procedure I noticed, that I already get some rejections. Is…
-
Nexel Writeback Configuration
Hi all, I was wondering if anyone could please explain what do the two settings below control when enabling Nexel Writeback and in which order do we select them. As per the Board Help Guide: Nexel Write Back Command : it executes the Nexel Action in Data Entry mode paging throughout all the dimensions of the target cube…