-
Adding Cube Precision Control to Avoid Floating-Point Errors
Hi everyone, I propose adding a feature to handle decimal precision in Board, especially for totals and calculations. Currently, floating-point errors can cause totals to display as 0.0000000000xxx instead of 0, which leads to issues in data entry and result splits. Suggested Solution: Allow users to set precision limits…
-
Ability to present the dimension flagged in a cube as an output on a block
This may be a bit more challenging but if there was an ability to present the name of the member flagged rather than showing the value of 1 when a cube has more than 2 dimensions. Eg asset 1 is mapped to jan, when asset is in the rows, have an option where i can select "month" as an output in the block settings, similar to…
-
YoY Growth
I am creating an application where I have to show YoY growth of every expense present in dataview. What's the best approach I can perform to add YoY growth percent below every expense without adding that member in the entity already used. Attaching the screenshot for the reference.
-
YoY Growth Calculation
I want to calculate the YoY growth of every expense mentioned in the cube and want to show it in the dataview. attached the screenshot of the view I want to show in the screen.
-
Rich Text (text formatting like Bold, Italics..) in Text Cube
Hi team, Can we please enable Text formatting in Text cube? Though we have RTF cubes for the same, they store the text as an object and will be visible only when the cursor is moved on it. It would be easier for users to format and highlight their comments if Text cube gets an option to store text formatting
-
Cubes
Let's suppose I have a cube with dimensions month, scenario, version, competency and another cube with dimensions month, scenario, version, los, location. The end cube in which I am storing the value also has location at it's dimension. LOS and competency entities are in relation LOS being the parent and competency being…
-
copy "date" type cube into a "text" type cube
Hi All, I’m looking for the correct formula to use in this dataflow: Cube D is a "date" type cube. Cube E is a "text" type cube. Don't worry for The selection I’m unable to find the correct formula in the IF Statement to paste the value into the text cube (TEXT(D),"DD/MM/YYYY"). As a result, the output of the dataflow is…
-
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.
-
date cube : data entry
Hello everyone, I am facing an issue related to the use of a date cube. In a layout, I have a date cube (structured with only 2 dimensions, including the year) open for input, which allows identifying the start of an allocation on a specific day. The default year displayed is the current year, but I would like to display…
-
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??
-
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.
-
"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.