-
Temporary Entity
Just like we have temporary cubes in procedures sometime we need dummy entites of one or two members may be more depending upon calculations, so like temporary cubes how about having temporary entites??
-
Clear cubes selectively
In addition to clear an entire cube it would be convenient to be able to clear a cube selectively, for example: select one or more elements of an entity or select elements of more than one entity before clearing the cube.
-
"Save as"-option for cubes
Procedures, Data Reader, Screens can easily be duplicate by using the "Save as"-option. This functionality would be helpful for the creation of cubes as well.
-
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…
-
Additional output/storage formats for REST API call (e.g. temporary cube)
The only output format (right now) for an REST API call is to save it to an CSV file. This CSV file can be used to load an temporary cube. A direct load (without saving the file to disk) into a cube / temporary cube would be a great enhancement.
-
Temporary DataReader in Procedures
Hello together, to reduce the number of DataReaders, it would be helpful if DataReaders can be created temporarily in a procedure. This would also significantly increase flexibility in combination with temporary cubes. Best regards Christoph S.
-
Data Model object comments
For Data Model objects it would be informative to have to possibility to add comments and notes. For example a Procedure, under “Options” or a new tab, give the developer the possibility to write comments i.e. the purpose of the procedure, when it was last updated, who created/updated it. It could either be one big…
-
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…
-
Quick preview of the data in a cube
To get a preview of the data in a cube we have to create a screen containing an appropriate dataview. In order to get a really quick preview of the data in a cube it would be helpful to have the option of saving one or more views of the cube data as part of the analysis of a cube (screenshot below). It should be possible…
-
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.
-
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…
-
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…
-
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…
-
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…
-
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…
-
cubes don't shows
Dear Alexander Kappes after starting a database on board server 10.1.4 after making an upgrade and trying to show the cubes, a problem occur mentioning the following error message: BOARD CLIENT WORKING IN FAULTED STATE, PLEASE RESTART BOARD CLIENT AS SOON AS POSSIBLE. but the restart do not fix the problem, after cheking…
-
Creating a History Cube
I have a temp cube which calculates an average usage over a dynamic rolling period. This is recalculated daily. For reporting purposes, I now need to write this entry into a history cube by day, so that I can trend the results. The temp cube is dimensioned purely by "device code" which is the entity it is calculating the…
-
user session & user stored cubes to help with user experience
The idea is to have cube where the user is dimension managed automatically by Board and invisible to the user himself as it set on himself (@user) for everyone. The purpose is to improve user experience by remembering his choice and his preference. I can see at least to useful variation : * User session are cleared when…