-
How to use the API to exchange data between Board databases ?
Hi all, I have been wondering recently, with the new Board API functions, is it possibe to use it to read data from a Board database to another, or within the same database (to manipulate data through mapping and / or ETL functions that would not be possible through dataflows) ? If yes, how would you do that ? Thanks,…
-
Update SQL DB
I know that I can create an infocube using RDB. My ODBC connect is set with user who has read and write rights. Can I update my SQL Table with Entity data or MDB inforcube data using the RDB infocube? How do I accomplish this task? Thank you for your help. Tuyet-Lan Faber
-
Dataflow using rule with datapicker issue
Hello, I am having an issue with a dataflow where I apply a rule to the source cube in order to populate some metrics. The rule uses data picker to populate data for the entity. After running the dataflow, the target cube is empty, however, the source cube displays the correct data when the rule is applied. * Source cube…
-
Auto refresh of a screen
Hello, We would like to use ROLAP (RDB) Cubes to show nearly real time data. Is there any possibility to auto update a screen or an dataview object in a time interval. Board Web. 10.7. Kind regards, Marco Oerder ------------------------------ Marco Oerder BI-Reporting Optibelt GmbH Germany ------------------------------
-
Sorting on Nexel column
I just tried to sort the content of a dataview by using a column that is based on a pretty simple Nexel calculation (single rule), but apparently sorting does not work on Nexel columns. Data type is numeric. If I click on the header of the column, sorting is working fine, but I would like to have it automatically, on open,…
-
Pager in ATO Enabled Panel
Is it still possible to have an ATO enabled panel with a Pager in 10.6+ web? In WinClient we drag the panel onto the screen, enable ATO on it, then drag a Pager into the panel. When I do that in 10.6 web I get… "you cannot drag a Pager as a child of an ATO" I'm hoping there's just a different process to achieve it, and…
-
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…
