-
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…
-
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…
-
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…
-
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…
-
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.
-
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…
-
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,…
-
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…
-
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
-
How to automate unloading a database from memory
Is it possible to automate unloading a single database from memory? I already start and stop the services overnight but I have some databases that are loaded into memory when data readers run just before the working day begins. They are taking up memory even though they are used occasionally. I'm happy for these DBs to…
-
Change capsule database  doesn't work
Hello, I want to duplicate my environment (capsule and database) so I copied and renamed the capsule and the database. Then I opened my new capsule and changed the database to the new one. but it didn't work for me. All screens still pointed to the old database and what I found strange is that some procedures are pointing…
-
I am not able to delete entities/Groups. Deleted Groups and Entities reappears after clicking on Sav
Hello Team I created database using Data Fast track, now i want to delete the Entities and Group but i am not able to delete it 1. I tried Deleting all the entities One-by-One 2. Then I Deleted all groups 3. But as soon as i Clicked on Save Button, All the entities and groups are re-appearing, Can i know how can i solve…
-
Quick way to fill relationships?
Hello community, is it possible to edit multiple relationships at the same time? It would save a lot of time if I don't have to make each assignment individually. Kind regards Jonas
-
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…
-
Synchronizing time axis between databases in a multi-database screen
Context Very often we have use cases where we need to compare data between two databases. We build two layouts (necessary because different data models) and we put them side by side. Having common selectors is of course not possible in the general case (that's the point of making two DB) but it would be very practical to…
-
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…
-
Should i use Fix Relationship?
Dear everyone, I found some orphans in my database. Should i use 'Fix Relationship' function. Because i found that if i keep the orphans, my report is not correct. Do you have any suggestions? Thanks and best regards William Le
-
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…
-
Search field on cubes
Hi, it would be very useful if you could add a search field on the database cubes. On very large databases, it is impossible to find a specific cube easily. It is good practice to create meaningful groups and sort the cubes in alphabetical order, but sometimes this behavior is not enough. Thank you, Francesco
-
Increase max Number of Cubes
Hi, in BOARD you can create max. 999 Cubes, which is enogh in many projects. But we're facing the problem, that in some bigger Projects we're using a lot tec-Cubes and so it is sometimes hard to be within this limit.So it would be great, if this limits get extended in a future release. Examples for Tec-Cubes (mostly driven…
-
Access Denied: can't access anymore to my Data
Hi! I'm having the following issue: I've been working with a BOARD Database witch I created with an Administrator user. It's the only user I have configured on BOARD. I already made a capsule with some reports, been working with it for a few days. Now, I can't access to the Database. It says that I don't have permissions.…
-
How to discover the OLE-DB connection string
Perform the following actions in order to determine your OLE-DB connection string settings: Create a text file and save it with the extension .udl Double click the .udl file to launch the data link configuration window Specify the connection parameters and click OK to save (be sure to choose 'allow saving password' if the…