-
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…
-
E-learning catalog - Part seven - Cloud Management
The course is intended for Administrators and Developers and aims to give a better understanding of how the Cloud activation process works, and which are the actions required (showed in a step by step tutorial) to successfully complete this process. In addition learners are provided with a full overview of the Cloud…
-
E-learning catalog - Part six: Web Experience
This catalogue in conceived to allow Board developers, administrators and user to acquire familiarity with the Web Client workspace, and to allow them understanding amazing features such as presentations, chatting and the cognitive space. Starting from Board 10.5 version, learners will also understand how to convert…
-
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 ?
-
COVID-19 and Board’s Business Continuity
Given the current global situation with COVID-19, we want to reassure our stakeholders that we have taken all measures to ensure full operational continuity. As this new strain of coronavirus continues to spread, Board is focused on maintaining the health and safety of our employees, customers, partners, and other members…
-
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…
-
Patch release for the Windows Client Version 10.6
A new patch version for the Windows Client Version 10.6 has been released. The updated version contains two fixes: * a fix regarding the GeoMap object. The GeoMap is not supported anymore in the previous versions of the Windows Client. All the previous versions do not support this object anymore.The GeoMap is still…
-
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…
-
Intermittent Procedure Failures - 10.6 - Windows Client
Hello, I am wondering if anyone else is having any problems with intermittent procedure failures in version 10.6 as seen in the screenshot below. The procedure works most of the time but these failures continue to occur. The procedure is very simple: It is more or less Go To Screen > Apply Selection to Screen > Refresh…
-
I can't seem to change a cube in the web client?
I am using 10.5 on the web and when looking at a dataview I cant seem to edit a cube but I can add new ones in and delete other ones? Am I missing something obvious?