-
Standard Deviation
Hi Board Knowledge, does anyone know how to utilise the Analytical function "Standard Deviation"? I am trying to apply it but the results are not correct. I was wondering if anyone has manged to use the default functionality?
-
Cubes groups sorting
Hi wizards of Board Platform. Do you know if it is possible to change the order on which cubes "Groups" appear on the layout config page (on the left when you open the layout of a dataview)? I'd really like one group of cubes to appear at the top of the list. Thanks!
-
Sparsity
1. Abstract During the creation of a new cube, the question is usually about whether dimensions should be dense or sparse. A cube can store a value for any combination of its dimension’s members: for example, a three-dimensional Cube (e.g. month, product and customer), has a cell for any triplet. If every customer…
-
Header Group Row
Dear Community, Is it possible to create a group Header that keeps specific columns together, as below? I am looking for the functionality that will create the DAY – WTD – MTD sections for me, in a dataview. Thank you in advance �� Kindest regards Alicia Meredith-Smith Business Intelligence Manager St Medius House, London…
-
Where's the Entity extract file?
Cloud, Version 12.6 When extracting an Entity, where does the file end up? According to documentation, it ends up in the default download location, but I can't find the file in Z:\.
-
Become a Community Voice or Captain (150 points)
It is always interesting to learn more form our community members. Why not share your thoughts about Board, the Community, your Board project etc. in a short interview-style blog post? All you need to do is answer a few questions. Here is a nice example. As a participant, you will: Make yourself visible in the Board…
-
Display all the mappings of the Mdb items in the data readers
Hello together Is there a way to display all the mappings of the Mdb items in the data readers? Is this information stored somewhere in a folder on the server? Many thanks and best regards Oliver
-
Rest API Integration into a cube in Board directly.
Hi, We have set up a Rest API call that bypasses the pipeline and pulls data from a different model in our Board instance. Is it possible to take the payload(source data) that we get from the Rest API and push it directly to a cube in our datamodel? We do not want the payload to be exported into an output file that is…
-
How to dynamically display the user selected value when a data view is set as master object
On the left I have a P&L hierarchy driven report set as master object. When I click on a row, the charts on the page change. I would like to display the current row that was click on in the master object. Trying this, no luck: @Selection_Ex(Layout="P&L", Block=" ") Version 12.6 Thanks! Matt
-
Level 200 Module 211 Functional Test
The labels are not appearing on the Budget Initialization screen during the functional test. I have checked the configuration and do see both the 'Initialize Budget' and 'Budget is Locked' labels. Any idea?
-
Community Voices: Etienne Causse
The Community Voices series continues this month with a Board Community champion and customer—Etienne Causse. Etienne joins us from Groupe SEB and shares with us highlights of his Board journey and successes, as well his favorite parts of interacting here in Community. You’ll find Etienne interacting throughout Community,…
-
An uploaded zip file - when the user downloads it, how can we control what the filename will be?
A user can upload a zip file to Board. When they do that, the original filename is lost. The new file name is generated how? Can this be controlled? For example, could the zip file have a reference number derived from where it was uploaded in Board? ------------------------------ Michael Gerrard UNHCR http://www.unhcr.org…
-
Localized versions of Level 200 course available in Academy now
The Board Academy developer training course, Level 200: Building a Planning Solution, is now available in three additional languages: German, Italian, and Japanese, with French coming soon. Level 200 is an active online experience during which the learner builds a functional budget planning application in the Board…
-
Drill Anywhere Options: "Drill To" vs "Go To"
1 . Abstract The Drill Functions provide several interactive options, which are: Drill anywhere, Drill-down, Drill-to screen, Drill-procedure. In design mode, interacting with the ‘Drill-to screen’ feature, either in a Data View or in a Chart, there are some notable differences regarding ‘Drill-to screen’ and ‘Go-to…
-
How to compare 2 different cubes to show an alert?
Hi Community! I am working on figuring out a way to compare two different data entry cubes to show alerts. The goal is to have one DE cube to match the sum of by Month DE cube values, and if the sums don't match the alert or notification will appear. Are there any ideas on how would be best to approach this?
-
Order of Reporting Accounts on P&L Sheet
I am trying to add two new lines to the P&L sheet in specific spots, and thought they were ordered by the Reporting Account code number. There does not seem to be a correlation between the code number value and the order. Does anyone know the logic behind it?
-
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…
-
Level 200 Module 205 - Can't enter FX Rates
I am trying to enter FX Rates on the FX Rates screen but I see no data entry fields. I did enable 'Data Entry'.
-
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…
-
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?