-
Dynamic date in Header
Hello all, how can I insert a dynamic date in the heading of a report? Thanks in advanced ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
Cloud instances and DB Log: how to?
Dear all, does anyone have experience of BOARD DB log with a cloud instance? Is it possible to access to datareader/dataflow processes with a cloud instances? Where is dataset folder? ------------------------------ Giulio Vialetto Consultant KVALUE SRL Italy ------------------------------
-
Trick to add a merged cell header on top of a dynamic dataview ?
Hi all, We have a P&L dataview with a lot of columns so it is hard to read (and the request is to keep it like that because it should be exported to Excel in 1 block) Business need The business team wants to add a header on some columns (similar to merged header cells in Excel) with the last month selected in the SELECT to…
-
Board 11.3 : Initial thoughts
Hello all, After one week with BOARD 11.3 here are our initial thoughts What I like - For ADMINS - Data management : With Board APIs we can now share data with other softwares like an intranet portal - Reduce administration time : We are now able to sort members freely in entities. It will save us a lof of time! Another…
-
Data Entry on Total effecting only unlocked months
Hey Guys, I'm just looking for some help on how to optimize this dataview. Right now the view is pretty basic. Block 1: The cube to data enter into, by Account by Month by Cost Center, Locked by Cube in block 2. Block 2: A cube to flag which months to locked, by month. I want to be able to enter a value into the total…
-
Screen fit, Fit to single page changed after restart
Hello all, when I change the settings "Screen fit/Fit to single page" this settings will not be stored. When I reopen the same screen I must do the same again. Is there a possibility to save this setting? ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
Use data flow to write result of rule to infocube
Hello, when I apply a rule to a block in a data flow, the calculated rows do not get written to the output infocube. Is there any way around this? Eg; I have a rule 1: Units 2: Gross per Unit 3: Gross [=1*3] But when I run a dataflow with this rule, the value of 3 does not get written to the output cube.…
-
Documentation on how to migrate from Board from 10.1.3 to 10.7
Hi, Is there a step by step instruction guide for upgrading Board from 10.1.3 to version 10.7 ? Can Board version 10.1.3 be directly upgraded to version 11.3 ? Please advise ------------------------------ Vincent Dsouza Business Intelligence System Analyst Victorian Order Of Nurses For Canada Canada…
-
What is the best way to "move" a value from an entity member to another member ?
Hi everyone ! I hope everybody is doing well. I'm currently facing a nice challenge in my new board application, regarding a quite classic "Phase in / Phase out" process. Context: It is a budget planning application, nothing very original about that :) In this application, we initialize the process by copying the latest…
-
Launching batch file from BOARD 10.5.1
Hi, I am trying to launch a .bat file using a server side launch procedure to run a python script on the server. The batch file runs when it is manually launched on the server, however it doesn't run when called via the BOARD procedure. I was wondering if anyone else had experienced similar / has been able to launch batch…
-
SAP BW / Board connection
Hi community My company is going to introduce SAP and Board will likely keep data from a BW instance. I know that SAP Connector is able to do this. We are now investigating about costs related to this solution. More than the costs related to: - purchase of SAP Connector - human resources to analyze tables and set functions…
-
Services restart not working consistently
Hi, I restart the services each night via a batch file. According to Task Scheduler, the task is completed every night. Yet, half the time, databases are loaded into memory that have not been accessed since the previous day - indicating that the services did not restart. The main issue is high memory usage before the…
-
Set up connection to MySQL
Dear Community, I need to connect to a MySQL database to import data into Board. Is there any help on how to set up connection using the cloud version of Board? I can't find any threads relating to this topic unfortunately. Thank you in advance for any help you can provide me. Kind regards Alicia…
-
Services restart not working consistently
Hi, I restart the services each night via a batch file. According to Task Scheduler, the task is completed every night. Yet, half the time, databases are loaded into memory that have not been accessed since the previous day - indicating that the services did not restart. The main issue is high memory usage before the…
-
Web broadcasting 10.5
After upgrading Board to 10.5 I'd like to use broadcasting from web client. I can create a new Broadcast without problems. But it sends no mail to the receivers and I can't find error messages or logs. I guess I have to configure the new Mailer Service how to send the emails. Maybe using file "broadcasting.config" in…
-
Data Flow Target Formula vs. Procedure Debugger Layout
Hello, Thank you for taking the time to review this query! I am trying to understand why the algorithm in our target cube does not calculate properly when running the procedure. However, if we insert the same formula in an algorithm block in a Procedure Debugger Layout the algorithm block calculates accurately. Any help is…
-
Why can't we prevent a datareader to either saturate an entity or load into a saturated entity ?
Hello Community, What a good surprise this morning when i saw that an entity in my application was saturated ! Even better surprise, when no alert was displayed in the web client !!! Even better surprise, when i saw that a datareader that was running at 3:45 AM and has saturated the entity ! Even better surprise, when no…
-
10.7 - Procedures just 'stop' populating cube without any change in cubes/entities/procedure... he
Has anyone else out there had issues in 10.7 with Procedures that were working just suddenly stopping working and populating cubes with 0's......AND known how to get around it? It can be thins as simple as standard/straight dataflow that 2 minutes ago populated the target cube, add a new action to the end of the procedure…
-
Drag and Drop an existing objekt of a screen in the container tab object in Board 11.3
Hallo everybody! I would like to drag and drop an existing object of a screen in the container tab object. This existing object should be a new tab of the container object. The existing object has an individual format. I only find the possibility to drag and drop objects from the the left object list. After using this way…
-
Repetitive DataFlows
Hello all, hope you are fine and doing well! I have following question: Can someone tell me how to easily adapt DataFlows with a similar configuration? Right now I have an entity with 100 items and I'd like to create a comparison cube with that entity (ACT,BUD,FC,PY). Each comparison has its own cube and I like to filter…
-
16:9 in mask settings not actually 16:9
Has anyone else had issues trying to create a mask/screen using the 16:9 settings where it doesn't actually 'fill' a 16:9 screen? I can set the mask to 16:9 and put a label taking up the full width/height on the screen available (in edit mode).. yet when you go to 'view' you end up with a big pile of white area on the…
-
Putting week data into a chart by where one year has 53 weeks and another has 52 weeks
Hello, We have a capsule which shows a chart with data by week. Because 2020 had 53 weeks and 2019 had 52 the chart shows zero for the corresponding week in 2019. Our user in her previous Excel report would go back 52 weeks for the comparison to avoid this problem. Is there a way to do this in Board. Currently we are using…
-
email report
ciao, I'm using board 11.2, I want to send in pdf format a dataview by email, all works but if there are more rows than the space available I receive the pdf with only part of the rows (I see the scrollbar in the right). It is possible to send a report done by "create report" (option in the menu of the screen) where the…
-
Alerts Not Showing on Presentation Excel Extract
Hi, I have a Presentation scheduled to be emailed to 4 recipients daily. It's an Excel extract. Within the Presentation, one of the screen has an Alert that turns the numbers red based on a certain condition. On the screen I see the red font, however on the Excel extract in the email, it doesn't have the Alerts. Does…
-
How can I export all tabs of a screen into one PDF?
Hi Experts, I have a screen with multiple tabs (one tab for each Business Unit) that show MTD data. When I click on Export Printable Report --> PDF, it only exports the first tab. How do export all the tabs into one PDF, with a page for each tab? Thanks! ------------------------------ Jon De Leon Manager, Financial…
-
Pattern Style in Labels, Data-Views, Charts
Hallo everybody! Is ist possible to use a pattern style in stead of a colour? At the attached Excel-File you can see an example at the bar FC. ------------------------------ Thomas Schendl Bereichsleitung Finanzcontrolling Holter Verwaltungs GmbH Austria ------------------------------
-
Automatic silent setup from the Board Client
Hello all, we try to setup the Board Client with a silent setup, see below: Nothing happens when we press Enter. Has someone an idea what it is wrong? Much thanks in advanced. ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
How can I export all tabs of a screen into one PDF?
Hi Experts, I have a screen with multiple tabs (one tab for each Business Unit) that show MTD data. When I click on Export Printable Report --> PDF, it only exports the first tab. How do export all the tabs into one PDF, with a page for each tab? Thanks! ------------------------------ Jon De Leon Manager, Financial…
-
Import txt. into multiple columns
Hi, How can i import data from a txt. file into Board? The import file contains 20 columns per row with data. These columns are accounts. In board, i have set these accounts up as an entity with 20 members (account a,b,c..etc.) in it. In the data reader i cannot select each account member (a,b,c..etc.) individually to…
-
Add widget to screen?
Is it possible to add custom widget to a screen? Does any control allow to insert custom HTML5 code into a screen? ------------------------------ Giulio Vialetto Consultant KVALUE SRL Italy ------------------------------