-
Showing 3 different dates in a report
Dear, One of my clients would like to have a supply chain report wher in 3 dates are available. Creation date, shipment date and requested confirmed date. So creation date of the order and shipmentdates and requested dates of the order. I don't know what is the best practice is creating something like this. Do someone has…
-
Filling MXC cube fails
I created a MXC cube to be able to find out how many parts a supplier delivers. When I fill the cube with the data reader the process fails and I don't have a clue why. Any ideas? ------------------------------ Andreas Jeske Anwendungsentwickler Nolte Küchen GmbH & Co. KG Germany ------------------------------
-
psexec
dear all, someone used PSEXEC in Server-Side Procedure? We tried to use but doesn't work and no logs wrote. We need to launch a BAT to another server in the same network. This .bat works if we launch by task scheduler. Thank you ------------------------------ Mirco Righetti Responsabile Business Intelligence CALZEDONIA SPA…
-
Login Web Issue
I have issue about Login Page in Web Mode. Every login, Screen Login redirect to Logout screen automatically. Can you please help resolve. I have not saved the session ID in the bookmarks and just using URL. ------------------------------ Harsha v Financial Systems Lead Technicolor Limited India…
-
pattern based allocation - how it works?
Hello all, I'm searching for a description (Doku, Video...) for the function "pattern based allocation". How must it be configured? I hope someone can give me some help. Thanks in advanced. ------------------------------ Stefan Batalia Board Administrator Arntz Optibelt Group Germany ------------------------------
-
Excel Addin BSAVE Function
Hello, I am looking for help on the new BSAVE function (Board 10.6) I didn't find recent documentation about Excel Office Addin. Thanks, Karel K.
-
Update User "Personal Info"
Hello, Is there any possibility to update the "personal info" of an user by upload? Kind regards, Marco Oerder ------------------------------ Marco Oerder BI-Reporting Optibelt GmbH Germany ------------------------------
-
LOG MANAGEMENT AND ANALYSIS
Hello all, we are using Board Version V10.1.4 with Windows Clients. We will update to a newer version, but before we do that, we will look for old not needed reports. I know from the pass that we had a tool (Capsule) named "Log Management and Analysis". Have someone a documentation how to use this? Thanks in advanced.…
-
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…