Database

Directly load unbalenced hierarchy (UBH) datareader via datasphere (DSP) connection
Dear all, the last months we have a big project to switch from SQL to Datasphere (DSP) as a data source for our transactional and master data. At this point there is only a workaround available to load unbalanced hierarchies (UBH) via datasphere (DSP) connections. As we have many unbalanced hierarchies (UBH) in use, we…
Speed up procedure development with virtual cubes “on the fly”
Hi @Product Management Team , at the moment, every time you realise that you need an additional virtual cube, you have to exit edit mode, switch to options, create a new virtual cube, save it, save the procedure, switch back to edit steps mode. And only then you can define the new data flow. It would be much better if a…
B14: Add the possibility to comment on procedure groups
Hi Team, since it is now possible in B14 to collapse/expand groups of procedure steps (which is much appreciated), it would be really helpful if those groups could be commented on as well. This would help in understanding what a specific group is supposed to do even when the group itself is collapsed. Thus, it wouldn't be…
B14: Display correct information in If-Then-Else step
Hi Team, whenever an If-Then-Else step is created in a B14 procedure the system doesn't display the information correctly: The display in the list of actions will look like this Please display the information correctly and add the "Else"-information (whenever there is an else-step). Currently, the information is updated…
Database security: Cube visibility
In the "Database Security" section, we have noticed that if we use cube visibility to define user action perimeters, it works everywhere except in dataflows. This behavior, despite being documented in the manual, seems quite illogical because if the functionality helps in profiling security profiles in a faster and more…
Level 200 Module205: Italy Not populating
In the section where you create the procedure within the capsule, the UK data will load, but the Italy data will not. I have checked the procedure within the data model (ACT - Sales Data Load), and the path/file is set to ALL. In the MAIN group, create a "Text file data reader" step for "ACT - Units and Sales". Set the…
Automatic back-up scheduling
It would be useful to have the ability to schedule backup storage with variable frequency. In particular, in the administrator portal of the cloud environment, in the "capsule organizer / manager" section, it is preferable to have the possibility to automatically download via scheduling the .zip file which collects all the…
ALM - Merge Branch
At present, developers can only develop together on one MasterDB. This can lead to problems in large projects with many developers. Example: Developer 1 starts a procedure to calculate values in a cube. Developer 2 has to empty an entity that is contained in the above-mentioned cube. For example, because the MaxItem number…
separated area for "in ram databases" and "pending changes" lists
ciao, sometimes the Board Administrator need to check whihc are the databases currently uploaded in RAM and/or the list of the "pending changes" for a specific database. currently these informations are in the "Logs" section BUT in big environments, with a lot of users/actions, you could have a lot of logs for the standard…
Dataflow Algorithm Visibility and Optimization (HBMP / Tuples ...)
Enable users to visually inspect dataflow algorithms in the procedure without executing the entire process and reviewing database logs. Additionally, provide automated suggestions for optimizing dataflow performance based on usage patterns and efficiency opportunities. This feature enhances performance management within…
Transferring data directly from one database to another
Situation: Assume that planning takes place in different databases for various reasons. Now the results of the planning are to be merged into one database. One possibility is to extract the data from the planning databases into a CSV and read it back into the reporting database. Request: It would be nice to have a function…
Annotation of Entities, Cubes, Data Reader and other Database structures
I wish there was a way to annotate entities, cubes, data readers, and other database structures as there is for procedure steps. This would enrich the in-system documentation for developers and could eliminate the need for out-of-system technical documentation. Documentation would thus be made faster and more efficient.
Cube Visibility & Cube cells locked by
Cloud version: 12.6 0288217 Hello, I can't get Cube Visibility (Deny cell editing in Database Security) combined with Cube cells locked by to work, even if the cubes are not conflicting. This is the error message shown on the Screen when you log in as a User (not Developer). The error message itself is not explanatory. Is…
Renaming database procedures
I would like to be able to simply rename database procedures.
The Database size got reduced from 24 GB to 19 GB after extract and reload of the database
Recently i performed Max item number change for few entities and for that we extract all of the database and do this change and then reload the database. There is no loss of any data for me, nor there is any issue but the only thing i observed was after the reload of the database the size of database got reduced to 19 Gb.…
Default Database Security Profile while creating a new DB - ADMIN
Dear Team, Currently when we create a Database, it is setup without any Security Profile. Could we please look to add the step of adding a default Database Security Profile - ADMIN at the time of creating a new Data model. We could have this done behind the scenes as soon as the developer finishes setting up the time range…
Pagination for API-Queries
API-Queries are a great way to expose Data to other Board-Systems or third-party-applications. Big Data-Sets could end in Time-Out. It would be helpfull to cut big datasets in smaller pieces with pagination. Please have a look on Pagination on REST API call Procedure step.
Data Access Control Architecture
1. Abstract Database and Application security refers in general to the range of tools designed to establish and preserve data confidentiality, integrity, and availability. In Board terms it is the definition of the various access levels so that the users are presented and can modify only data relevant to them and for which…
Database Security / Transporter
Hi All, it would be really useful if the Board Transporter Tool would consider and work also with the Database Security Profiles. There are many alternatives (especially for customers working with the Subscription Hub) but it would be a great enhancement. Thanks, federico
Extract Cubes in Parquet-File
1. What is your idea? Board has multiple steps to extract data from cubes: Extract Cube Export Data View to file Export Dataset Extract all cubes All these steps save data as text or csv-files. We could save disk-space and increase performance by using parquet-files. Head-to-head comparison CSV Parquet Row-based storage…
More options in the BULK INSERT function
I think that the BULK INSERT function, has a lot of potential, whatsoever, it is very limited right now, it would help a lot to add more functions other than INSERT INTO. For example right now I'm trying to upload the hierarchies of our database to a SQL Database, if instead of INSERT we could also have access to the…
Dynamic Database Time Range
I would like to have the possibility of having a dynamic time range setting i the database. For example, saying that your model should always contain 2 years of history and future months and that it is updated automatically. This way we could avoid unnecessary maintenance work of the databases.
Synchronize multiple data model
1. Abstract In the case of an architecture with several data models, the synchronization process may be required to update metadata and data. Defining which data model should be the master and how to set up synchronization is of primary importance. 2. Context In complex and cross-functional applications, having a single…
Managing high-volume entities
1. Abstract In complex environments, it happens to manage elements with a high volume. In such cases, it is crucial to identify the possible cascading effects on the rest of the model and what measures need to be taken when loading entities with millions of elements and evaluate in advance the possible impact on cubes,…
ROLAP Cubes on Oracle DWH and Timeout issues
This article is intended for all customers using Oracle Datawarehouse to receive information from Board through ROLAP Cubes. This is applicable also to other Datawarehouses whenever you are encountering timeout issues. When connecting to an Oracle DWH, timeout is a very important matter. Usually, Oracle native ODBC take…
Change Time Range Entitie
Hi All, We accidentally added two members to the time range entitie "Year". Is there a possibility to delete the members without "Clearing the database and Reset Time Range"? Because it is not possible to delete the member manually. Thanks in advance! Robin.
Database object audit
Is anybody aware of the optimal way to get a list of DB related objects e.g. entities; cubes etc. Likewise for capsules and their associated objects e.g. db's; screens; screen triggers; procedures etc.
Comment on cubes
Hi all, I'd like to have the possibility to insert a comment on each cube (and maybe entities), mainly in order to clarify their use in the database and their content. It would be enough to reproduce the possibility already available for the step of a procedure. This becomes crucial when dealing with large database, where…
Transfert Data Reader only
Hello all, For a project I need to update my Data Readers from a server #1 to a server #2. But I want to keep my database on #2. Is it possible to transfert only Data Readers ? Where are the files to transfert ? Thanks for your help, Julien

Database

Discussion List