Cube

Procedure to populate cube
Hi all, i just want to ask how to do the following thing: basically i have Cube A (1 dimension as Entity ) and Cube B ( Month dimension) i want to create a procedure that can use Cube A to populate Cube B based on a month selection. I hope you can help me with this problem. Best regards, Andrea
Hide specific rows
Hi BOARD Community, I'm trying to create a cube (which has the following dimension "SPV"; "Month"; "Item" and " Class"). The objective is to re-create the excel table attached below I would like to hide some combination (in rows) because i have to do combination on the exact Entities that i have in the screenshot. With…
Extract layout
Hi all, i want to know if it is possible to extract a date cube A (dimension: Entity) on premise: into something like this in a txt or csv file. sv0001 20241107 1 My final goal is to use this file for a data reader to populate a cube B with two dimensions (Entity and Month) with the same values as in the picture. P.S. I…
Best practice data import and update CSV
Hello, I'm new to the board world and am having a bit of a hard time finding the right way to import weekly updated data from a .csv file. What would be the correct/best procedure to import the data and update it weekly. I'm really missing the common thread, where should I start? First create the entities or cubes or data…
Optimal Management of Temporary Cubes to improve RAM Efficiency in Procedures
In my current Board implementations, I rely on temporary cubes extensively due to their impact on readability and performance management. However, I've noticed they can consume considerable RAM, especially during data-intensive procedures. Given this, I’m wondering: does it make sense to clear the content of temporary…
exchange cube on premise
Hi everyone, My colleague and I are currently trying to modify the same data model on our respective PCs on premise. How can we exchange data cubes once we create one? (i don't want to send every time all the database) Thank you!
How to store data in cube structure:Microsoft PowerPoint
How to store data in cube structure:Microsoft PowerPoint I was able to create a cube, but I don't know how to input the data. If anyone knows how to do this, could you please tell me? Also, if you know how to use cube structure: Microsoft Excel, please let me know.
Add Smart import to cube analysis and Impact analysis
A simple idea this time : Currently, there is no reference to Smart Imports when a cube make cube analysis or Impact analysis in the DB. We can see the cube is included on a screen, but no reference about where. Sometimes, the loaded cube is also displayed on a dataview and then it becomes hard to see the difference. Would…
How to create a variance on one cube detailed by version
Hi, I am trying to create a variance column based on one cube that is detailed by version. The problem that we have is we have data in one cube by different versions. We have to create a report to compare versions together but we must be able to select any versions which means I cannot create a block reference on teh cubes…
Show Currency/Unit of Measure next to values
we are having since years requirements that we want to show the currency next to a value or the unit of measure next to a quantity. e.g. Material xy —> purchasing order quantity 1.000 M (meters) No consultant was able to show me a solution so far. But I know this working in other tools (e.g. QlikView).
Is it possible to separate the values of the cube when the same screen is opened in multiple tabs?
Hello. - Hello. As the title says, when the same screen is opened in multiple tabs, Is it possible to separate the cube of selected values used in that screen? Example: "DisplayEntity" member =A,B,C,...,Z,not selected "parent1" member =A~G,H~N,O~U,V~Z,not selected "parent2" member =1,2,not selected Relationship: child…
Hidden Cubes visible for Developer
To hide Cubes for User's is a great function to limit the visible Cubes in Data view layout and Office Add-in. But unfortunately, the Cubes are also hidden for the Developer. Suggestion Make it possible to hide Cube's for different Roles. Add another column (green area) to control visibility for the Admin/Developer.
Copy/Paste Individual blocks from a layout
Hi, It'd be useful to copy and paste individual blocks from one object's layout to another, carrying forward any block references/functions applied to that particular block. This would remove the need to duplicate the same work across multiple objects requiring that same cube; making it more efficient to develop objects…
Binary Cube
Hello, there are many situation where a cube is used to "flag" a certain on/off condition (like SBO, dynamic select, matrix cubes, etc). In most cases people are using integer cubes for this (in B10 a integer cube was 2byte per cell, in b12 it is 8byte per cell). From application point of view one bit (so true or false) is…
Change default Cube Data type to "Double"
A couple of years ago, we were suggested by Board to always use Data type Double, instead of Single. However, the default data Type when creating a new Cube is Single. I would also assume Double is the most common Data Type used in Cubes. That makes it more relevant to show Double by default. Suggestion: Change the default…
How to manage three different rules in the same layout
Hi, I'm in the situation described by the title. The rules are based on the same entity, but I want to use them in the same layout due to the type of calculation the user selects. Have you got any tips?
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…
Rest API: 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 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??
"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.
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.
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.
Quickly adding/dragging of Entities or Cubes within the Mapping page of DataReader
Just to make life easy, we should have a checkbox beside each entity/cube which should allow the developer to select multiple entities or cubes with the help of ☑ or [Ctrl + select], and then drag it at once. This should be applicable for all versions including Board 14.
Repeat by Cube Feature
The "Repeat by Cube" feature is a transformative tool that addresses the challenges of report bursting when exporting data. By organizing and pairing related entities within a cube, it enables users to manage and analyze data more effectively, significantly enhancing the efficiency of report generation. This innovative…
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…
How to flow data among blob cubes using dataflow procedures ?
.

Cube

Discussion List