-
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…
-
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…
-
Show cube tables
Hey, quick question, is there a way to see the cube tables inside Board? It wasn´t me creating them, but i need to work with some of them and I also wanted to see the tables for understanding. Thanks again for your help and have a nice day !
-
Clear cube applied on groups
It would be useful if the Clear cube function can be applied to cubes groups.
-
Cube Title as a Combobox
When I view the structure and versions of a cube, the text box can be changed to change the name of the cube. This is helpful when setting up new cubes, but doesn’t facilitate reviewing multiple cubes quickly. I would like to see a selection arrow at the right end of the text box that allows a user to select a different…
-
Cubes tab to show Cube Entities and Sparse Structure
In bigger projects where you have a large number of cubes, it is often required to review cubes structure. i.e. Cube Entities or Sparsity. At the moment, the only way to do this is to click on Cube and open Cube structure window. It would be nice to have another column on "Cubes" tab showing Sparse structure and Entities…