-
Dataview Layout: Impossible to apply a filter when an aggregation function is used
Hello community, I'm quite new here. if this is not the right place for this question, please redirect me. I have a Dataview layout in which I use an aggregation function to display the average value for my block along the time entity "Month". When I try to apply a filter to this layout, it has no effect. However, when I…
-
Hmmm... can't reach this page. Localhost refused to connect
Hi all, I have installed the on-premise version 12.5.1 on my new laptop. The Board Engine and Board WebApi Engine services are up and running. When trying to open Board in the web browser, I don't even get to the Board login. A message pops up saying "Hmmm… can't reach this page - localhost refused to connect". I've…
-
Does BLOB cubes are stored in RAM or in DISK ?
Hello, I have a lot of BLOB which purpose is just to to load an extract cube file exported few seconds before on the dataset folder on the server So end user can retrieve that cube export withtout having to connect to the server. ⇒ Does files stored in BLOB cubes are also stored in RAM or only in DISK ? Means If I have…
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
-
Is there a way to extract a file name in the data reader ETL?
Hi Board Community! I am working on creating an ETL logic to dynamically extract months to a correct fiscal year. The complication comes in because there are some of the future years that need to roll up to the year end of the particular (past) year. I know that there is the formula in excel that allows you to extract the…
-
Importing Data from PowerBI Dataset
Hello, has someone an idea or experience in importing Data from a PowerBI Dataset as Data Source? Best regards
-
An unhandled error occurred (cod_ref: 1695366869500)
Hi, I found abnormals numbers in some input cells (see screenshot). And when I try to type a normal number I get this error message: An unhandled error occurred (cod_ref: 1695366869500) Does anybody know what does this mean? And how to correct the input? Thanks in advance
-
Cube Visibility based on User
Hello, According to documentation, it should be possible to apply Cube Visibility based on User. See screenshot below. But I can't get it to work. Even if I'm logged in as Patrick Stewart (as in the Board case below), and I deselect Patrick from Cube "User enabled", I will be able to see whatever is ticked in the Granted…
-
Net Present Value
Hello, I've been trying to find documentation on the Time Function Net Present Value - what it does and how it works. Can't find any documentation. The function seems to be available in a Dataflow, but not in a Dataview. Do you know? Thank you
-
What is the best way to setup a demo database?
We would like to setup a demo copy of our database where we can demo to user groups but mask customer data. Is there a best practice way to achieve this?
-
Is there a way to default the naming convention of exported excel tabs to code for the entity export
When exporting a Board screen to excel and choosing to page by a given entity that within Board has been set to "code" as the default setting for that entity, the exported tab pages within the excel document appear as the description of the entity and not the desired code of the entity.
-
Is it possible to select the years shown in the columns via selection in a Gantt Chart?
I have two date cube dimensioned by task that I need to visualise as a Gantt Chart. Now, I want to not show all the years but restrict it to only a few, however when I select years in the time dimension it does not restrict the shown years in the Gantt Chart. Is there a way to select the years I want to show?
-
Data reader failing with error "ReadGo4EseguiCUBESdo failed for ddv" in diagnostic log
I have a client where SQL data readers started failing to fully load data yesterday with the error below in the Diagnostic log. A trace in SQL shows the queries executed properly and the other Board logs show the correct number of records. No other functionality in Board appears to be impacted. The client is using 12.4.0.…
-
on Prem Board portal to upload file feature
Hi there, I would like to know is it possible to allows file upload function thru my Board portal? Situation: A screen layout at my Board portal to allows Excel file upload thru portal. Then the board portal will show the uploaded data in table form. Example, my screen to have template allows user to download the template.…
-
Moving a new model from sandbox to production
What is the best method of moving a newly developed model from the Sandbox environment to production using vs 12.6 in the cloud?
-
Where can I download the latest onpremise pack
Hello, My company is a Board partner, and I would like to download the latest On premise installation pack (>12.5) in order to get a hands on experience. Could you please direct me to where I can download it? Best regards, Alexis Leperlier, Primexis
-
Translation : Having different german translation per country
Hello, We are using cube language feature for entity member translation with following language : EN / FR / DE Now, we have some country requirements to have german translation that should be different per country, eg: German for Switzerland German for Austria German for Germany Is-it possible ? regards julien
-
Board Office Add-In no longer works
Hi, for one Board user we had installed the Office Add-In 12.5 and that worked. The Board tab was visible in Excel. But from one day to the next the Board tab disappeared from Excel. I uninstalled and reinstalled the Office Add-In, but the Board tab no longer appears in Excel. However, it was working until recently. What…
-
Excel AddIn Documentation
Hi Boardies We are currently trying to solve it with the use of VBA since no native solution came to our minds and we want to automatize it as much as possible. The problem is following: A single table (lets say, country, year, period (BoP, A, EoP)) grouped by countries on one screen. From the Excel sheet the table should…
-
Is it possible to add a "+" symbol in front of positive values?
Using the image above as an example, is it possible to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? (as this is requested in multiple views) I understand it's possible to add a prefix in block formatting however that wouldn't recognise a value as <>0 so it would place a"+"…
-
How to also export the Layout settings to Microsoft Excel Workbook for BOARD Add-in?
Hi, I am currently exporting data from my report directly into excel. I can then connect my Board office add-in to the table and apply selections and everything possible using the office conector. The problem that I am having is the value formats. In my report in Board (online) I have parenthesis instead of the minus…
-
NEXEL - Send Summary Results To...
NEXEL has a function labeled Send Summary Results To:. See the last line of here. Has anyone had any luck with this functionality? How about NEXEL Crossview? nexel
-
Nexel when transitioning to Web Capsules
Hi, I'm having an issue with existing Nexel layouts transitioning capsules from Client to Web (now on Board 10.7) - every time the procedure is ran (which includes 'Save data entry' step) Nexel doesn't save to the cube anymore (it only contains the values we prepopulate the cube with to give us a base). My current work…
-
How to convert Board tickbox to a flag in Excel
Does anyone know how we can convert the tickbox column from an xlsx file into a binary flag? When I make column b = a, I get the same whether the column is empty or not. A user exported the file so I'm not sure if they can enter the layout to change the column appearance. Thanks
-
Appearance of inline buttons in dataview on the web
Anyone has an idea how to make inline buttons on the web look like "real" buttons? Unfortunately the web version does not allow to have gradient colors on the custom block formatting. This is what I used in the past to create a 3D effect. Without that, the button looks like a regular text field and it's often hard for the…
-
Mail subscription
Dear Community We have a case where the user does not see any subscriptions under "Show all subscriptions", but he still receives a mail with a pdf. attachement every day. Where do I have (as an administrator) an overview of all subscriptions created? Thank you in advance for your help Regards, Oliver
-
users in permission groups
Hello, I've added an user in a permission group that I'm testing but I don't see any way for removing the user from the group. I'am an admin on the platform. Did you encounter this situation ? thank you, Catalina
-
Server Installer tries to install .NET Framework which is already installed
Hello, I'm trying to install Board 10.7 server on an airgapped server (so it can't connect to the internet during the install process to download .NET framework). We've used the offline installer for 4.8 .net framework, and after some mucking around we seem to have it installed (at least going on the the registry entries).…
-
Nexel won't write back to cubes on the web?
Hi, I have a layout using Nexel (with Allow Write Inplace highlighted) that commits data into a cube using a single rule. This works great in the client. However, on the web, it does not commit data to the cube when a "Save Data Entry" action is performed. Additionally, unlike in the client, the web does not even have the…
-
% of total
How to calculate Value/(total value in column), % ------------------------------ Vasily Feofanov Analyst Limited Liability Company "Super Brands" Russian Federation ------------------------------