-
copy procedure from one capsule to another
would be great if one could copy or save a procedure from one capsule to another where also temporary cubes are copied. That would massively simplify the copying or even moving of a procedure instead of recreating the procedure by copying the steps and re-creating the temporary cubes.
-
Clear Cube Insight
1. Abstract Clearing data in a Board application that has a large dataset, and high concurrency, needs to be done with care to avoid an unintended consequence. The approach you use to clear data has an impact on data retention and can impact performance. The purpose of this article is to review the options available for…
-
Extracting list of cubes via Entity analysis
Currently the list of cubes for a particular entity can be extracted through Impact Analysis which only provides the cube name and not other details. If the user is able to extract the list of cubes via Entity Analysis (by clicking on Go to Cubes), it will provide details such as Group name, Data Type, no. of Versions and…
-
Keep data when adding or removing an entity to/from a cube
As-is status: If you either add an entity to a cube or remove an entity from a cube, the cube will be empty afterwards, containing no data anymore. Idea: It should be possible to keep the data (optional), by either: when adding an entity: choose an element of the entity (to be added) to shift all the data of the cube to or…
-
Improve drop down list.
Context: Currently is it difficult to do a drop down list properly in Board if you intent to work with the stored values. In Layout designer and Data Entry section, you generally use "suggested values from Entity". However, it doesn't work properly if : You have localized the entity but multiple user on the same data…
-
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…
-
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?
-
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.
-
Automation possibilty for "Sparsity Optimization"
We very much appreciate the new sparsity optimization feature that makes manual export/import obsolete. It would be great if this function could also be automated. There are use cases in which plan data is cleared or zeroed out again, for example, but the sparsity remains full. Therefore, it would be very helpful if the…
-
Select entities to clear in a cube
Today we have the possibility, in a Procedure, to clear the Cube with existing selection ("Use current selection") or clear the whole Cube (default). If you only want to clear on specific Entities you will need to setup a save & restore selection and/or de-select & re-select specific Entities. Suggestion: Give the…
-
How to structure cubes with slow moving hierarchy
1. Abstract A common challenge in a Board Application is to fulfill the request of tracking changes in hierarchies, which by definition are the current snapshot of a relationship. This article describes how to keep track of the historical situation using a cube and dedicated entities. 2. Context Since a hierarchy in Board…
-
extract all cubes > create log
Hi, when you execute an "extract all cubes" procedure action, no log is created. it would be really useful to have a detailed log about all the cubes extracted, in order to be able to check if everything worked as expected. consider that the "reload all cubes" already creates a detailed log on the reloaded cubes, so…
-
Saving Time Function Forecast in a cube
Hi everyone. I'm interested in using the Forecast function in a cube that contains information about the sales amount until the past month, in order to obtain a prediction for the following ones. Currently I'm applying this Forecast function inside a dataview, the problem is that it takes too long to load the page. Is it…
-
Temporary Cube vs Staging Cubes
1. Abstract When developers create a simple or complex procedure, they need to know that they have an advanced feature to ease their job by keeping the database simple and lean. This feature is the temporary Cubes. 2. Context Since B11’s introduction, developers can leverage the temporary Cube to store data temporarily and…
-
Cube definition insights
1. Abstract Insights on cubes definition and options. 2. Context The following best practices are applicable every time a new cube needs to be created in a data model. 3. Content Some limitations and constraints but also tips and guidelines from best practices and real-life cases. Cube’s dimensions can range from one to…
-
Multiple Cubes or Measure Entity
1. Abstract Using a measure as a dimension in a Cube should always be weighted based on the aim. The balance between the Cube size and Cube proliferation, how the measure will be shown in a layout, and any calculation between different measures. Board exploits a multidimensional and a multi-Cube database. When designing…
-
Combing data from two Entity Trees
I use board 10.5 + webclient. I have data in Cube X that I need to transfer to Cube Y. Entity Costcenter - Root level has 450 entities that match to 50 entities in Employee - Costcenter. I use a Select in the dataflow for the PL account to only write in 1 certain account in the PL. When I know excute the dataflow the data…
-
B11 - Massive Change Cubes Dimensions
It would be very nice to be able to select more than one cube and to change the dimensions for all the selected cubes. Just in the same way that's done for the Data Type.
-
Can I use a selection when extracting a cube?
Hiya, I'm pretty new to playing around with Board, so forgive me if this is a simple question. I've got a cube in one database with the dimensions of: Period, Branch, Category, GL and Scenario. I want to extract the cube, but only where there are values against Scenario 3, to copy into a cube in another database…
-
How to Find a Minimum Value of a cube through procedures
There is a 3D cube having dimensions (x, y,month) if there are 10 x under 1 y and 1 month how to find minimum of 10 x values for 1 y and 1 month and then the minimum value calculated for 10 x for 1 y and 1 month flow into a cube of 2D y and month
-
Hierarchy data view
How can I view the nodes and child nodes in a hierarchy without using a cube? something similar to the attached image
-
ALERT WITH TEXT
Hi community, is it possible have an alert in a dataview with a cube text Regards Andrea
-
Entity Statistics
Hi all, is it possible to have entities statistics? I would like to know which cubes use a specific entity. Thanks!
-
RDB Cube contents are not displayed
Hi boardville members, i just copied a database and capsules to our dev server. Everything works fine, but all the dataviews with RDB cubes in behind are empty. I already checked and compared the ODBC settings from booth servers. Any hints? Best Paul
-
How can i write my results back to cube using Procedures or nexel ?!
Hello All, I am trying to find out how can i write my resulted Columns (blocks made using Column Algorithm) and use it as a cube... For example : i have Dataview Layout of two blocks A and B present in the data already, i have created one Block, lets say Block C using Column Algorithm (A+B), now i want save this block as a…
-
How to use block created in formula editor as a cube ?!
Hello there , I was just wondering if i could use a block created in formula editor like a cube, for example, 1. as shown in image below, i created a Block called SingleRule_Block, 2.Now i went to Layout and created a C block with Column Algorithm as a/b 3. Now when i see in the DataView, block C does not show me any…