-
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…
-
Summary Algorithm NOTOTAL for Column Algorithm (Layout)
Hi all, it would be great to have the same function (NOTOTAL) for column algorithm as in the data selection. Attached you will find a screenshot. Use Case: Column algorithm calculates a percentage of a data selection. Down totals for data selection are required, but down totals for column algorithm in this case makes no…
-
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'.
-
Smart Import tick/save - change to "Import"
The Smart Import has a tick button to import the lines. This button has a tooltip that says "Save". This is not true, it isn't saving, it is importing. Can you please allow for this button to be changed to "Import" or at least if the tooltip could be changed from save to import, at least that would help a little. It's…
-
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…
-
(SOLVED) Count contents of a BLOB cube
*** See solution in comments below *** Original Idea: I would like to be able to count the contents of BLOB cubes - I want to know how many records they hold and I want to compare this information. To give some context. I have a blob cube which contains property images. Not all properties have images. For those that do,…
-
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…
-
IF THEN ELSE
In the if-then-else step in procedure, A feature can be added where we can compare the value of two cubes instead of just numbers. It might save lot of efforts.😀
-
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
-
Drill Through - footer conditions in query
For now its possible to define 'Where' conditions only. It would be helpful to define footer conditions too. Examples: GROUP BY ORDER BY LIMIT FETCH FIRST X rows only ... Applicationexample: Our users can do a drill through on P&L Lines and can get all booking details --> its a large table in datawarehouse. In some cases…
-
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.
-
Add setting to allow horizontal display of "@Selection" substitution formula
In the image below, I'd like to display all of the selections horizontally on the grey banner, which is not possible using the substitution formula "@selection". Current workaround is to create multiple labels for each entity selected (8 in this example) and individually place them side by side on the banner which can be…
-
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.
-
Option of restricting elements for selectors
Up to now, for a selector, there was only the possibility to display all elements or only the active elements. However, I had the requirement in many projects that the selectable elements should be restricted depending on other filtering. Reasons could be for example: Elements of entities are no longer valid, but should…
-
Number Scaling - formatting options
The new function is pretty good - but it would be really good, if there would be some formatting options for the number scaling —> e.g. k instead of K or T instead of K etc. Also deactivating the suffix would be great - so just having the value without K/M/B
-
Database Security / Transporter
Hi All, it would be really useful if the Board Transporter Tool would consider and work also with the Database Security Profiles. There are many alternatives (especially for customers working with the Subscription Hub) but it would be a great enhancement. Thanks, federico
-
Enhance user experience by adding search functionality
Sometimes, when working with databases providing more than just a couple cubes or entities, finding the cube or entity you're looking for in the drop-down lists can be pretty cumbersome when no search function is available. Consider this example from the action library for calling a procedure If, however, developers would…
-
Extract Cubes in Parquet-File
1. What is your idea? Board has multiple steps to extract data from cubes: Extract Cube Export Data View to file Export Dataset Extract all cubes All these steps save data as text or csv-files. We could save disk-space and increase performance by using parquet-files. Head-to-head comparison CSV Parquet Row-based storage…
-
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…
-
Option to Hide Tabs
Dear all, The tab container is probably one of the most used objects across many applications and in my experience an absolute customer and user favourite. Sometimes, it is necessary to remove tabs for a certain situation but you want to keep the contained dataview for future use. Saving a backup screen, deleting the tab,…