-
How can I calculate difference between two dates?
I want to calculate the difference in days, hours, minutes and seconds between two datetime stamps and I would be very interested to know how others have approached this. Currently I seem to be contemplating a solution which first subtracts one date from another to get a decimal. Then I would convert that decimal to days,…
-
Clear Cube Insight
1. Abstract Clearing data in a Board application that has a large dataset, and high concurrency, needs to be done with care to avoid an unintended consequence. The approach you use to clear data has an impact on data retention and can impact performance. The purpose of this article is to review the options available for…
-
Line break in Tooltip and format options
Tooltip should automatic create line break if original text has no break in it. Furthermore a format option for size and colour of tooltip text would be appreciated.
-
Export List of Scheduled Tasks from Cloud Admin Portal
Can an option be provided to export the list of tasks setup in Cloud Admin Portal either to CSV or Excel? It will be useful for audit review as well as determine if any task schedules are overlapping.
-
Extracting list of cubes via Entity analysis
Currently the list of cubes for a particular entity can be extracted through Impact Analysis which only provides the cube name and not other details. If the user is able to extract the list of cubes via Entity Analysis (by clicking on Go to Cubes), it will provide details such as Group name, Data Type, no. of Versions and…
-
Compare date in column algorithm
Dear All, I have 2 cube, the first cube is a date cube with one dimension is article, the second cube is single cube with 2 dimensions are Month and article. I want to make a new single cube with 2 dimensions are Month and article. i want to fill the value in new cube by second cube with the logic is if the month in second…
-
Connect Power Bi Connector to Local host
Hello, Is it possible to connect Power Bi with the local host server?
-
ALM enhancement to update connection details with SAP DataReaders
When deploying a DataReader that uses the connection type SAP via Board SAP Connector the URL to connect to the source is not updated accordingly. Although the connection string looks correct the process is executed on a different server (QSS in this case). You'll have to manually change each DataReader (adding a field to…
-
Start screen in Google with Board user and password
Hello all, we will start one screen in Board with a desktop shortcut. The problem is, that we must enter the Board user/password. Is there a way to pass on the board user and password? Kind regards Stefan
-
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.…
-
❓Follow-up with Security Filters and Refers "To"
A coupe of week ago, I post this (also ticket 00095180 ) However now that the 17 novembre patch fixed the issue we finally resume testing on the security again. While the patch improved on the situation we have one edge case that seems strange : when a user end up with no value in the entity Etablissement in his security…
-
Relationship changes logs
Hi Board Expects. Quick question: does any of the log files provide the details of relationship changes between entity members? A DB log shows the entity names and shows the record that the relationship was modified. Can we see anywhere the members of child and parent entities? Eg. we have Item → Item Category…
-
How to make multiple relationships coexist in the same hierarchy
1. Abstract Establishing and managing relationships effectively is crucial for the optimal performance of a Board implementation. In numerous instances, it becomes necessary to accommodate multiple relationships within the same hierarchy. Therefore, it is vital to make informed decisions when constructing the…
-
Board Hackathons
Anyone ever participate in one? How was it? It seems there have been three in France so far (2020, 2021, 2022). I'm curious if Board is planning to bring the same format to Germany or UK any time soon … Thanks for your input !
-
Level 200 Module 210 why the data won't populate when i select the country UK in exp planning scree?
-
Dummy entity elements for budgeting purposes
1. Abstract In planning processes, sometimes it is necessary to manage new occurrences that don’t exist in real life yet, which means creating provisional elements in the master data that will serve only for planning purposes. 2. Context Creating provisional elements in master data for planning purposes means creating new…
-
Impact analysis: Oops we are yet ready to analyze this Datamodel..
Hi all, After a restart of the service, i receive this message when i navigate to the impact analysis (never seen this before). Also, when looking at the analysis of my cubes, everything is 0. Is this normal? How can i solve this? I've been waiting for a while already.. Andries
-
Just for Fun: End of Year Celebrations!
Hello, Community! Can you believe it's almost a wrap for another year? Seriously…where does the time go? This time last year, we were in the thick of planning and preparing for a Community migration. Fast forward to 2023, and we did it—delivering a new platform with more ways to interact, new opportunities to share…
-
Fix Entity in Quick Layout
Would be great if we could fix dimensions within the quick layout. This is very important to allow mid flexibility within the quick layout function. Its specially important when we have a rule within one of the dimensions, that must always be there to be able to display data correctly.
-
Keep data when adding or removing an entity to/from a cube
As-is status: If you either add an entity to a cube or remove an entity from a cube, the cube will be empty afterwards, containing no data anymore. Idea: It should be possible to keep the data (optional), by either: when adding an entity: choose an element of the entity (to be added) to shift all the data of the cube to or…
-
Integration with R - Load data doesn't work properly
Hello, I experimented the following problem. After execution of R statements, the DataReader doesn't work properly, but laods only a few items. I'm sure that R dataframe has more the 100 items, because I write them on a file. After the data loaded, DataReader show as number of rows loaded the right number, but in the cube…
-
BOARD utilizing AI (Artificial Intelligence) and ML (Machine Learning)
Hi, Are there any instances of BOARD utilizing AI (Artificial Intelligence) and ML (Machine Learning) capabilities in any demo across any sector/ industry? We work in the fashion retail industry and have been constantly asked this question in many of our Pre-Sales meetings. Any help/ lead on this regard is highly…
-
Adding entity variables to pdf / printable export
Hey guys, I have customers that are exporting a lot of reports for their customer as well. So it would be good to write down the selected entities inside the name of the pdf file, so they dont have to do it all the time for themselves. Greetings Julian
-
SubHub : Sync To Data Model : 3 improvements
Ability to have different mappings per server. If you are developing changes in the security as require by a new organisation in the company and you already had metadata sync to entities in your datamodel : current solution can be a pain to develop the changes. To do so, you may want to keep using the same targeted entity…
-
Connect Board to Fabric Warehouse
Hello, We would like to use Fabric with its Warehouse for our Board Data. How can we connect Board to it? Kind regards, Marco Oerder
-
Copia e incolla da 1 cella di Board a più celle in Board
Buongiorno a tutti, il cliente ci ha fatto notare che non è possibile copiare un dato presente in una cella di board ed incollarlo in più celle contemporaneamente, similmente poter copiare una riga di dati e di applicare la copia a più righe selezionate. Si tratta di un'idea molto interessante e il cliente ne sarebbe molto…
-
How to allocate production by CM1
1. Abstract This technical article describes a way of dealing with row-by-row calculation in Board without using Nexel. Nexel can be used for small examples but does not have a good performance in mass calculations. Keep in mind that not all row-by-row calculations can be transformed into “dataflow-only” calculations. Even…
-
How can I access +Rule to access rules configuration.
I am trying to create some rules for board reporting but cannot find the window where I can create rule.
-
BFC Adjustments and Eliminations
Hi, We are trying to use the investment elimination and equity elimination functions in the BFC application. The output that we are getting is not showing us what we expect. Has anyone worked with this before that can give us some guidence here?
-
Aligning numbers when there is a negative
this might already be an idea, and I might have missed it, but is there a way to ensure numbers with negative parenthesis align when exported? Today, we get this: (1,234) 1,234 Where the Last parenthesis for the negative value sits on top of the positive value. Thanks! Matt