-
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…
-
Community Roundup: October 18, 2023
The Community team is back and excited to share with you the new features we've launched and the accomplishments we've enjoyed in the last eight weeks! From new tools, to streamlining navigation, to Community member outreach; we've had a busy eight weeks of growth and evolution. The new features and Community…
-
How to do multi level allocation
1. Abstract A Multi-Level cost allocation is an important process of any business, it plays a huge role in the decision-making process, and that’s why we must design it in the best possible way. The Multi-Level cost allocation consists of applying a classic allocation but with the possibility that an element can be at the…
-
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…
-
Level 200, Module 205: Procedure ACT Sales Data Upload not in the Procedure dropdown option
I created the procedure ACT - Sales Data Upload but it is not in the procedure dropdown when I created the Call DB Procedure. It is grayed out. What did I miss?
-
Allocation with Board
1. Abstract Board is a great platform for building a planning and budgeting model and it accommodates large and complex allocation models. Board can process a lot of data in a short amount of time. The platform is also very flexible and allows the full customization of your allocation model. 2. Context Board is a great…
-
Data Access Control Architecture
1. Abstract Database and Application security refers in general to the range of tools designed to establish and preserve data confidentiality, integrity, and availability. In Board terms it is the definition of the various access levels so that the users are presented and can modify only data relevant to them and for which…
-
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
-
Improve the Community experience with Accepted Answers
Members make Community great, and we’re thrilled about all the engagement we’ve seen since re-launching the Board Community in early February! Both the Platform Forum and Academy Forum have been buzzing with activity, and we thank all members for their dedication to timely and detailed responses to questions posted.…
-
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.
-
Level 200 - Training Env not loading
Anyone can help with this issue? My training environment doesn't seem to load today. It was fine until yesterday.
-
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?
-
Table of Contents: How-to Guides
Welcome to Board How-to Guides! Here you will find links to published How-to Guides that provide step-by-step guidance to support specific use cases, as well as a preview of what's coming soon. The table of contents for Best Practices—best ways to use the platform in most situations—can be found here. Time Range How to…
-
Table Of Contents: Best Practices
Welcome to Board Best Practices! Here you will find links to a list of published articles that provide technical guidance on the best ways to use the Board platform and a preview of articles that are in progress. The table of contents for How-to Guides that provide step-by-step guidance for specific use cases can be found…
-
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
-
Level 200 Module 209 - Timestamp Instructions Incorrect
I ran into issues for both the upload and publish timestamps in the Expense training. The training says: - set expression to "@Date&" at "&@Time&" by "&@User" You need to remove the quote at the beginning and end of the phrase to make it work: - set expression to @Date&" at "&@Time&" by "&@User
-
Level 200; Module 205; final check is not balancing
Upon the final check of data, everything lines up well, except for the GBP Sales Actuals Data screen. I have walked through the module and rebuilt the entire procedure and data view several times, however am getting the same results. The GBP report doesn't appear the same as the LC report in the numerical presentation. The…
-
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…
-
How to manage mapping Data Entry
1. Abstract In many cases, mappings are used to control processes. Mostly, these are mappings between entities that cannot be implemented in the standard relationships (hierarchies) for various reasons (e.g. they are not n:1 relationships, or the hierarchical trees would become too large to be useful from a performance…
-
Level 200 module 212 - 1: Product to GL Account Mapping Cube Empty
Am I missing a data reader where we'd load Product Category & Account through a data reader? I would think it would just pull in the values, matrixed, and let me check yes/no. I'm prepared to feel dumb on this one! But I built the screens and don't see any 'box' to check for that single value cube in step 3.2 Thanks! Matt
-
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
-
Module 205 in Level 200 Building a Planning Solution in Board
Has anyone else picked up on this issue below in module 205 of Level 200? In the Academy, module 205 there seems to be a fault. The “ACT – Sales Data Publish” procedure where it calculates ACT – DF – Sales GBP, does not calculate as per the screenshot. In order to make the data flow work properly I needed to split it into…